ado.net 事物回滚
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
Code
SqlTransaction tran;
tran = con.BeginTransaction();
SqlCommand cmd1 = new SqlCommand(cmdText1);
cmd1.Connection = con;
cmd1.Transaction = tran;
…
SqlCommand cmd2 = new SqlCommand(cmdText2);
cmd2.Connection = con;
cmd2.Transaction = tran;
…
try{
cmd1.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
tran.Commit();
}catch{
tran.Rollback();
}finally{
con.Close();
}
posted @
2009-07-26 18:23
年轻国王
阅读(
94)
评论()
编辑
收藏
举报