Re: [Firebird-net-provider] disposing the command

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

HEllo:

> I am using FbNetProvider RC2 in the following piece of code:
> 
> 	private void button2_Click(object sender, System.EventArgs e)
> 	{
> 		this.fbConnection1.Open();
> 		this.fbSelect.Transaction = this.fbConnection1.BeginTransaction();
> 		this.fbDataAdapter1.Fill(this.documentsDataset1, "documents");
> 		this.fbSelect.Transaction.Commit();
> 		this.fbConnection1.Close(); // (x)
> 	}
> 
> After closing the connection at (x), it destroys my fbSelect command (when
> disposing it) and I am not able to use it next time (i.e. it clears the
> CommandText etc.).
> 
> Am I doing something wrong?


No the FbConnection.Close method will close all opened commands.





Best regards
Carlos Guzman Alvarez
Vigo-Spain