Can someone help in connecting to 2 databases in sqlserver2008 with code.
I am new to programming and aiming to create multiple databases ,one for login and other for company needs.for each company i am planning to create separate databases and one database which will hold all the login credentials.how the users can dynamically select their own respective databases once they login..

Hi there,

You find lots of information on connecting to databases in my book. Check out chapters 11 and further.

Also, check out Appendix B for connecting to SQL Sevrer using different user accounts and database names.

Finally, if you have follow up questions that are not related to my book (such as this one), please post here: http://p2p.wrox.com/asp-net-3-5-436/ as you'll attract more viewers.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!