BoxInformation.SqlDataAccess.ExecuteDataAdapterFill C# (CSharp) Метод

        private DataSet ExecuteDataAdapterFill(string commandText, CommandType commandType, params SqlParameter[] 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;
        }