Devart Forums

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

Try setting the database property of the connection before you open it.
This should solve the problem.