.NET 1.X本地事务

SqlTransaction tran;

tran = conn.BgionTransaction();

SqlCommand cmd1 = new SqlCommand(cmdtext1,conn);

cmd1.Transaction = tran;

 

 

SqlCommand cmd2 = new SqlCommand(cmdtext2,conn);

cmd1.Transaction = tran;

 

try

{

cmd1.ExecuteNonQuery();

cmd2.ExecuteNonQuery();

tran.Commit();

 

}

catch

{

tran.Rollback();

 

}

 

finally

{

conn.close();

}