C#访问SQL Server数据库的实现方法

/*其中server表示服务器，“.”表示当地服务器，DataBase表示数据库，uid表示连接的用户名，pwd比表示密码*/string strDataBase = "Server=.;DataBase=Library;Uid=sa;pwd=123456;";SqlConnection conn = new SqlConnection(strDataBase);string sqlStatement = "select * from Reader";SqlCommand sqlcmd = new SqlCommand(sqlStatement, conn); //设置参数conn.Open();SqlDataReader sdr = sqlcmd.ExecuteReader(); //执行SQL语句int cols = sdr.FieldCount; //获取结果行中的列数object[] values = new object[cols];while (sdr.Read()){  sdr.GetValues(values); //values保存一行数据  for (int i = 0; i < values.Length; i++)  {   Console.Write(values[i].ToString()+" ");  }   Console.WriteLine();}sdr.Close();conn.Close();