By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,402 Members | 1,107 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,402 IT Pros & Developers. It's quick & easy.

... connection's current state is Open ...

P: n/a
In an application I had the following error:

ExecuteReader requires an open and available Connection. The connection's
current state is Open, Executing.

System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping
tableMapping)

at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)

This error has been generate from the DataAdpter.Update() command

This application is multithread, but all the update are made through Invoke
to the update function:

this.Invoke(new System.Threading.ThreadStart(this.UpdateDataset));

Is it possible that the Form thread recive an Invoke and start the update of
the dataset,

then it recive a second Invoke befor ending the update of the dataset,

it suspend the first call and start with the second therefore the connection
remain open?
Nov 15 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.