SqlConnection conn = new SqlConnection("Server=localhost; Initial Catalog=stuinfo_table; User ID=sa; Password=123;");
SqlCommand Scommand = new SqlCommand();
Scommand.Connection=conn;
Scommand.CommandType=CommandType.Text;
Scommand.CommandText = "select * from stuinfo_table";
conn.Open();
SqlDataReader sdr;
sdr = Scommand.ExecuteReader(
CommandBehavior.CloseConnection);
while(sdr.Read())
{
Console.WriteLine(sdr["name"].ToString().Trim());
Console.WriteLine(sdr["age"].ToString().Trim());
Console.WriteLine(sdr["birthday"].ToString().Trim());
Console.WriteLine(sdr["sex"].ToString().Trim());
}
conn.Close();
