Dear friends,

  I want to connect to sql server database. I am using ASP.NET 1.1 with C#2003. Could you tell me in step by step with codings.

saas

Hi saas,

(1)Define the connection string in web.config file.
(2)Refer System.Data.SqlClient in your web form which you are going to create the connection
(3)Open the connection as,

SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationSe ttings.AppSettings["Connectionstring"]);
connection.Open();


nalaka hewage

Hey,

You should check this out:
http://www.asp.net/QuickStart/aspnet...a/default.aspx

Brian

And here a wonderful site if in doubt about the connection string...

http://www.connectionstrings.com/

Jacob.