sqlhelp 类
public static DataTable GetDataTable(string sql)
{
//SqlConnection sqlcon = new SqlConnection(SqlConnectString);
SqlConnection sqlcon = new SqlConnection(connectionString);
SqlDataAdapter sqlda = new SqlDataAdapter(sql, sqlcon);
DataTable dt = new DataTable();
sqlda.Fill(dt);
return dt;
}DAL层
public List<Model.job> getDannewinfo()
{
List<Model.job> Ilist = new List<Model.job>();
DataTable dt = sqlhelp.GetDataTable("select * from job");
foreach (DataRow dr in dt.Rows)
{
Model.newinfo info = new Model.newinfo();
info.Nititle = dr["nititle"].ToString();
info.Nicontent = dr["nicontent"].ToString();
list.Add(info);
}
return Ilist;
}怎么它在DataTable 那说 阅读器关闭时 Read 的尝试无效
public static DataTable GetDataTable(string sql)
{
//SqlConnection sqlcon = new SqlConnection(SqlConnectString);
SqlConnection sqlcon = new SqlConnection(connectionString);
SqlDataAdapter sqlda = new SqlDataAdapter(sql, sqlcon);
DataTable dt = new DataTable();
sqlda.Fill(dt);
return dt;
}DAL层
public List<Model.job> getDannewinfo()
{
List<Model.job> Ilist = new List<Model.job>();
DataTable dt = sqlhelp.GetDataTable("select * from job");
foreach (DataRow dr in dt.Rows)
{
Model.newinfo info = new Model.newinfo();
info.Nititle = dr["nititle"].ToString();
info.Nicontent = dr["nicontent"].ToString();
list.Add(info);
}
return Ilist;
}怎么它在DataTable 那说 阅读器关闭时 Read 的尝试无效
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货