/// <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();
}