private static SqlCommand BuildIntCommand(SqlConnection connection, string storedProcName, IDataParameter[] parameters)
{
SqlCommand command = DbHelperSQLP.BuildQueryCommand(connection, storedProcName, parameters);
command.Parameters.Add(new SqlParameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.ReturnValue, false, 0, 0, string.Empty, DataRowVersion.Default, null));
return(command);
}
public SqlDataReader RunProcedure(string storedProcName, IDataParameter[] parameters)
{
SqlDataReader result;
using (SqlConnection connection = new SqlConnection(this.connectionString))
{
connection.Open();
SqlCommand command = DbHelperSQLP.BuildQueryCommand(connection, storedProcName, parameters);
command.CommandType = CommandType.StoredProcedure;
SqlDataReader returnReader = command.ExecuteReader(CommandBehavior.CloseConnection);
result = returnReader;
}
return(result);
}
public DataSet RunProcedure(string storedProcName, IDataParameter[] parameters, string tableName)
{
DataSet result;
using (SqlConnection connection = new SqlConnection(this.connectionString))
{
DataSet dataSet = new DataSet();
connection.Open();
new SqlDataAdapter
{
SelectCommand = DbHelperSQLP.BuildQueryCommand(connection, storedProcName, parameters)
}.Fill(dataSet, tableName);
connection.Close();
result = dataSet;
}
return(result);
}