treeview的一段代码
来源:互联网 发布:北京电子科技学院知乎 编辑:程序博客网 时间:2024/05/01 12:35
- string sql="select name from sysobject where xtype ='U'";
- SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
- adapter.Fill(resultDS, "sysobject");
- foreach(DataRow row in resultDS.Talbes["sysobject"].Rows)
- {
- sql="Select top 1 * From "+row["Name"].ToString();
- adapter = new SqlDataAdapter(sql, conn);
- adapter.Fill(resultDS, row["Name"].ToString());
- TreeNode tn = new TreeNode();
- tn.Name = row["Name"].ToString();
- tn.Text = row["Name"].ToString();
- treeView1.Nodes.Add(tn);
- foreach(DataColumn col in resultDS.Talbes[row["Name"].ToString()].Columns)
- {
- TreeNode subtn = new TreeNode();
- subtn.Name = col.ColumnName;
- subtn.Text = col.ColumnName;
- tn.Nodes.Add(subtn );
- }
- }