SqlConnection Connection = new SqlConnection("server=.;uid=sa;pwd=1;database=dPnY;");
SqlCommand cmd1 = new SqlCommand();
SqlCommand cmd2 = new SqlCommand();
cmd1.Connection = Connection;
cmd2.Connection = Connection;
Connection.Open();
SqlTransaction sqlTran = Connection.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted);
//SqlCommand cmd1 = Connection.CreateCommand();
//SqlCommand cmd2 = Connection.CreateCommand();
try
{
cmd1.CommandText = "insert into tBom (cMemo) Values('a')";
cmd1.Transaction = sqlTran;
cmd1.ExecuteNonQuery();
sqlTran.Commit();
//下面一句故意让其出错,让事务不能提交
int i = Convert.ToInt32("a");
cmd2.CommandText = "insert into tBom (cMemo) Values('b')";
cmd2.Transaction = sqlTran;
cmd2.ExecuteNonQuery();
sqlTran.Commit();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
sqlTran.Rollback();
}
finally
{
Connection.Close();
sqlTran.Dispose();
}