using System;
using System.Data;
using Hitachi.HiRDB;
 
namespace test_C
{
    class Sample
    {
        [STAThread]
        static void Main(string[] args)
        {
            // Create a Connection object
            HiRDBConnection cn = new HiRDBConnection("dsn=pc;");
 
            // Connect to the database
            cn.Open();
 
            // Create a Transaction object
            HiRDBTransaction tran;
            // Start of transaction
            tran = cn.BeginTransaction(IsolationLevel.ReadCommitted);  ..1
            // Create a Command object
            HiRDBCommand cm = new HiRDBCommand();
            cm.Connection = cn;
            cm.Transaction = tran;
            try
            {
                // Insert data in the table
                cm.CommandText = "insert into ex values (1)";
                cm.ExecuteNonQuery();
 
                // Transaction was successful
                tran.Commit();  .........................................2
 
                // Disconnect from the database
                cn.Close();
            }
            catch (HiRDBException ex)
            {
                // Transaction failed
                tran.Rollback();  .......................................3
 
                Console.WriteLine(ex);
            }
            catch (System.Exception ex)
            {
                // Transaction failed
                tran.Rollback();  .......................................3
 
                Console.WriteLine(ex);
            }
        }
    }
}