Get DB Tables.cs

/// <summary>
        /// Get database tables to populate grid
        /// </summary>
        private void GetTables()
        {
            // Get all SQL tables for the db defined in the settings file
            var sql = "SELECT TABLE_NAME As Tables FROM " + Properties.Settings.Default.Database + ".INFORMATION_SCHEMA.TABLES with (nolock) WHERE TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME ASC";
            try
            {
                var dtDatatable = QueryDatabase(ConnectionString, sql).Tables[0];
                gridView1.Columns.Clear();
                tablesGrid.DataSource = null;
                tablesGrid.DataSource = dtDatatable;
                gridView1.BestFitColumns();
                tablesGrid.RefreshDataSource();

                gridView3.Columns.Clear();
                gridControl1.DataSource = null;
                gridControl1.DataSource = dtDatatable;
                gridView3.BestFitColumns();
                gridControl1.RefreshDataSource();
            }
            catch (Exception ex)
            {
                // Show alert on error - no message boxes, using popups
                var alertInfo = new AlertInfo("Error", ex.Message);
                var control = new AlertControl { FormLocation = AlertFormLocation.BottomRight };
                control.Show(ParentForm, alertInfo);
            }
        }