时间：2021-07-01 10:21:17 帮助过：5人阅读
事物的简单应该
转自：https://www.cnblogs.com/hgmyz/p/6490288.html
| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
sql1="INSERT INTO tablename(Id,col1,col2) VALUES(@Id,@col1,@col2) update tablename2 set col=@col";
sql2="INSERT INTO tablename3(Id,col1,col2) VALUES(@Id,@col1,@col2)";
//参数设置（略）
using(SqlTransaction tran = SqlHelper.BeginTransaction(SqlHelper.DBConnectionString))
{
try
{
SqlHelper.ExecuteNonQuery(tran,CommandType.Text,sql1,parms);
SqlHelper.ExecuteNonQuery(tran,CommandType.Text,sql2,parms);
tran.Commit();
return true;
}
catch
{
tran.Rollback();
return false;
}
|
放在sqlhelper.cs中
| 1 2 3 4 5 6 7 |
public static SqlTransaction BeginTransaction(string con)
{
SqlConnection connection = new SqlConnection(con);
connection.Open();
SqlTransaction tran = connection.BeginTransaction();
return tran;
}
|
SqlTransaction
标签：.exe cti value add help container arp htm line