/// <summary> /// Load database names, setup change event to populate tables /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ForumQuestion_Load(object sender, EventArgs e) { var ops = new SmoOperations(); cboDatabaseNames.DataSource = ops.DatabaseNames(); cboDatabaseNames.SelectedIndexChanged += CboDatabaseNames_SelectedIndexChanged; }
/// <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); } } }
/// <summary> /// Populate ComboBox with database names. /// Setup events for selected index changed for database ComboBox, /// ListBox Table names. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> /// <remarks> /// The code in regards to NorthWindAzure, I have this database /// and use it for testing hence automate the selection of this /// database followed by the Orders table. This in turn triggers /// the column CheckedListBox to populate. /// </remarks> private void BuildInsertStatementForm_Load(object sender, EventArgs e) { // populate with a list of strings representing database names cboDatabaseNames.DataSource = sOps.DatabaseNames(); cboDatabaseNames.SelectedIndexChanged += cboDatabaseNames_SelectedIndexChanged; lstTableNames.SelectedIndexChanged += LstTableNames_SelectedIndexChanged; var Index = cboDatabaseNames.FindString("NorthWindAzure"); if (Index > -1) { cboDatabaseNames.SelectedIndex = Index; Index = lstTableNames.FindString("Orders"); if (Index > -1) { lstTableNames.SelectedIndex = Index; } } else { cboDatabaseNames.SelectedIndex = -1; } }
private void cmdLoadDatabaseNames_Click(object sender, EventArgs e) { var ops = new SmoOperations(); lstDatabaseNames.DataSource = ops.DatabaseNames(); }