private DataSet ExecuteDataAdapterFill(string commandText, CommandType commandType, params IDbDataParameter[] parameters)
{
DataSet results = null;
using (SqlConnection connection = new SqlConnection(ConnectionString))
using (SqlCommand command = new SqlCommand(commandText,connection))
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
if(parameters != null)
{
command.Parameters.AddRange(parameters);
}
command.CommandType = commandType;
try
{
connection.Open();
results = new DataSet();
adapter.Fill(results);
}
finally
{
connection.Close();
}
}
return results;
}