Wednesday, October 12, 2011

Transaction in c#


SqlConnection con = new SqlConnection("Connection String");

     SqlCommand command1 = new SqlCommand(); //properly initiliased command with sql text or procedure name
            SqlCommand command2 = new SqlCommand(); //properly initiliased command with sql text or procedure name

            SqlTransaction trx = conn.BeginTransaction();
            command1.Transaction = trx;
            command2.Transaction = trx;

            try
            {
                command1.ExecuteNonQuery();
                command2.ExecuteNonQuery();
                trx.Commit();
            }
            catch (SqlException ex)
            {
                trx.Rollback();
            }
            finally
            {
                //clean up resources
            }

No comments:

Post a Comment