multiple database

[abhit_kumar]

Dear All Experts,

I am making a window based application in vb.net.

Now i have work in two sql databases, so i when the window opens it will show two databases..when i select first db then i can work in that particular db only..if select 2nd db then i can work in second db only..how to do that?

Please guide me.

Regards,
AKM

[jmcilhinney]

You simply need two connections strings: one for each database. Based on the user's choice, you use one connection string or the other. Follow the Database FAQ link in my signature to learn how to use ADO.NET and you'll see where the connection string gets used.