C# .Net and SQL Server 2000 Connectivity

hello everybody,

i am new to C# .Net and SQL Server 2000. i am developing my first project with these . i need help regarding the connectivity of C# .Net and SQL Server 2000. pl. help

thanks

Hi,


Define the Namespace in the top of the form.

using System.Data;
using System.Data.SqlClient;


In the Form Load Events,

string constr="";

constr = "Data Source=DOTNETPC042\SQLEXPRESS;Initial Catalog=master;Integrated Security=True";

//Pass the Connection string to the SqlConnection
SqlConnection con = new SqlConnection(constr);
con.open(); //Open the Connection



Regards,
S.Suresh

thank you very much its useful