private void button1_Click(object sender, EventArgs e) { int index = lb.SelectedIndex; if (index == 2) { AddConnectionForm acd = new AddConnectionForm(); DialogResult r = acd.ShowDialog(); if (r == DialogResult.OK) { shortcut = "SQL Server - " + acd.shortcut; DialogResult = DialogResult.OK; this.Close(); } } else if (index == 4) { AddConnectionForm_Oracle acd = new AddConnectionForm_Oracle(); DialogResult r = acd.ShowDialog(); if (r == DialogResult.OK) { shortcut = "Oracle - " + acd.shortcut; DialogResult = DialogResult.OK; this.Close(); } } }
public void LoadfromOracleConnection(TreeView db, string connectionString) { OracleConnection conn = new OracleConnection(); // conn.ConnectionString = // "Data Source=localhost;" + //// "Initial Catalog=DataBaseName;" + ////"Integrated Security=SSPI; + // "User id=sa;" + // "Password=sa;"; conn.ConnectionString = connectionString; try { //conn.Open(); } catch (Exception ex) { MessageBox.Show("Connection failed " + ex.Message); return; } //data.connection = conn; List <DataRow> tables = AddConnectionForm_Oracle.GetTables(connectionString); db.Nodes.Clear(); TreeNode node = new TreeNode("Tables"); db.Nodes.Add(node); foreach (DataRow row in tables) { string name = row[1].ToString(); TreeNode nodes = new TreeNode(name); //DataTable b = PullData_Oracle(conn, name);// GetTableSchema(conn, name); //foreach (DataColumn r in b.Columns) //{ // string cs = r.ColumnName; // TreeNode ng = new TreeNode(cs.ToString()); // nodes.Nodes.Add(ng); //} nodes.Tag = row; nodes.StateImageKey = "data"; node.Nodes.Add(nodes); TreeNode ns = new TreeNode(); ns.Text = "Oracle"; nodes.Nodes.Add(ns); } tables = GetTablesSchema(conn, "Views"); node = new TreeNode("Views"); db.Nodes.Add(node); foreach (DataRow row in tables) { string name = row[1].ToString(); TreeNode nodes = new TreeNode(name); //DataTable b = PullData_Oracle(conn, name);// GetTableSchema(conn, name); //foreach (DataColumn r in b.Columns) //{ // string cs = r.ColumnName; // TreeNode ng = new TreeNode(cs.ToString()); // nodes.Nodes.Add(ng); //} nodes.Tag = row; nodes.StateImageKey = "data"; node.Nodes.Add(nodes); TreeNode ns = new TreeNode(); ns.Text = "Oracle"; nodes.Nodes.Add(ns); } //tables = GetTables(conn, "Procedures"); //node = new TreeNode("Procedures"); //db.Nodes.Add(node); //foreach (string s in tables) //{ // TreeNode nodes = new TreeNode(s); // node.Nodes.Add(nodes); //} //tables = GetTables(conn, "UserDefinedTypes"); //node = new TreeNode("UserDefinedTypes"); //db.Nodes.Add(node); //foreach (string s in tables) //{ // TreeNode nodes = new TreeNode(s); // node.Nodes.Add(nodes); //} wz = wizard.databaseobjects; }