string sConnectionString;
// 链接字符串,根据实际情况修改
sConnectionString = "Password=;User ID=sa;"
+ "Initial Catalog=pubs;"
+ "Data Source=(local)";
SqlConnection objConn
= new SqlConnection(sConnectionString);
objConn.Open();
// 创建DataAdapter实例
SqlDataAdapter daAuthors
= new SqlDataAdapter("Select * From Authors", objConn);