Почему так не работает?
Ошибка InvalidOperationException на выделенном месте
"There is already an open DataReader associated with this Command which must be closed first."
| Код |
SqlCommand scom;
SqlCommand scom2;
private void button1_Click(object sender, EventArgs e)
{
string DocText = "";
scom = new SqlCommand("select ID_QUES,NUM_QUES,QUESTION from QUESTIONS order by NUM_QUES desc ", DbMgrClass.SqlConnect);
SqlDataReader sdr = scom.ExecuteReader();
while (sdr.Read())
{
string DocText2 = "";
scom2 = new SqlCommand("select NAME_DOCS,PATH_DOCS from DOCUMENTS where ID_DOCS=" + sdr.GetInt32(0).ToString() + " order by NUM_QUES desc ", DbMgrClass.SqlConnect);
SqlDataReader sdr6 = scom2.ExecuteReader();//Здесь вылетает исключение
while (sdr6.Read())
{
DocText2 = sdr6.GetInt32(0).ToString() + "</br>" + DocText2; ;
}
sdr6.Close();
DocText = sdr.GetValue(0).ToString() +"</br><center>"+DocText2+"</center><p>"+ DocText;
}
sdr.Close();
}
|
|
