ارور مشکوک روی کد select

[amir-aa]

            a1 = Convert.ToInt32(textBox4.Text);

            string connectionstring = "Data Source=.;Initial Catalog=maryam;Integrated Security=true;User ID=sa;Password=01";

            SqlConnection conn = new SqlConnection(connectionstring);

            string query1 = "insert into tasvie(pol,date,codef) Values("+textBox4.Text+",'"+maskedTextBox1.Text+"'  ,"+comboBox4.Text+")";

            string query2 = "select sum(tasvie.pol) as 'jam',sarfactor.nesie from tasvie join sarfactor on tasvie.codef= sarfactor.id where tasvie.codef="+comboBox4.Text+" group by sarfactor.nesie";

            SqlCommand cm = new SqlCommand(query2, conn);

            SqlCommand cm1 = new SqlCommand(query1, conn);

            conn.Open();

            SqlDataReader dr = cm.ExecuteReader();

            if (dr.Read())

            {

                n = Convert.ToInt32(dr["nesie"].ToString());

                jam = Convert.ToInt32(dr["jam"].ToString());



              //  conn.Close();

            }

            

           else

              {

                  conn.Close();

                  string connectionstring1 = "Data Source=.;Initial Catalog=maryam;Integrated Security=true;User ID=sa;Password=01";

                  SqlConnection conn1 = new SqlConnection(connectionstring);

                  string query3 = "select sarfactor.nesie from sarfactor where sarfactor.id="+comboBox4.Text;

                  SqlCommand cm3 = new SqlCommand(query3, conn);

                  conn.Open();

                  SqlDataReader dr1 = cm3.ExecuteReader();

                 if (dr1.Read())

                  {

                      n = Convert.ToInt32(dr["nesie"].ToString());

                    

                  }

ارورش
Invalid attempt to call MetaData when reader is closed.
؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟

[amir-aa]

هیچکس جواب نمیده؟؟/

[SharpSabre]

conn1.Open();

string connectionstring1 = "Data Source=.;Initial Catalog=maryam;Integrated Security=true;User ID=sa;Password=01";       SqlConnection conn1 = new SqlConnection(connectionstring1);

       string query3 = "select sarfactor.nesie from sarfactor where sarfactor.id="+comboBox4.Text;

       SqlCommand cm3 = new SqlCommand(query3, conn1);

       SqlDataReader dr1 = cm3.ExecuteReader();

این دستورات رو بذار اینجا

else

   {

       conn.Close();

.

.

.

if (dr1.Read())       {

           n = Convert.ToInt32(dr["nesie"].ToString());

          

       }

[amir-aa]

من نمیفهمم

[amir-aa]

فهمیدم من باید به جای dr مینوشتم dr1در حقیقت dr در چند خط قبل بسته شده بوده

[amir-aa]

   a1 = Convert.ToInt32(textBox4.Text);

            string connectionstring = "Data Source=.;Initial Catalog=maryam;Integrated Security=true;User ID=sa;Password=01";

            SqlConnection conn = new SqlConnection(connectionstring);

            string query1 = "insert into tasvie(pol,date,codef) Values("+textBox4.Text+",'"+maskedTextBox1.Text+"'  ,"+comboBox4.Text+")";

            string query2 = "select sum(tasvie.pol) as 'jam',sarfactor.nesie from tasvie join sarfactor on tasvie.codef= sarfactor.id where tasvie.codef="+comboBox4.Text+" group by sarfactor.nesie";

            SqlCommand cm = new SqlCommand(query2, conn);

            SqlCommand cm1 = new SqlCommand(query1, conn);

            conn.Open();

            SqlDataReader dr = cm.ExecuteReader();

            if (dr.Read())

            {

                n = Convert.ToInt32(dr["nesie"].ToString());

                jam = Convert.ToInt32(dr["jam"].ToString());



               conn.Close();

            }

            

           else

              {

                  conn.Close();

             

                  string query3 = "select sarfactor.nesie from sarfactor where sarfactor.id="+comboBox4.Text;

                  SqlCommand cm3 = new SqlCommand(query3, conn);

                  conn.Open();

                  SqlDataReader dr1 = cm3.ExecuteReader();

                   if (dr1.Read())  

            {

           n = Convert.ToInt32(dr["nesie"].ToString());

           

            }

                 conn.Close();

من اینجوری کردمش اما بازم همون ارور رو میده