初步的学会用数组动态添加参数（一个添加存储过程参数的例子）

mysql.Open();
SqlCommand cmd = new SqlCommand(proc_name, mysql.con);

cmd.CommandType = CommandType.StoredProcedure;
 SqlParameter[] param ={ new SqlParameter("@articleID", SqlDbType.Int), new SqlParameter("@CreateDepartment", SqlDbType.Int) };
            param[0].Value = Convert.ToInt32(articleID);
            param[1].Value = Convert.ToInt32(DepartmentID);
            if (param != null)
            {
                foreach (SqlParameter parameter in param)
                    cmd.Parameters.Add(parameter);
            }