Type this code to create a sql connection :
//con is the object of SqlConnectoin_
SqlConnectoin con= new SqlConnetoin();
con.ConnectionString = "Data Source =Sqlservername ; Initial Catalog = table name; Integrated Security = True";
con.Open();
//Here Sqlserver name = your computer name
(You can see your computer name by :
right click on MyComputer --> Properties -->
Computer Name (tab) --> Change (BUtton)
//If you are connecting sql with user id and
password than remove Integrated security and type :
SqlConnectoin con= new SqlConnetoin();
con.ConnectionString = "Data Source =Sqlservername ; Initial Catalog = table name; User id = youruserid; password = yourpassrd";
con.Open();
for more help
www.dotnetask.blogspot.com
Under Construction