iBase.ru Forum

Код: Выделить всё

FbConnection cn = new FbConnection("User=SYSDBA;Password=...;Database=...;DataSource=172.17.1.200;Port=3050;Charset=WIN1251");
            
            cn.Open();

            FbTransaction tran = cn.BeginTransaction(
                    FbTransactionOptions.NoWait |
                    FbTransactionOptions.ReadCommitted |
                    FbTransactionOptions.RecVersion |
                    FbTransactionOptions.Read |
                    FbTransactionOptions.Write);

            try
            {
                FbCommand cmd = new FbCommand("NEW_PROCEDURE", cn, tran);
                
                cmd.CommandType = CommandType.StoredProcedure;                     
                cmd.ExecuteNonQuery();
                tran.Commit();
            }
            catch
            {
                tran.Rollback();                
            }

            cn.Close();

            Console.ReadKey();