private void btnConnection_Click(object sender, EventArgs e) { FormConfig frmConfig = new FormConfig(); frmConfig.ShowDialog(this.ParentForm); string key = new DBToolConfig().Key; DBToolConfig config = ConfigManager.GetConfig(key) as DBToolConfig; foreach (DBToolConnection conn in config.Connections) { if (!treeView.Nodes.ContainsKey(conn.Name)) { string text = string.Format("{0}({1})", conn.Name, conn.Type); TreeNode databaseNode = treeView.Nodes.Add(conn.Name, text, "database", "database"); Database database = new Database(conn); databaseNode.Tag = database; databaseNode.Nodes.Add("TABLES", "TABLES", "table", "table").Tag = database; } } for (int i = 0; i < treeView.Nodes.Count; i++) { if (!config.Connections.Any(c => c.Name.Equals(treeView.Nodes[i].Name))) { treeView.Nodes.RemoveAt(i); } } }
private void DataObjectTree_Load(object sender, EventArgs e) { if (DesignMode) { return; } string key = new DBToolConfig().Key; DBToolConfig config = ConfigManager.GetConfig(key) as DBToolConfig; foreach (DBToolConnection conn in config.Connections) { string text = string.Format("{0}({1})", conn.Name, conn.Type); TreeNode databaseNode = treeView.Nodes.Add(conn.Name, text, "database", "database"); Database database = new Database(conn); databaseNode.Tag = database; databaseNode.Nodes.Add("TABLES", "TABLES", "table", "table").Tag = database; //databaseNode.Nodes.Add("VIEWS", "VIEWS", "view").Tag = conn; //databaseNode.Nodes.Add("INDEXES", "INDEXES", "index", "index").Tag = conn; } }