public SqlDataReader getBestQuickNews()
{
con=DB.Connection();
con.Open();
SqlCommand cmd=new SqlCommand("select top 6 * from hos_News",con);
SqlDataReader sdr=cmd.ExecuteReader();
return sdr;
//sdr.Close();--------是这样写吗?
//con.Close();-------如果关闭程序报数据库连接以关闭的错误,不关太占用资源
}我是菜鸟,请高人指教!
{
con=DB.Connection();
con.Open();
SqlCommand cmd=new SqlCommand("select top 6 * from hos_News",con);
SqlDataReader sdr=cmd.ExecuteReader();
return sdr;
//sdr.Close();--------是这样写吗?
//con.Close();-------如果关闭程序报数据库连接以关闭的错误,不关太占用资源
}我是菜鸟,请高人指教!
{
con=DB.Connection();
con.Open();
using(SqlCommand cmd=new SqlCommand("select top 6 * from hos_News",con))
{
using(SqlDataReader sdr=cmd.ExecuteReader())
{
return sdr;
}
}
}去看看using的用法
{
using(con=DB.Connection())
{
con.Open();
using(SqlCommand cmd=new SqlCommand("select top 6 * from hos_News",con))
{
using(SqlDataReader sdr=cmd.ExecuteReader())
{
return sdr;
}
}
}
}
有详细解释
当你关闭sdr时,会自动关闭con
{
using(DBConnection con=DB.Connection())
{
con.Open();
SqlCommand cmd=new SqlCommand("select top 6 * from hos_News",con);
SqlDataReader sdr=cmd.ExecuteReader();
List<QuickNewType> result=new List<QuickNewType>();
while(sddr.Read())
{
QickNewType one=new QuickNewType();
//读取sdr,将字段值写入one的相应属性
result.Add(one);
}
return result;
}
};