There is already an open DataReader associated with this Command which must be closed first.

See more:

C#

ASP.NET4

Dear All,

i have got error "There is already an open DataReader associated with this Command which must be closed first." while using DataReader using multiple command object. this is my to be using.

using (SqlConnection conn = GetSQLConnectiion(repositoryID))
{
using (SqlCommand comm = new SqlCommand("select *from Content_Content", conn))
{
try
 {
 using (SqlDataReader reader = comm.ExecuteReader())
  {
  while (reader.Read() && currentDirectorySize > targetSize)
   {
   try
   {
    //do somthing....
  StringBuilder query = new StringBuilder("update Content_Content SET OnCache = 0 where ItemID = '");
  query.Append(ItemID.ToString());
  query.Append('\'');
  using (SqlTransaction transaction = conn.BeginTransaction(IsolationLevel.Serializable))
   {
   using (SqlCommand comm1 = new SqlCommand(query.ToString(), conn, transaction))
    {
    comm1.Transaction = transaction;
    count += comm1.ExecuteNonQuery();
    transaction.Commit();
      }
     }
    }
    catch
      {
      }
     }
    }
   }
  catch
    {
    }
 }
}

The error to be got in the using Sqltransaction the code is "using (SqlTransaction transaction = conn.BeginTransaction(IsolationLevel.Serializable))" . can anybody have an idea...

Thanks
karthikeyan Mathiyalagan.