Search results for query: *

In testing my website I found that I needed to add a few tables to the database. The website was designed using ASP.Net 2. Internet and intranet access (IIS 6) worked fine before and works now except when I need to access the new tables. Then I get the "can't find or you dont have permissions"...

On my web page I have a textbox in which the doctor enters a patient ID. A dropdown list is populated with the avaliable test dates when he enters a patient id and hits the Enter key. There are several other buttons on the page that allow him to pull up different test panels based on the patient...

I have a table in which I added a new column named test_name. I need to populate all rows in this new column with the same value (Sedrate). How can I do this? Thanks.

I'm having a real brain fart on this. I know how to use variables for column values in an sql statement in ASP.Net 2.0 but how do I word the function if the table name is the variable? Public Shared Function GetSQLTQResults(ByVal strtablename As String) As DataTable Dim strCon As...

I have this query: SELECT ( REQ_PANELS.RUN_DATE) "Start_Date" FROM REQ_PANELS, REQUISITIONS, RESULTS, TESTS WHERE REQUISITIONS.ACC_ID = REQ_PANELS.ACC_ID AND REQ_PANELS.RP_ID = RESULTS.RP_ID AND RESULTS.TEST_ID = TESTS.TEST_ID AND (REQUISITIONS.PAT_ID = '10364.0') AND (REQ_PANELS.RUN_DATE IS...

Hi, I'm using this code to list the avaliable printers on the client side in a dropdownlist: For Each strPrinter As [String] In System.Drawing.Printing.PrinterSettings.InstalledPrinters SelectPrinter.Items.Add(strPrinter) Next strPrinter Dim PD As New PrintDocument...

I need some help quick. I have to present my website to the client this afternoon. IIS on 2000 Server on doc-server SQL Server 2005 Express on doc-server ASP.NET 2.0 Visual Web Developer 2005 Express on doc-server I added a table to an existing SQL database. All tables in the database need read...

I have two queries , one from MSSQL and one from Oracle. The results are combined into one table using "mytable1.Load(dr2)". My question is can i run a query against mytable1? If I can't can I populate a table in my SQL database with the data in mytable1 and then run the query? How would I do...

I have a website in asp.net that uses queries to pull data from MSSQL and Oracle 10g and combine the data into one table. What I am having trouble with is date formats. The date format has to be the same for both the data retrieved from Oracle and MSSQL. MSSQL returns the date as mm/dd/yyyy...

This is really driving me crazy! I have a development server at my office where I wrote and tested my code. All is well and the code works fine. When I copied the code to the clients server I get the "Failed to enable constraints" error when running this part of the code: mytable1 =...

I have an internal website the allows the doctor to retrieve patient lab data. The data is displayed in a chart using ChartDirector and also has the data displayed in a gridview below the chart. (ChartDirector also has the capability of saving the chart in a jpeg file.) The doctor would like the...

This is the code I'm using: Dim mytable1 As DataTable mytable1 = DAL.GetCombinedPSAResults(TBPID.Text) Dim dr As New DataTableReader(mytable1) mytable1.Load(dr) Dim dv As DataView = mytable1.DefaultView Dim mytable2 As DataTable mytable2 =...

This is part of a query that runs fine in Oracle. SELECT TESTS.TEST_NAME "Test",RESULTS.RESULT_NUMERIC "Results" ,REQ_PANELS.RUN_DATE "Date"........ In Visual Web Developer it's Dim ocmdSelect As New OracleCommand("SELECT TESTS.TEST_NAME "Test",RESULTS.RESULT_NUMERIC...

I'm using Visual Web Developer 2005 Express with VB. I have a query that returns something like this: test_date test_name result 12/12/2006 AST 10.23 01/10/2007 AST 12.20 12/12/2006 BUN 2.00...

I'm using this query: SELECT REQ_PANELS.RUN_DATE, RESULTS.RESULT_NUMERIC, TESTS.TEST_NAME FROM REQ_PANELS, REQUISITIONS, RESULTS, TESTS WHERE REQUISITIONS.ACC_ID = REQ_PANELS.ACC_ID AND REQ_PANELS.RP_ID = RESULTS.RP_ID AND RESULTS.TEST_ID = TESTS.TEST_ID AND (REQUISITIONS.PAT_ID =...

I'm using Visual Web Developer 2005 and MSSQL Server 2005 Express. I have the following code: Dim mytable As New DataTable Dim connectionString1 As String = GetConnectionString("FMC_AccessConnectionString") Dim providerFactory1 As DbProviderFactory =...

I have the following code: Dim mytable As New DataTable Dim mytable2 As New DataTable Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim connectionString As String = GetConnectionString("XE_ConnectionString") Dim...

This is driving me nuts! I read the Faq (amazing amount of info there) and followed the suggestions but to no avail. Here is my code: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim connectionString As String = "Data Source=...