I have been working on this problem for the better part of 3 days. I have an intranet website written in ASP.NET 2.0 (VB). I want to select a database based on the user who logs into the system.
Here is the relevant code...
Private taData As New DataSet1TableAdapters.datatableTableAdapter
...
taData.Connection.Open()
taData.Connection.Database = databaseID
...
newDataSet.Tables(0).Rows.Add(dr) 'dr is a dataRow created using .NewRow on newDataSet.Tables(0) and has been populated elsewhere
taData.Update(newDataSet)
the problem is that it updates the database used when defining the table adapter and dataset.
I am using Visual Studio 2005 and I am using the DataSet designer in Visual Studio.
Please help.
Thank You
Changing Databases in runtime
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
Try setting the database property of the connection before you open it.
This should solve the problem.
This should solve the problem.
Code: Select all
Private taData As New DataSet1TableAdapters.datatableTableAdapter
...
taData.Connection.Database = databaseID
taData.Connection.Open()
...
newDataSet.Tables(0).Rows.Add(dr) 'dr is a dataRow created using .NewRow on newDataSet.Tables(0) and has been populated elsewhere
taData.Update(newDataSet)