sql事务应用积累
来源:
中文源码网 浏览:122 次 日期:2024-04-27 11:11:52
【下载文档: sql事务应用积累.txt 】
sql事务应用积累
复制代码 代码如下:///
/// 批量执行SQL语句 /// ///
SQL语句数组 ///
SQL参数对象数组 ///
public static Int32 ExecuteSqls(String[] Sqlstr, List
param) { String ConnStr = GetSqlConnection(); using (SqlConnection conn = new SqlConnection(ConnStr)) { SqlCommand cmd = new SqlCommand(); SqlTransaction tran = null; cmd.Transaction = tran; try { conn.Open(); tran = conn.BeginTransaction(); cmd.Connection = conn; cmd.Transaction = tran; Int32 count = Sqlstr.Length; for (Int32 i = 0; i < count; i++) { cmd.CommandText = Sqlstr[i]; cmd.Parameters.AddRange(param[i]); cmd.ExecuteNonQuery(); } tran.Commit(); return 1; } catch { tran.Rollback(); return 0; } finally { cmd.Dispose(); conn.Close(); } } }