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:
01450053
Views:
37
>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.

Not sure it's relevant but google the use of 'MultipleActiveResultSets' in the connection string......
Previous
Reply
Map
View

Click here to load this message in the networking platform