void BtnRefreshDatabaseClick(object sender, EventArgs e)
{
if (cboDatabaseConnection.Text == "(No DB Selected)")
{
MessageBox.Show("Please select a database from the database list");
return;
}
dbConnMan.setCurrentConnectionByName(cboDatabaseConnection.Text);
clearTreeViews();
try
{
List <string> tblList = new List <string>();
tblList = dbConnMan.getCurrentConnection().getTablesList();
foreach (string s in tblList)
{
TreeNode tvNode = new TreeNode(s, 0, 0);
tvNode.ContextMenuStrip = mnuTableOptions;
tvTablesList.Nodes.Add(tvNode);
}
}
catch (Exception ex)
{
MessageBox.Show("Couldn't connect to the database: " + ex.Message);
}
txtStatus.Text = "Status: Connected";
txtStatus.ForeColor = Color.ForestGreen;
txtCurrentDatabase.Text = "Current Database: " + dbConnMan.getCurrentConnection().ConnectionName;
}
public void runCurrentQueryText()
{
currentConnection = dbConnMan.getCurrentConnection();
currentDataset.Clear();
currentConnection.getDBAdapter(getCurrentQueryText()).Fill(currentDataset);
gridResults.DataSource = bindingSource1;
gridResults.AutoGenerateColumns = true;
bindingSource1.DataSource = currentDataset;
bindingSource1.DataMember = currentDataset.Tables[0].TableName;
currentTable = currentDataset.Tables[0];
gridResults.Refresh();
Application.DoEvents();
}
