C # How to call a stored procedure

/Database connection string (configured by web. config). You can dynamically change connectionString to support multiple databases.
Public static string connectionString = System. Configuration. ConfigurationManager. ConnectionStrings ["ConnectionString"]. ConnectionString;

/// <Summary>
/// Execute the stored procedure and return SqlDataReader (Note: after calling this method, you must Close SqlDataReader)
/// </Summary>
/// <Param name = "storedProcName"> stored procedure name </param>
/// <Param name = "parameters"> stored procedure parameters </param>
/// <Returns> SqlDataReader </returns>
Public static SqlDataReader RunProcedure (string storedProcName, IDataParameter [] parameters)
{
SqlConnection connection = new SqlConnection (connectionString );
SqlDataReader returnReader;
Connection. Open ();
SqlCommand command = BuildQueryCommand (connection, storedProcName, parameters );
Command. CommandType = CommandType. StoredProcedure;
ReturnReader = command. ExecuteReader (CommandBehavior. CloseConnection );
Return returnReader;

}


/// <Summary>
/// Execute the Stored Procedure
/// </Summary>
/// <Param name = "storedProcName"> stored procedure name </param>
/// <Param name = "parameters"> stored procedure parameters </param>
/// <Param name = "tableName"> name of the table in the DataSet result </param>
/// <Returns> DataSet </returns>
Public static DataSet RunProcedure (string storedProcName, IDataParameter [] parameters, string tableName)
{
Using (SqlConnection connection = new SqlConnection (connectionString ))
{
DataSet dataSet = new DataSet ();
Connection. Open ();
& N