/// <summary> /// Populate CheckedListBox with column details for the currently /// selected table. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void LstTableNames_SelectedIndexChanged(object sender, EventArgs e) { clbColumnNames.DataSource = null; var details = sOps.GetColumnDetails(cboDatabaseNames.Text, lstTableNames.Text); clbColumnNames.DataSource = details; }
private void cmdLoadColumnNamesForSelectedTable_Click(object sender, EventArgs e) { currentTableColumDetails = null; if (lstTableNames.DataSource != null) { var ops = new SmoOperations(); lstColumnNames.DataSource = ops.TableColumnNames(lstDatabaseNames.Text, lstTableNames.Text); currentTableColumDetails = ops.GetColumnDetails(lstDatabaseNames.Text, lstTableNames.Text); } else { MessageBox.Show("Please populate the second ListBox with table names"); } }
/// <summary> /// Here for testing that all works I load all ListBoxes /// with know database, table and columns in one shot. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cmdSpecialLoader_Click(object sender, EventArgs e) { var ops = new SmoOperations(); lstDatabaseNames.DataSource = ops.DatabaseNames(); var Index = lstDatabaseNames.FindString("NorthWindAzure"); if (Index > -1) { lstDatabaseNames.SelectedIndex = Index; lstTableNames.DataSource = ops.TableNames(lstDatabaseNames.Text); Index = lstTableNames.FindString("Orders"); if (Index > -1) { lstTableNames.SelectedIndex = Index; lstColumnNames.DataSource = ops.TableColumnNames(lstDatabaseNames.Text, lstTableNames.Text); currentTableColumDetails = ops.GetColumnDetails(lstDatabaseNames.Text, lstTableNames.Text); } } }