/*其中server表示服務(wù)器，“.”表示當(dāng)?shù)胤?wù)器，
DataBase表示數(shù)據(jù)庫，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); //設(shè)置參數(shù)
conn.Open();
SqlDataReader sdr = sqlcmd.ExecuteReader(); //執(zhí)行SQL語句
int cols = sdr.FieldCount; //獲取結(jié)果行中的列數(shù)
object[] values = new object[cols];
while (sdr.Read())
{
  sdr.GetValues(values); //values保存一行數(shù)據(jù)
  for (int i = 0; i < values.Length; i++)
  {
   Console.Write(values[i].ToString()+" ");
  } 
  Console.WriteLine();
}
sdr.Close();
conn.Close();