C# 存储过程传参数

/// <summary>
    /// 执行存储过程，返回dataset
    /// </summary>
    /// <param name="storedProcName">存储过程名</param>
    /// <param name="parameters">参数</param>
    /// <param name="tableName">DataSet结果中的表名</param>
    /// <returns>DataSet</returns>
    protected DataSet RunProcedure(string storedProcName, IDataParameter[] parameters, string tableName)
    {
        using (SqlConnection connection = new SqlConnection(connStr))
        {
            DataSet dataSet = new DataSet();
            connection.Open();
            SqlDataAdapter sqlDa = new SqlDataAdapter();
            sqlDa.SelectCommand = BuildQueryCommand(connection, storedProcName, parameters);
            sqlDa.SelectCommand.CommandTimeout = 30;
            sqlDa.Fill(dataSet, tableName);
            connection.Close();
            return dataSet;

        }
    }

    /// <summary>
    /// 执行存储过程，返回第一行第一个结果
    /// </summary>
    /// <param name="storedProcName">存储过程名字</param>
    /// <param name="parameters">参数</param>
    /// <returns></returns>
    protected string RunProcedureExecuteScalar(string storedProcName, IDataParameter[] parameters)
    {
        using (SqlCo