Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Open DataReader Error
Message
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Divers
Thread ID:
01449230
Message ID:
01450062
Vues:
32
>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!
____________________________________
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform