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