关于事务的一个问题,求指教
SqlConnection conn = DbopUtil.GetConn();
SqlTransaction tran = conn.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = tran;
try
{
....sql语句
tran.commit();
}
catch
{
tran.Rollback();
conn.close();
throw;
}
然后再下面
try
{
conn.open();
....sql语句
tran.commit();
}
catch
{
tran.Rollback();
conn.close();
throw;
}
下面这个有没有用的?