Search results for query: *

Changed connection string from (local) to .\sqlexpress. Changed IIS user to aspnet All is well.

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"...

OK. It only worked once. I'm open to suggestions.

Got it figured out. I used this: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not Page.IsPostBack Then Session("PatientName") = " " Session("startdate") = " " End If End Sub

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...

Not really, except in my case it was the easiest way out I could think of. The table is small and will never have data added. I have two db, oracle and mssql. I have to combine the data from the two to display on a internal webpage. The oracle db table has the test name and the mssql table...

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.

Wow! Complex answer to what I thought was a simple to answer question (although not so simple I could answer it). Here's my senerio. I have to pull data fro an Oracle Database (read only) and an sql database and combine the results. I used table.load() to combine the results into one table. The...

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...

Fiqured it out. I needed to change "ORDER BY REQ_PANELS.RUN_DATE" to "Order by 1

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...

Darn! Oh well. Thanks for the help.

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...

Got it figured out. Had to add aspnet user.

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...

That's what it was ... the formats were different. Thanks

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...

New Update. If I remove the date part in both queries then the tables combine. It's something to do with the dates. But what and how can I find out?

The error occurs at "mytable1.Load(dr2)". The error is: System.Data.ConstraintException was unhandled by user code Message="Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." Source="System.Data" StackTrace: at...