public void loadtreeview(string connection) { FirstMiniProject.FirstMiniProject f = new FirstMiniProject.FirstMiniProject(connection); string sql = string.Format("SELECT name FROM sys.databases WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb')"); DataTable tab = new DataTable(); tab = f.loadtable(sql); for (int i = 0; i < tab.Rows.Count; i++) { string root = tab.Rows[i]["name"].ToString(); TreeView1.Nodes.Add(new TreeNode(root)); string sql1 = string.Format("USE {0} SELECT name FROM sys.Tables", root); DataTable tab1 = new DataTable(); tab1 = f.loadtable(sql1); for (int j = 0; j < tab1.Rows.Count; j++) { string child = tab1.Rows[j]["name"].ToString(); TreeView1.Nodes[i].ChildNodes.Add(new TreeNode(child)); } } }
TreeView1.Nodes.Clear()
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)