/// <summary> /// Load the text boxes from the given conncetion /// </summary> public void LoadConnection(Connection c) { txtName.Text = c.Name; txtUser.Text = c.User; txtPass.Text = c.Pass; txtHost.Text = c.Host; txtPort.Text = c.Port; txtSid.Text = c.Sid; txtService.Text = c.Service; }
/// <summary> /// Get the connection details from the dialog controls in the format of a connection class /// </summary> public void SaveConnection(Connection c) { c.Name = txtName.Text.Trim(); c.User = txtUser.Text.Trim(); c.Pass = txtPass.Text.Trim(); c.Host = txtHost.Text.Trim(); c.Port = txtPort.Text.Trim(); c.Sid = txtSid.Enabled ? txtSid.Text.Trim() : ""; c.Service = txtService.Enabled ? txtService.Text.Trim() : ""; }
private void treeConnections_DoubleClick(object sender, EventArgs e) { // Did they double click anything important? TreeNode node = treeConnections.SelectedNode; if (node.Tag is Table) { // Open up the table in the query screen Table t = (Table)(node.Tag); txtQuery.Text = "select * from " + t.ParentSchema.Name + "." + t.Name; lblConn.Text = "Connection: " + t.ParentSchema.ParentConnection.Name; selected_conn = t.ParentSchema.ParentConnection; txtQuery.Enabled = true; gridOutput.Enabled = true; bnExecute.Enabled = true; Application.DoEvents(); // show the updates from above bnExecute_Click(null, null); } }
private void bnNew_Click(object sender, EventArgs e) { EditConnection ec = new EditConnection(); if (ec.ShowDialog() == DialogResult.OK) { Connection c = new Connection(); ec.SaveConnection(c); TreeNode n = new TreeNode(c.Name); n.ImageIndex = 1; n.SelectedImageIndex = 1; n.Tag = c; n.Nodes.Add(loading); treeConnections.Nodes.Add(n); connections.Add(c); } }
public Schema(Connection Parent) { ParentConnection = Parent; }