vb.net TreeView 获得ID谢谢有源码
有个textbox1 我想点TreeView1的子节把ID传给textbox1中,谢谢帮一下!
Imports System.Data.SqlClient
Imports System.Windows.Forms
Public Class Form2
Private ds As New DataSet()
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim CN As New SqlConnection()
Try
'初始化连接字符串
CN.ConnectionString = "Data Source=(local);Initial Catalog=yy;" & _
"Integrated Security=false;User ID=sa;Password=admin"
CN.Open()
'添加命令,从数据库中得到数据
Dim sqlCmd As New SqlCommand()
sqlCmd.Connection = CN
sqlCmd.CommandText = "select * from tbtree"
sqlCmd.CommandType = CommandType.Text
Dim adp As SqlDataAdapter = New SqlDataAdapter(sqlCmd)
adp.Fill(ds)
Catch ex As Exception
MsgBox(ex.Message)
Finally
'关闭连接
CN.Close()
End Try
'调用递归函数,完成树形结构的生成
AddTree(0, Nothing)
End Sub
Private Sub AddTree(ByVal ParentID As Integer, ByVal pNode As TreeNode)
Dim Node As TreeNode
Dim dvTree As New DataView()
dvTree = New DataView(ds.Tables(0))
'过滤ParentID,得到当前的所有子节点
dvTree.RowFilter = "PARENTID = " + ParentID.ToString
Dim Row As DataRowView
For Each Row In dvTree
If pNode Is Nothing Then '判断是否根节点
'̀添加根节点
Node = TreeView1.Nodes.Add(Row("context").ToString())
'̀再次递归
AddTree(Int32.Parse(Row("ID").ToString()), Node)
Else
'添加当前节点的子节点
Node = pNode.Nodes.Add(Row("context").ToString())
'̀再次递归
AddTree(Int32.Parse(Row("ID").ToString()), Node)
End If
Node.EnsureVisible()
Next
End Sub
Private Sub TreeView1_AfterSelect(ByVal sender As System.Object, ByVal e As System.Windows.Forms.TreeViewEventArgs) Handles TreeView1.AfterSelect
End Sub
End Class
Imports System.Data.SqlClient
Imports System.Windows.Forms
Public Class Form2
Private ds As New DataSet()
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim CN As New SqlConnection()
Try
'初始化连接字符串
CN.ConnectionString = "Data Source=(local);Initial Catalog=yy;" & _
"Integrated Security=false;User ID=sa;Password=admin"
CN.Open()
'添加命令,从数据库中得到数据
Dim sqlCmd As New SqlCommand()
sqlCmd.Connection = CN
sqlCmd.CommandText = "select * from tbtree"
sqlCmd.CommandType = CommandType.Text
Dim adp As SqlDataAdapter = New SqlDataAdapter(sqlCmd)
adp.Fill(ds)
Catch ex As Exception
MsgBox(ex.Message)
Finally
'关闭连接
CN.Close()
End Try
'调用递归函数,完成树形结构的生成
AddTree(0, Nothing)
End Sub
Private Sub AddTree(ByVal ParentID As Integer, ByVal pNode As TreeNode)
Dim Node As TreeNode
Dim dvTree As New DataView()
dvTree = New DataView(ds.Tables(0))
'过滤ParentID,得到当前的所有子节点
dvTree.RowFilter = "PARENTID = " + ParentID.ToString
Dim Row As DataRowView
For Each Row In dvTree
If pNode Is Nothing Then '判断是否根节点
'̀添加根节点
Node = TreeView1.Nodes.Add(Row("context").ToString())
'̀再次递归
AddTree(Int32.Parse(Row("ID").ToString()), Node)
Else
'添加当前节点的子节点
Node = pNode.Nodes.Add(Row("context").ToString())
'̀再次递归
AddTree(Int32.Parse(Row("ID").ToString()), Node)
End If
Node.EnsureVisible()
Next
End Sub
Private Sub TreeView1_AfterSelect(ByVal sender As System.Object, ByVal e As System.Windows.Forms.TreeViewEventArgs) Handles TreeView1.AfterSelect
End Sub
End Class
...全文
相关推荐
vs2010 vb.net+access实用示例附源码
本例在 vs2010 环境下使用 vb.net 语言+aceess 数据库开发发的商品销售管理系 里面有对 treeview 和datagridview 的使用方法的例子 vs2010 vb.net+access实用示例附源码
WinForms树形表格控件TreeDataGridView实战指南
在实际业务开发中,层级数据的展示往往面临两难:传统表格视图(如DataGridView)能呈现字段但缺失父子关系,而树形控件(如TreeView)虽能表达层级却难以承载结构化信息。TreeDataGridView作为一款成熟的第三方树形表格控件,将树形层级与表格字段完美融合,在C# WinForms项目中广受欢迎。它以TreeGridNode为核心对象,支持多级嵌套、单元格编辑、动态加载等能力,尤其适用于管理系统、设备台账、物料BOM等“主从表”场景。本文从控件选型、数据建模到核心加载代码,完整演示了如何快
VB.NET实例精讲(含源码)
VB.NET实例精讲(含源码),对计算机专业的本科生很有用,对刚刚从事VB.NET开发的人士也会有很大的帮助,例子是学习编程的最好的教科书
[VB.NET]冰葬·贴吧ID挖掘机 源码
接口什么都去掉了 请协助改善此机器 慢慢玩吧。。。
VB.net获取磁盘、主板、cpu、mac、ip地址等的id号的源码
VB.net获取磁盘、主板、cpu、mac、ip地址等的id号的源码


