void createNewQueryTab(string tableName) { try { this.Cursor = Cursors.WaitCursor; this.Update(); TabPage newPage = new TabPage("Query " + (++s_tabCount).ToString()); var queryCtrl = new QueryCtrl(); queryCtrl.Dock = DockStyle.Fill; newPage.Controls.Add(queryCtrl); Tabs.TabPages.Add(newPage); Tabs.SelectedTab = newPage; if (tableName != null) { string sql; //sql = string.Format( "SELECT ID, [FirstName], LastName FROM [{0}]", tableName ); //sql = string.Format( "SELECT * FROM [{0}] ORDERBY LastName", tableName ); //sql = string.Format( @"SELECT ID, [FirstName], LastName FROM [{0}] WHERE firstname LIKE '\bjanet' ORDER BY LastName", tableName ); sql = string.Format("SELECT * FROM {0}", tableName); queryCtrl.Execute(sql, true); } this.Cursor = Cursors.Default; } catch (Exception ex) { this.Cursor = Cursors.Default; MessageBox.Show(this, ex.Message, null, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void Tabs_MouseClick(object sender, MouseEventArgs e) { if (e.Button == System.Windows.Forms.MouseButtons.Right) { Point pt = new Point(e.X, e.Y); for (int n = 0; n < Tabs.TabCount; n++) { if (Tabs.GetTabRect(n).Contains(pt)) { TabPage tabPage = Tabs.TabPages[n]; QueryCtrl queryCtrl = getQueryCtrlFromTabPage(tabPage); if (queryCtrl.OkToClose()) { Tabs.TabPages.Remove(tabPage); } } } } }
private void MainFrm_FormClosing(object sender, FormClosingEventArgs e) { try { foreach (TabPage tabPage in Tabs.TabPages) { QueryCtrl queryCtrl = getQueryCtrlFromTabPage(tabPage); if (!queryCtrl.OkToClose()) { e.Cancel = true; return; } } DbView.CloseAll(); } catch { } if (!e.Cancel) { Utils.Helpers.SaveFormPos(this, Path.Combine(StrFileDbRegKey, "FormSettings", "Main")); } // Keep track of last used date for licensing try { RegistryKey regKey = Registry.LocalMachine.OpenSubKey(MainFrm.WIN_REG_KEY, true); if (regKey == null) { regKey = Registry.CurrentUser.OpenSubKey(MainFrm.WIN_REG_KEY, true); } int nDate = (int)DateTime.Now.ToOADate(); regKey.SetValue(DMRU, nDate.ToString()); } catch { } }