I'm new to .net and need to know how to handle database connection to SQL Server 2000/2005 so an application can be deployed to clients. Thanks.
http://www.sqlstrings.com/SQL-Server-connection-strings.htm http://msdn2.microsoft.com/en-us/library/ms998300.aspx MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
http://www.dotnetspider.com/tutorials/ http://www.sql-server-vb-asp.net/ ..also take you through the tutorials. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Hi, I think my question is not specific enough. I'm looking for different .NET 2.0 techniques (also .NET 3.0 if differnt) in both storing connection string and building connection string in runtime. I think the most common way in storing connection string is in app.exec.config. But I want to know other alternatives and their pros and cons.
True, may refer to the MSDN related forums. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.