学步园

/// <summary>
        /// 执行多条SQL语句，实现数据库事务。
        /// </summary>
        /// <param name="SQLStringList">SQL语句的哈希表（key为sql语句，value是该语句的SqlParameter[]）</param>
        public static void ExecuteSqlTran(Hashtable SQLStringList)
        {            
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                conn.Open();
                using (SqlTransaction trans = conn.BeginTransaction()) 
                {
                    SqlCommand cmd = new SqlCommand();
                    try 
                    {
                        //循环
                        foreach (DictionaryEntry myDE in SQLStringList)
                        {    
                            string     cmdText=myDE.Key.ToString();
                            SqlParameter[] cmdParms=(SqlParameter[])myDE.Value;
                            PrepareCommand(cmd,conn,trans,cmdText, cmdParms);
                            int val = cmd.ExecuteNonQuery();
                            cmd.Parameters.Clear();

                            trans.Commit();
                        }                
                    }
                    catch 
                    {
                        trans.Rollback();
                        throw;
                    }
                }                
            }
        }

eg:

Hashtable SQLStringList = new Hashtable(); 
string cmdText = "insert into userinfo (username,userpwd)values(@username,@userpwd) "; 
SqlParameter[] cmdParms = new SqlParameter[2]; 
cmdParms[0] = new SqlParameter( "@username ", "name "); 
cmdParms[1] = new SqlParameter( "@userpwd ", "pwd "); 
....
SQLStringList.Add(cmdText, cmdParms); 
ExecuteSqlTran(SQLStringList);