public void loadDB(System.Windows.Forms.TreeView treeView, DataTable dtDbase)
{
treeView.Nodes.Clear();
DataTable dt = dtDbase;
TreeNode note = new TreeNode();
note.Text = "数据库";
if (dtDbase == null ||dtDbase.Rows.Count ==0 ) { return; }
foreach (DataRow dr in dtDbase.Rows)
{
TreeNode cNode = new TreeNode();//添加实例= new TreeNode(dr["SCHEMA_NAME"].ToString());
cNode.Text = dr["SCHEMA_NAME"].ToString();
cNode.Tag = dr["SCHEMA_NAME"].ToString();
dbName = dr["SCHEMA_NAME"].ToString();
server.DbName = dbName;
dtTable = bllDatabase.GetDataTableNames();
if (dtTable != null || dtTable.Rows.Count > 0)
{
foreach (DataRow dr1 in dtTable.Rows)
{
TreeNode node = new TreeNode();//添加实例
node.Text = dr1["TableComment"].ToString();
node.Tag = dr1["TABLE_NAME"].ToString();
cNode.Nodes.Add(node);
//cNode.Nodes.Add(dr1["TABLE_NAME"].ToString());
}
}
note.Nodes.Add(cNode);//将子节点添加到上级节点中
}
treeView.Nodes.Add(note);//数据添加到treeview
//treeView.ExpandAll();//展开treeview
//只展开根目录
if (treeView.Nodes.Count > 0) { treeView.Nodes[0].Expand(); }
}
07-04
1080
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
05-25