sql事务应用积累_public static int executesql(string sqlstring)-CSDN博客

本文链接：https://blog.csdn.net/greatverve/article/details/3332569

sqlhelper中执行事务一例

 
 /// <summary> 
        /// 批量执行SQL语句 
        /// </summary> 
        /// <param name="Sqlstr">SQL语句数组</param> 
        /// <param name="param">SQL参数对象数组</param> 
        /// <returns></returns> 
        public static Int32 ExecuteSqls(String[] Sqlstr, List<SqlParameter[]> 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();
                }
            }
        }
 