SqlDataReader Close error

Question

public static void DropDownList_Bind(DropDownList list_name,string DtaTxtField,string DataValueField,String Procedure)
   {
       OpenConnection();
       com = new SqlCommand(Procedure, con); 
       com.CommandType = CommandType.StoredProcedure;
       SqlDataReader dtr = com.ExecuteReader();
       list_name.DataSource = dtr;
       list_name.DataTextField = DtaTxtField;
       list_name.DataValueField = DataValueField;
       list_name.DataBind();
       dtr.Close();
       CloseConnection();
   }
public static void OpenConnection()
    {
        if(con.State==ConnectionState.Closed)
            con.Open();

    }
    public static void CloseConnection()
    {
        if (con.State == ConnectionState.Open)
            con.Close();
    }

This is my Bussiness logic code for binding DropDownList,it is giving an execption There is already an open DataReader associated with this Command which must be closed first. on SqlDataReader dtr = com.ExecuteReader(); .please give some suggestions. Thanx in advance

Can you show me code for OpenConnection() and CloseConnectin() ? — zey
– zey, Commented Jul 11, 2013 at 11:26
In first time ,has your data binding complete successfully ? — zey
– zey, Commented Jul 11, 2013 at 11:36
Do you have other code that is reading data from the database and running this code inside that? For example using (SqlDataReader rdr = cmd.ExecuteQuery()) { while (rdr.Read()) { DropDownList_Bind(rdr[0], rdr[1], rdr[2]); } } — Sean Airey
– Sean Airey, Commented Jul 11, 2013 at 11:42

Jalpesh Vadgama · Accepted Answer · 2013-07-11 13:16:04Z

1

You need to make “MultipleActiveResultSets=True” in your connection string.

I have written a blog post at following link.

http://www.dotnetjalps.com/2013/06/Entity-Framework-There-is-already-an-open-DataReader-associated-with-this-Command.html

Regards,

answered Jul 11, 2013 at 13:16

Jalpesh Vadgama

14.4k21 gold badges75 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SqlDataReader Close error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related