Re: [Firebird-net-provider] error Message "Command Connection is

[Carlos G. A. <car...@te...>]

Hello:

> Actually, now I can update ONCE the data in my database. The second time I
> try to
> DataAdapter.Update
> I get the same error message.

Because you are making a Commit after update this destroys the 
transaction context you need to make anything like this ( i have no 
tested it ):

private void button_Update_Click(object sender, System.EventArgs e)
{
	try
	{
		TestDA.Update(dataSetAdmin.Tables["Judete"]);
		txn = conn.BeginTransaction();
		TestDA.SelectCommand.Transaction=txn;
		custCB.RefreshSchema();
	}
	...
}





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.