#region 执行存储过程
    /// <summary>
    /// asp.net执行存储过程的类
    /// </summary>
    /// <param name="procName">储过程</param>
    /// <param name="Params">参数</param>
    public void execProc(string procName, SqlParameter[] Params)
    {
        con.Open();
        com = new SqlCommand(procName, con);
        com.CommandType = CommandType.StoredProcedure;
        foreach(SqlParameter parameter in Params)
        {
            com.Parameters.Add(parameter);
        }
        com.ExecuteNonQuery();
        con.Close();
    }
    #endregion

调用以上代码的例子:

    #region 添加数据
    public void add()
    {
        sqldb db = new sqldb();
        try
        {
            SqlParameter[] p =
            {
                 new SqlParameter("@h_id",SqlDbType.Int,4),
                 new SqlParameter("@h_address",SqlDbType.VarChar,50),
                 new SqlParameter("@h_name&quo