Hello: Is this something like what you are doing ??
using (TransactionScope scope = new TransactionScope()) { using (FbConnection connection = new FbConnection(@"DataSource=localhost;Database=C:\Program Files (x86)\Firebird\Firebird_2_1\examples\empbuild\employee.fdb;UserID=SYSDBA;Password=masterkey;Enlist=true")) { DataSet ds1 = new DataSet(); DataSet ds2 = new DataSet(); using (FbDataAdapter adapter1 = new FbDataAdapter("SELECT * FROM Customer", connection)) { adapter1.Fill(ds1); } using (FbDataAdapter adapter2 = new FbDataAdapter("SELECT * FROM Employee", connection)) { adapter2.Fill(ds1); } } } -- Carlos Guzmán Álvarez Vigo-Spain Blog : http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider