62,046
社区成员
发帖
与我相关
我的任务
分享
public void DoSqlTransactioin(string[] sqls)
{
SqlCommand comm = conn.CreateCommand();
SqlTransaction trans = conn.BeginTransaction();
comm.Transaction = trans;
try
{
conn.Open();
foreach (string sql in sqls)
{
comm.CommandText = sql;
comm.ExecuteNonQuery();
}
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
}
finally
{
conn.Close();
}
}