//Set Databases to CMB private void SetupDatabases() { //Clear cmb DB_Databases_Filter_cmb.Items.Clear(); List <string> temp = DbGetinfo.GetAllDatabases(); if (temp.Count > 0) { temp.Insert(0, "All Databases"); } else { temp.Add("No Db Found"); } //Add all items foreach (string i in temp) { DB_Databases_Filter_cmb.Items.Add(i); } //Set selected item DB_Databases_Filter_cmb.SelectedIndex = 0; }
//Set Database Tables to CMB private void SetTables() { DB_TableFilter_cmb.Items.Clear(); DB_TableFilter_cmb.Items.Add("All Tables"); foreach (string i in DbGetinfo.GetTableNames(DB_Databases_Filter_cmb.SelectedItem.ToString())) { DB_TableFilter_cmb.Items.Add(i); } DB_TableFilter_cmb.SelectedIndex = 0; }
//Refresh the database ComboBox private void refresh_btn_Click(object sender, RoutedEventArgs e) { SetupDatabases(); DbGetinfo.SetDatabaseStatus(Db_status_container); }