Changing Databases in runtime

[onesimus]

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

[Alexey.mdr]

Try setting the database property of the connection before you open it.
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)