已有打开的与此命令相关联的 DataReader，必须首先将它关闭。

显示全部楼层 · 2011-7-9 13:21:26

public static IList GetCommBytype(int type)

{

List list = new List();

string sql = "select * from comm where commType=@type";

int commType;//FK

using (SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@type", type)))

{

while (reader.Read())

{

Comm comm = new Comm();

comm.CommId = (int)reader["CommId"];

comm.CommName = (string)reader["CommName"];

commType = (int)reader["CommType"];//FK

comm.CommPrice = (decimal)reader["CommPrice"];

comm.CommNum = (int)reader["CommNum"];

comm.CommSize = (string)reader["CommSize"];

comm.CommLife = (string)reader["CommLife"];
comm.Type = TypeService.GetTypeById(commType);

list.Add(comm);

}

}

reader.Close();

return list;

}
我是根据type查找相关商品但是怎样才能在循环一个while后关闭datareader 再执行下一次？？？？？？？？？？？？

千问 · 2011-7-9 13:21:26

关闭数据库连接再来一次打开数据库连接 reader连接我以前这样写过很耗资源...