What i'm trying to do is creating a application using VB.net and SQL server 2005 with the following:
I have a Database called DB1 with 2 tables:
When i create a new form and in order to place textboxes and datagrid on my form, i create a new DataSet and name it DsDB1.
Then to display the info on my form, i drag DsDB1 from the datasource window into my form and it automatically creates all the necessary fields and datagrid, with the appropriate bindingsource and tableadapter.
Now my problem comes here.
I have another database in my SQL server called DB2 with exactly the same tables and number of fields as DB1.
The only differences is with the content of the databases (Different records).
Is there a way to create an option: Select Database
meaning i get to select which database i want to use, select it and use it normally ??
Thanks a lot !!