RichTextBox txtResultsBox; // handle to the rich textbox used to display text results #endregion Fields #region Constructors /// <summary> Creates a MDI child form for running queries </summary> /// <param name="dbClient">A configured and connected dbClient object</param> /// <param name="browser">A database Browser object (or null if n/a)</param> /// <param name="hideBrowser">True if the browser should be hidden right away (low bandwidth)</param> public QueryForm(DbClient dbClient, IBrowser browser, bool hideBrowser) { InitializeComponent(); this.dbClient = dbClient; this.browser = browser; lastDatabase = dbClient.Database; // this is so we know when the current database changes HideResults = true; HideBrowser = hideBrowser || (browser == null); FileName = "untitled" + untitledCount++.ToString() + ".sql"; initializing = false; // For some reason, the designer has trouble with 8.0 point fonts - it wants to make it // 7.8 or 8.25, and this looks rather naff in the statusbar. statusBar.Font = new Font (statusBar.Font.Name, 8, FontStyle.Bold); }
public IBrowser Clone(DbClient newDbClient) { SqlBrowser sb = new SqlBrowser(newDbClient); return(sb); }
private void btnConnect_Click(object sender, System.EventArgs e) { // Save contents of controls to XML file. // Data binding to radio buttons doesn't seem to work, sadly, so we have to do this bit manually. dsSettings.settings [0].SqlTrusted = rbSqlTrusted.Checked; dsSettings.settings [0].OraMSDriver = rbOraMSDriver.Checked; dsSettings.settings [0].ConnectionPage = tabControl.SelectedIndex; try { dsSettings.WriteXml(configFile); } catch (Exception) {} // Create DbClient (database client) object IClientFactory clientFactory; string connectString, connectDescription; switch (tabControl.SelectedIndex) { case 0: // SQL Server clientFactory = new SqlFactory(); connectString = "Data Source=" + txtSqlServer.Text.Trim() + ";app=Query Express"; if (rbSqlTrusted.Checked) { connectString += ";Integrated Security=SSPI"; } else { connectString += ";User ID=" + txtSqlLoginName.Text.Trim() + ";Password="******" (" + (rbSqlTrusted.Checked ? "Trusted" : txtSqlLoginName.Text.Trim()) + ")"; break; case 1: // Oracle // As we don't yet have Oracle .NET classes, use the OleDb family of classes instead. clientFactory = new OleDbFactory(); connectString = "Provider=" + ((rbOraMSDriver.Checked) ? "MSDAORA" : "OraOLEDB.Oracle") + ";Data Source=" + txtOraDataSource.Text.Trim() + ";User ID=" + txtOraLoginName.Text.Trim() + ";Password="******"[" + connectString.Substring(0, Math.Min(25, connectString.Length)) + "...]"; break; default: return; } dbClient = new DbClient(clientFactory, connectString, connectDescription); Cursor oldCursor = Cursor; Cursor = Cursors.WaitCursor; ConnectingForm c = new ConnectingForm(); c.Show(); c.Refresh(); bool success = dbClient.Connect(); c.Close(); Cursor = oldCursor; if (!success) { MessageBox.Show("Unable to connect: " + dbClient.Error, "Query Express", MessageBoxButtons.OK, MessageBoxIcon.Error); dbClient.Dispose(); return; } // Create a browser object (if available for the provider) if (tabControl.SelectedIndex == 0) // SQL Server { browser = new SqlBrowser(dbClient); } if (tabControl.SelectedIndex == 1) // Oracle { browser = new OracleBrowser(dbClient); } if (tabControl.SelectedIndex == 2) // OleDb { browser = new dl3bak.OleDbBrowser(dbClient); } DialogResult = DialogResult.OK; }
private void btnConnect_Click(object sender, System.EventArgs e) { // Save contents of controls to XML file. // Data binding to radio buttons doesn't seem to work, sadly, so we have to do this bit manually. dsSettings.settings [0].SqlTrusted = rbSqlTrusted.Checked; dsSettings.settings [0].OraMSDriver = rbOraMSDriver.Checked; dsSettings.settings [0].ConnectionPage = tabControl.SelectedIndex; try { dsSettings.WriteXml (configFile); } catch (Exception) {} // Create DbClient (database client) object IClientFactory clientFactory; string connectString, connectDescription; switch (tabControl.SelectedIndex) { case 0: // SQL Server clientFactory = new SqlFactory(); connectString = "Data Source=" + txtSqlServer.Text.Trim() + ";app=Query Express"; if (rbSqlTrusted.Checked) connectString += ";Integrated Security=SSPI"; else connectString += ";User ID=" + txtSqlLoginName.Text.Trim() + ";Password="******" (" + (rbSqlTrusted.Checked ? "Trusted" : txtSqlLoginName.Text.Trim()) + ")"; break; case 1: // Oracle // As we don't yet have Oracle .NET classes, use the OleDb family of classes instead. clientFactory = new OleDbFactory(); connectString = "Provider=" + ((rbOraMSDriver.Checked) ? "MSDAORA" : "OraOLEDB.Oracle") + ";Data Source=" + txtOraDataSource.Text.Trim() + ";User ID=" + txtOraLoginName.Text.Trim() + ";Password="******"[" + connectString.Substring (0, Math.Min (25, connectString.Length)) + "...]"; break; default: return; } dbClient = new DbClient (clientFactory, connectString, connectDescription); Cursor oldCursor = Cursor; Cursor = Cursors.WaitCursor; ConnectingForm c = new ConnectingForm(); c.Show(); c.Refresh(); bool success = dbClient.Connect(); c.Close(); Cursor = oldCursor; if (!success) { MessageBox.Show ("Unable to connect: " + dbClient.Error, "Query Express", MessageBoxButtons.OK, MessageBoxIcon.Error); dbClient.Dispose(); return; } // Create a browser object (if available for the provider) if (tabControl.SelectedIndex == 0) // SQL Server browser = new SqlBrowser (dbClient); if (tabControl.SelectedIndex == 1) // Oracle browser = new OracleBrowser (dbClient); if (tabControl.SelectedIndex == 2) // OleDb browser = new dl3bak.OleDbBrowser (dbClient); DialogResult = DialogResult.OK; }
public IBrowser Clone(DbClient newDbClient) { OracleBrowser ob = new OracleBrowser(newDbClient); return(ob); }
public SqlBrowser(DbClient dbClient) { this.dbClient = dbClient; }
public OracleBrowser(DbClient dbClient) { this.dbClient = dbClient; }
public IBrowser Clone(DbClient newDbClient) { SqlBrowser sb = new SqlBrowser (newDbClient); return sb; }
public IBrowser Clone(DbClient newDbClient) { OracleBrowser ob = new OracleBrowser (newDbClient); return ob; }