【下载文档:  c# 执行事务函数代码.txt 】

---

c# 执行事务函数代码
复制代码 代码如下:///

/// 执行多条sql语句，实现事务 ///

/// 多条sql语句 public int ExecutrSqlTran(System.Collections.ArrayList arraySql) { int itemnum; DbOpen(); SqlCommand cm = new SqlCommand(); cm.Connection = scn; SqlTransaction tx = scn.BeginTransaction(); cm.Transaction = tx; try { for (int i = 0; i < arraySql.Count; i++) { string strSql = arraySql[i].ToString(); if (strSql.Trim().Length > 1) { cm.CommandText = strSql; cm.ExecuteNonQuery(); } } tx.Commit(); itemnum = 1; } catch (SqlException E) { tx.Rollback(); itemnum = 0; throw new Exception(E.Message); } DbClose(); return itemnum; } }