Getting SQL Or Database Status On Webpage.

Feb 27, 2007

Hi is it possible to have a page of a website display the status of a database or MS SQL with .Net code ?, if so what code would i use.
 Any help would be appreciated.

Thank You 

View 6 Replies


ADVERTISEMENT

Order Status Like Webpage

Jun 18, 2008

We are an accountanting firm who wants to upload tax returns in the .pdf form for our clients. We want them to be able to login, receive that status of their return, and if completed download the .pdf. But what we cannot have is everybody having access to everybody's returns, it has to be exclusive to that client and their username and password. It also has to be a simplified process where once a .pdf is made, one of the employees will have administration access to upload the file to the website corrolating with a clients information. I'm assuming that would be done by a web application?? I have already set up a a login control, on the login.aspx page, along with the ASPNETDB.MDF through the ASP.NET Configuration tool. Also, I'm assuming the file naming process of the tax returns would fall into play somewhere?? I some how need to take the login information from the ASPNETDB.MDF and relate it to their PDF's. What I have explained is the major purpose of the site and if I could find the right help I would greatly appreciate it because I've been stuck on this road block for awhile.

Thanks,
Chris120590

View 7 Replies View Related

Updating Database Via Webpage

Oct 11, 2006

Hello

I am happy with my mySQL install. I can quite happily created tables and fill them with initial data using mySQL Client

What I want to do now is via a web browser be able to add data to various tables etc. I need to make the web entering part of it as simple as possible for the users.

Cheers

View 3 Replies View Related

Backup Sql DataBase From Asp.net Webpage By End User

Apr 7, 2008

hi this is raja sekar.k from bangalore,i need to know how to make a webform with the "BACKUP SQL DATABASE " from a user.. if it is possible.. please help me ..thanksregards Raja Sekar.kChola software consulting pvt ltd..Bangalore

View 2 Replies View Related

Question About Uploading A File From Webpage To Database

Oct 7, 2005

Hi all, I want to upload a text file from a webpage and save the content to our SQL Server database, a BLOB image column.  I got an error on [myData] in the following sqlparameter: Dim parmBlob As New SqlParameter("@AppResume", SqlDbType.Image, myData, ParameterDirection.Input, False, 0, 0, Nothing, DataRowVersion.Current, myData) - Value of type '1-dimensional array of Byte' cannot be converted to 'Integer'  How to fix it? Also,Did I do the right code to upload a text file? Thank you. --------------------------------------------------------------------------- Sub UploadResume_Click(ByVal source As Object, ByVal e As EventArgs)     Dim ResumeFile = uploadResume.PostedFile     Dim contentType As String = ResumeFile.ContentType     Dim contentLength As Integer = ResumeFile.ContentLength     Dim myData(contentLength) As Byte     ResumeFile.InputStream.Read(myData, 0, contentLength)     If Not (uploadResume.PostedFile Is Nothing) Then       Try         'upload file to SQL Server         If Not conHRISDb.State = ConnectionState.Open Then           conHRISDb.Open()         End If         Dim strSQL As String         strSQL = "Insert into Mgmt_App_Resume_Table (Applicant_ID, App_Resume) Values (@AppID,@AppResume)"         Dim objComd = New SqlCommand(strSQL, conHRISDb)         Dim parmBlob As New SqlParameter("@AppResume", SqlDbType.Image, myData, ParameterDirection.Input, False, 0, 0, Nothing, DataRowVersion.Current, myData)         objComd.Parameters.add(parmBlob)         objComd.ExecuteNonquery()         conHRISDb.Close()       Catch exc As Exception         conHRISDb.Close()              End Try     End If   End Sub

View 1 Replies View Related

Create A Custom Webpage To Edit/update A Table In A SQL Database.

Aug 25, 2007

Hi everyone, this is is my first post, so please reply and help.
I'm working on a project right now that uses asp 2.0 and SQL server 2005 express edition. This is a general idea of the project. In our company some of us receive ECO notifications (engineering change orders) for our products and we need to implement these to the test scripts that are on the production floor.  So the project is about entering the new ECO into a database which will send an automatic notification to our test team. When they receive the notification they will have to sign in to the website and introduce their login and password to sign off the ECO (Following some checkpoints already defined by me, for example, Area ready, Test script modification necessary, new firmware introduction, comments, etc...) but I also need to record WHO and WHEN sign that ECO. We have 3 different test areas in our factory: Electrical, Functional and Systems, so all THREE areas must be signed off in order to the ECO go to a IMPLEMENTED state (at this point i need to send a new email saying that the eco has been implemented in all three areas).
 So far I've completed the following things:
-users validation (logins, areas)
-New custom entry form for the ECOs and automatic email notification (part of what I did is described below). Dim ECODataSource As New SqlDataSource()ECODataSource.ConnectionString = ConfigurationManager.ConnectionStrings("ECO_ICSConnectionString1").ToString()
 
ECODataSource.InsertCommandType = SqlDataSourceCommandType.StoredProcedure
ECODataSource.InsertCommand = "EcoNew"
 ECODataSource.InsertParameters.Add("EcoNumber", EcoNumberTextBox.Text)
ECODataSource.InsertParameters.Add("EcoDescription", EcoDescriptionTextBox.Text)
ECODataSource.InsertParameters.Add("EcoMandatory", EcoMandatoryDropDownList.Text)
 -Depending on which test area is the the engineering from, I can filter the ECOs and just shows the ones that their test area is pending. (using GridView)
But I'm stuck right now when the engineers have to sign the ECO for their test areas. I was able to use the Gridview and DetailsView to EDIT most of the things that I need. But there are somethings that I don't like:
1. When using the EDIT option on Gridview or Detailsview, all fields can be edited including ECO number, description and mandatory, which I don't want them to change. If I set those columns to read only, when editing that row again. It gives me an error that says that the ECOnumber can't be  NULL, but if I remove these 3 columns the Engineer will not know which ECO they have sign. They are only going to be able to see the EcoId, which doesn't say much.
2. Also I saw that I wasn't able to do is to enter the USER login and CURRENT system date and time automatically. I don't want them to manually enter the date and their login manually.
3. Finally, when the last area signs the ECO, I want to update that record and set a flag that tells me that the ECO has been completed.
 So what I really want is to create some sort of form (textboxes, labels, checkboxes, etc.) that will UPDATE the selected ECO from the gridview for instance. So when I select the row from the GridView, It will show the data (Econumber, description and mandatory as READ ONLY) and use the rest of the things as INPUT for the engineer to complete. At the end an "update button" and when I click it, It will enter/update the data on that specific row, but including the time and user login as well.
Also to check if the other 2 areas have signed and if so, change the ECOReadiness flag to 1 and send the email.
Is there a code like the one I used above to do this ? Or if you think there a better way to do this, I'll be very glad to hear it.
 I'm new using sql and asp, so If i'm asking some dumb questions please forgive me. .
 
Here's my table definition for your reference:
EcoId - primary key.
EcoNumber
EcoDescription
EcoMandatory
EcoReadiness   <- Flag for the entire ECO, when ALL 3 areas have signed, this will be 1.
ATE < - Flag for Electrical area.
ATEscripts < - Just a Yes/no input.
ATEengineer <- user login
ATEdatetimestamp <- Date.Now()
FAT < - Flag for functional.
FATscripts
FATengineer
FATdatetimestamp
SYSTEMS < - Flag for systems.
SYSTEMSscripts
SYSTEMSengineer
SYSTEMSdatetimestamp
 
THANKS IN ADVANCE,
Regards,
Jesus

View 2 Replies View Related

How To See The Status Of All Triggers In A Database

Aug 23, 2001

I used the sp_msforeachtable stored proc to disable all triggers in a database. Once the command is complete, I want to see the statuses of all
these triggers . I am used to an Oracle database so I miss the data dictionary views that easily show this info. Also, I need to view the statuses of all FKs once they are all disabled as well.

View 4 Replies View Related

Suspect Database Status

Feb 14, 2008

Hello,

A hard drive crashed on one of our MS SQL Server 2005 and brought the server down
with it. We had replaced the hard drive and rebuilt the RAID 5 container and got the server rebooted.
However, one of the databases got corrupted after that. THis is the error logs snippet:
===============
,An error occurred during recovery<c/> preventing the database 'survey_p0765392' (database ID 439) from restarting. Diagnose the recovery errors and fix them<c/> or restore from a known good backup. If errors are not corrected or expected<c/> contact Technical Support.,
===============

We have backup which is 2 days old, and restoring from the backup would result in us losing a lot of records that we
have created since then. Is there any way to recover the data from this database? How canI repair it? Please advice. Thanks

View 5 Replies View Related

Database Design For Status Field

Mar 1, 2007

Hello,
I have a database design question. I want to store a status in a table. In the ASP.NET interface for the user this status will be adapted to the language of the user.
This is how it would look like:
StatusID 1 = "yes" for English, "oui" for French, "ja" for DutchStatusID 2 = "no" for English, "non" for French, "neen" for DutchStatusID 3 = "error" for English, "erreur" for French, "fout" for Dutch
I don't want to do the translation in ASP.NET and it should be done in one query.
How would it look like in the database design.

View 5 Replies View Related

Timestamp Ans Status Of Database File

Apr 21, 2007

Our database is running in full recovery mode and we backup the logfile every hour and the database file every night. I notice thetimestamp of database file *.mdf remains unchanged a few days. Forexample one database has its timestamp at Apr 15 while it is Apr 20already.I am wondering if this is acceptable. How do I force the system toflush the data and dirty blocks to the disk more frequently? What isthe downside to this?Thanks for any idea.

View 1 Replies View Related

Database Mail - Status Sent But Email Never Received

Jan 29, 2007

From SQL Management Studion I go to Management > Database Mail and I am trying to send a test email but I never receive anything.  I checked my SMTP Mail Server Logs and I saw no entry of my test email. 
I also I checked my SQL Database Mail Logs and everything seems fine, no errors are reported.
The msdb.dbo.sysmail_allitems shows my email status as "sent".
So what am I missing? What steps would you recommend for troubleshooting my problem?
Thank you,
Ric

View 7 Replies View Related

How Do You Enter Checkbox Status In A Database Column??

Jun 4, 2008

Hi,

On my page I am using a wizard control with textboxes to collect data from the visitor.
When they click the finish button - this inserts their data into a Sql database.

On the form is a checkbox.
I dont know what type to use in the database column to accept this and also
how to configure the checkbox on the page so I know if its checked.

Also what would be inserted into the database column "yes" "no" or a numerical value??


Thanks for any advice?

amereto

View 1 Replies View Related

Can We Toggle The Database Status Between Recovery And Nonrecovery?

Jun 15, 2006

Hi,

1) We will setup logshipping for a large database.

2) 2 systems are located at different city

3) Instead of use 'backup from primary and restore with norecovery to secondary ', we planned to use

SAN disk clone to get a second set of disks for related database files and log files.

4) We will mount the disk to the secondary server, however, how can we put the database on the new

server as 'norecovery' mode so that we can setup logshipping to this server ??



Another easy example is:

1) detach database

2) Copy database files to another disk

3) bring the disk to another city and attached to the new server

The database is recoveryed, how can we attach the database or mount the disk and make

the database as norecovery so that we can keep apply new logs??



For 2 identical database image, how can we toggle one from normal to norecovery to setup logshipping?

Is change 'status' from master database working?



Thank you very much for any words.

If this is the wrong forum, please point me to a correct one since I am new here and I can't find a

backup/restore related forum.



Jane



View 1 Replies View Related

How To Recover SQL Server Database From Suspect Status

May 24, 2007

One of the database in our SQL Server 2000 environment is in the suspect status. We need to bring it back to the normal status.



The problem occurred because the disk on which the data file and log file for this database were placed ran out of space.


Pls note other databases in the same server are working fine.
Later on more space was made available on this disk. We tried the following options but with no success.

1. Reset the status of database and restarted the SQL Server. After restarting the SQL Server, the database once again was showing the suspect status.
2. Used the same data and log file in another SQL Server and attached with the database in this another SQL Server.
3. Tried dbcc chkdb with repair_allow_data_loss.



Since the database is in suspect status, we are neither able to export the data nor able to back up the database.



Please suggest some options to recover the database from the suspect status. Also it would be great if we can get the commands, scripts to find if the data/log file is corrupt and a way to correct it (even with data loss is fine).

View 9 Replies View Related

How To Query The Progress Status Of A Database Restore

Apr 23, 2007

Hi,

we have a reporting database that needs to be refreshed every week. I normally get a big backup file (50GB) from our business partner very Sunday morning; I have setup a job to restore the database once I got the backup file. The restore job normally will take about 4 or 5 hours to finish, but sometime it may take much longer (more than 10 hours). We knew there is some kind of disk storage contention going on the SAN. When this problem happens the system guy always try to pick my db restore process to be the victim. I hate to kill a job when it has 90% done, but I have no way to tell the restore progress status. Does someone know if I can query database restore progress information from any DMVs?

Thank you for your help in advance.

David Zhang

View 3 Replies View Related

How Do I Change The Status On My Database? Currently Is Is Assigned As Restricted User

Jun 19, 2008

I restored a  sql server database today. There is a problem though. In SQL server, right next to the name of the database are the words "Restricted User". Their seem to be some limitations on my access to this database now as I am not able to run some of my C# code against the database. How can I fix this in SQL server so that I am not a Restriced user.
 
Example of what I am talking about. In SQL server my database is named Gorlaz. Just to the left of this is a yellow Icon that represents the database "Gorlaz". For illustration purposes I will use the character "$" to substitute for the yellow database icon. So this is how it reads in SQL server management studio.
$Gorlaz(Restricted User)
 

View 3 Replies View Related

After Restore The Database Success Stll The Status Loading.

Dec 17, 2001

I Restored the database from Backup with a Different database Name. I got a message the Restore Database was successful. Still the database has Loading Status. Can you let me know what I have to take that status.

View 1 Replies View Related

Reporting Services :: RDL Files For Database Fragmentation Status

Nov 24, 2015

i need a .rdl file for reporting..pull the data using below SQL script 

SELECT OBJECT_NAME(ind.OBJECT_ID) AS TableName, 
ind.name AS IndexName, indexstats.index_type_desc AS IndexType, 
indexstats.avg_fragmentation_in_percent 
FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) indexstats 
INNER JOIN sys.indexes ind  
ON ind.object_id = indexstats.object_id 
AND ind.index_id = indexstats.index_id 
WHERE indexstats.avg_fragmentation_in_percent > 0.5 
ORDER BY indexstats.avg_fragmentation_in_percent DESC

sql server 2008r2  database fragmentation report for .rdl file

View 7 Replies View Related

DB Engine :: 2012 Database Stuck In Recovery Pending Status?

Jan 12, 2013

I have a SQL cluster which ran out of disk the other day.  I threw plenty more disk at the SAN.  However, 1 of the databases came back with Recovery Pending and has been over 24 hours.  I have tried to backup the database with no success.  I don't have a clean backup from the day it occured so would have a good amount of work missing.

Running a dbcc check returns the following:

Msg 945, Level 14, State 2, Line 1

Database 'sqldb' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.

I have not tried a dbcc check with REPAIR_ALLOW_DATA_LOSS as there seems to be a high risk of losing whatever was going on.  how I can get the db back online?

View 10 Replies View Related

SQL Server 2014 :: Capture Each Change In Database Without Updating Earlier Status

Jan 22, 2015

I have a matrix table. These status can be changed by the user and I want to capture each change in database with out updating the earlier status

Pending
Activated
In PROGRESS
Submitted
Completed

Pending can be changed to submitted or completed. For one form there can be different status at different time. And each status must be saved in the database table. How can I design a table...

View 2 Replies View Related

Customize Database Maintenance Using SSIS (Select Databases Based On Status)?

Mar 7, 2008

I want to customize database maintenance to run only on selected databases based on their status in sys.databases, without having to statically select them in the GUI.


I'm trying to write an SSIS package that will do the following:


1. Query for a list of databases that are not read-only or recovering, etc.
2. Perform database maintenance tasks (e.g., rebuild indexes) on those databases.

I'm doing this because the database maintenance tasks do not provide a way to select databases based on criteria or a SQL query filter.

My package includes an Execute SQL task to get the list of databases, a Foreach loop container to loop through the databases, and then...this is where I get stuck. I can't use the existing maintenance tasks (Rebuild Index, Update Statistics, etc.) because I don't know how to provide an input variable for the list of databases. I'd rather not write dynamic SQL to generate commands for each database object.

Does anyone know how to do this?

Thanks much.

David

View 9 Replies View Related

Ok I'm Making A Webpage But

Dec 7, 2003

with SQL desktop engine installed where do I even begin working with it?

View 1 Replies View Related

Can't Get Db To Show Up On Webpage???

Aug 5, 2007

husband built web site, hosted by 1and1, husband can't help right now and 1and 1 won't. I can't get the connection string correct and need some advise.
This is the info 1and1 gave me for my db.

Database Name db212583089
User Name xxxxxxxxxxxxxxxx
Password xxxxxxxxxxx
Host Name mssql02.1and1.com
Description jamm
Status
My bd is uploaded to their server and should connect with the global.asa page, this is what I have as a connection right now and it's not working
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
'==FrontPage Generated - startspan==
Dim FrontPage_UrlVars(1)
'--Project Data Connection
Application("Database1_ConnectionString" = "PROVIDER=SQLOLEDB;DATASOURCE=msssql02.1and1.com;DATABASE=db212583089;UID=dbo212583089;PWD=xDBXzNTt"
Application("Database1_ConnectionTimeout") = 15
Application("Database1_CommandTimeout") = 30

this is the error i get on my website when i try to access my db.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/JAMMDatabase.asp, line 131

This is the code on line 131, some before and some after:
strProvider=Application("Database1_ConnectionString")

set objConn = server.createobject("ADODB.Connection")
objConn.Open strProvider(line 131)

set cm = Server.CreateObject("ADODB.Command")
cm.ActiveConnection = objConn

right now I am totally lost with all this, if someone can help would really appreciate it, thanks, debi

if you need more info just let me know

View 2 Replies View Related

Webpage Access To SQL?

Apr 2, 2007

hey all.

Just wondering if there are any online recources on writing SQL in a website?
i have a database linked to an sql server, and from access etc. i can access it no problems.. just wanting to access it from a website.

thanks

View 1 Replies View Related

Data On Webpage

Nov 27, 2007

Hi i am new to SQL and have been asked to create a page with a SQL database that has got the employees names and numbers on it and i have got to display this on a webpage i have got the sql database on my local pc and have setup the fields and created the database i just need to know how to display the data on a webpage the database name is employees and i have then got fields like email, Name and Department is could someone give me an example using the database name that i have got and the fields or points me to some sites also i would like to place them in coulums how hard is this

View 1 Replies View Related

Refresh In WebPage

Apr 3, 2008



Hi all...

when i select the 1st parameter in the report(in webpage) ... then the complete page is getting auto refreshed...same is happening for all the parameter selection...is it not possible to stop it from refreshing....

simply to say i want to get data without refreshing...

few ppl suggested me to use AJAX control but as iam not much familliar with AJAY iam trying to find some other way...can u help me pls....

Roopesh Babu V

View 1 Replies View Related

How To Automated Send Email To Inform The Status Number Of Data In Database Using Stored Procedures?

Feb 23, 2008

Hi ,

I'm just new in this SQL 2005, and I do not reallly sure the subject is right or not but as example in this link below

http://msdn2.microsoft.com/en-us/library/ms190307.aspx

I want updated to few of person of any changes in database just by sending to their emails in every 2 hours as an example. I go through the example given but I do not know the step how to run stored procedures. The Information that I want to give to them is like as:

Date From : 23/02/2008
Date To: 24/02/2008
Number of user : 3

My draft table is like this

Sequence_No Submitted_Dt Name
-------------------- ------------------- ------------------------


1 2/21/2008 4:16:45 PM John
2 2/22/2008 4:16:45 PM Dean
3 2/23/2008 4:16:45 PM Rick
4 2/24/2008 4:16:45 PM Van


thanks to all of your corcern to help me

Regards;

View 13 Replies View Related

SQL Server Images To Webpage

Apr 26, 2005

Hello,
I am trying to put on a webpage a picture with a discription, however when I create an MxDataGrid and run the page all the info in the datagrid is correct except the image. All that is in the field is "System.Byte[]".
I am new to web programming but I have created many databases and using Access as a front end where this process is very straightforward.
Can anyone tell me how I can make this work?
I want to store images along with other info about the image in the database so that I can simply query the database and have the page fill from the query.
Thanks
whill1

View 2 Replies View Related

Partially Update Webpage

Jul 20, 2005

How to dynamically and partially Update the webpage? The content ofthe part of the page is from the user's requerement and get data fromthe server side.The purpose is to speed up the page update. We have a page that mostof content are static, only small part is changed per user's selectand the replying data need to get from server side database. Thanksfor help. Gene

View 1 Replies View Related

Display A Webpage In Report

Jan 28, 2008

I would like to display an asp page in a Reporting Services report. However, I do not want to have to click a button and navigate to it. I just want to display it sort of like a subreport. Is this possible?

View 1 Replies View Related

Adding Image To The Webpage

Jul 17, 2007

hi

i am a beginner of asp and want to add an image to the page ?

would u guide me?

View 1 Replies View Related

Speed Differences Between Webpage And Sql Studio

Jul 23, 2007

i have a search engine i have built for an online store. On the search page there are 6 or 7 queries that are run that return products, finishes, styles, rooms, and things like that.

If i go into SQL management studio and run all 6 of the queries at the same time it takes usually about 3 seconds to complete all of them consistently no matter what search parameters are sent.

now when i actually go and run a search on the website itself it takes the page more like 15 seconds to load. I have made sure there are no other queries running in the header/footer or anywhere else on the page to rule out other things slowing it down. I have even turned off all the images on the page and it doesnt seem to change.

im building new dataset objects and filling them with .NET then using a for each loop to output the items. Is this the preferred way to bring data back or could that be slowing things down?

are there any tools out there i could use to view whats slowing things down?

thanks everyone

View 1 Replies View Related

How To Access The Properties And Methods Of Rdl From Webpage.

Aug 14, 2007



Hi,


I have created a report in reporting service 2005 and i have succesfully integrated the report in asp.net webpage.
But i want to know whether it is possible to access the methods and properties of (report)rdl file in the asp.net webpage.
If it is possible then please tell me how to implement it



Thanks and Regards
Altaf Hussain N

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved