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

Reply via email to