Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open DataReader Error
Message
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Miscellaneous
Thread ID:
01449230
Message ID:
01450062
Views:
31
>In my app when the user clicks a contact name I get a reader of the contact data and use it to load the data into the UI. If I click around on multiple contacts very fast I get
>
>"There is already an open DataReader associated with this Command which must be closed first." in my app.
>
>I have DataReader.Close() in all the right places, but it's possible to initiate another call to the ExecuteReader before the previous reader is closed.
>
>I tried Thread.Sleep(15), but it's still possible to click from one contact to another before the previous reader is done.
>
>Anyone?
>
>[UPDATE] - Now I'm not sure why I'm seeing this, because I'm clicking from one contact to another slowely and it still errors.

Check if SQLDataReader.IsClosed = True before trying to ExecuteReader. Loop if you have to until it is closed.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform