SqlDataReader 的问题,如何进行签套查询

CBJ2049011 2003-11-26 02:48:33

如下
SqlConnection conn = new ......
SqlCommand sqlcommand1 = ......
SqlDataReader sdr1 = sqlcommand1......
while(sdr1.Read())
{
................
SqlCommand sqlcommand2 = .....
SqlDataReader srd2 = ......
//Error here ,SqlDataReader Must Close before ........
...............
................
}

...全文

24 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

CBJ2049011 2003-11-26

打赏
举报

靠,没说一样
我的第二个送是为了告诉你这个错误和上面产生的相同.

hlj321 2003-11-26

打赏
举报

private void button4_Click(object sender, System.EventArgs e)
{
string sql = "select * from DoorControl";

System.Data.SqlClient.SqlCommand sqlcommand = new System.Data.SqlClient.SqlCommand(sql, DBTools.conn);
System.Data.SqlClient.SqlDataReader sr = sqlcommand.ExecuteReader();
sr.close()
}

private void button5_Click(object sender, System.EventArgs e)
{
string sql = "select * from DoorControl";
System.Data.SqlClient.SqlCommand sqlcommand = new System.Data.SqlClient.SqlCommand(sql, DBTools.conn);
System.Data.SqlClient.SqlDataReader sr = sqlcommand.ExecuteReader();
sr.close()
}

CBJ2049011 2003-11-26

打赏
举报

private void button4_Click(object sender, System.EventArgs e)
{
string sql = "select * from DoorControl";

System.Data.SqlClient.SqlCommand sqlcommand = new System.Data.SqlClient.SqlCommand(sql, DBTools.conn);
System.Data.SqlClient.SqlDataReader sr = sqlcommand.ExecuteReader();
}

private void button5_Click(object sender, System.EventArgs e)
{
string sql = "select * from DoorControl";
System.Data.SqlClient.SqlCommand sqlcommand = new System.Data.SqlClient.SqlCommand(sql, DBTools.conn);
System.Data.SqlClient.SqlDataReader sr = sqlcommand.ExecuteReader();
}

这样也不行
是不是一个连接只能有一个SqlDataReader??????????