- 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 );
- }
- }
treeview的一段代码
最新推荐文章于 2021-03-19 16:42:57 发布