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
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider