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