string str = "Data Source=ECUST-GLOBAL\\PROFITSUITE;Initial Catalog=dbtest;Integrated Security=true";
using (SqlConnection con=new SqlConnection(str))
{
string sql = "select *from StudentInfo";
using (SqlCommand cmd=new SqlCommand(sql,con))
{
con.Open();
using (SqlDataReader reader=cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
Console.Write(reader.GetInt32(0)+"\t\t\t");
Console.Write(reader.GetString(1) + "\t\t\t");
Console.Write(reader.GetBoolean(2) + "\t\t\t");
//Console.WriteLine(reader.GetString(3));
Console.Write(reader.IsDBNull(4)? "null":reader.GetInt32(4)+"\t\t");
// Console.Write(reader.GetInt32(4) + "\t\t\t");
Console.WriteLine();
}
}
}
}
}