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