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?