string sConnectionString;
// 鏈接字符串,根據(jù)實(shí)際情況修改
sConnectionString = "Password=;User ID=sa;"
+ "Initial Catalog=pubs;"
+ "Data Source=(local)";
SqlConnection objConn
= new SqlConnection(sConnectionString);
objConn.Open();
// 創(chuàng)建DataAdapter實(shí)例
SqlDataAdapter daAuthors
= new SqlDataAdapter("Select * From Authors", objConn);