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();
}
}
}
}
}
数据库学习(十六)使用强类型读取列中数据
最新推荐文章于 2022-04-11 20:33:40 发布