اريد تعديل على الكود لعرض الحقل "Name" وكذلك الحقل "accu" اى بمعنى يظهر فى الشجرة رقم 121 الاصول الثابتة اى رقم بجانبة الاسم وبارك الله فيكم
مشكلة فى tree view
Dim Constr As String = "Provider = microsoft.jet.oledb.4.0; data source =" & Application.StartupPath & "\Accounts.mdb"
Dim Conn As New OleDbConnection(Constr)
Dim AccountDataSet As New DataSet
Dim SQLstr As String = "Select * From Acc"
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Conn.Open()
Dim AccTableAdapter As New OleDbDataAdapter(SQLstr, Conn)
AccTableAdapter.Fill(AccountDataSet, "Acc")
Conn.Close()
CreateTree()
End Sub
Private Sub CreateTree()
TreeView1.BeginUpdate()
TreeView1.Nodes.Clear()
Dim MainHeader As New TreeNode("شجرة الحسابات")
MainHeader.Tag = 0
TreeView1.Nodes.Add(MainHeader)
AddSubNode(MainHeader)
TreeView1.EndUpdate()
TreeView1.ExpandAll()
TreeView1.Select()
End Sub
Private Sub AddSubNode(ByVal Node As TreeNode)
Dim dv1 As DataView = AccountDataSet.Tables("Acc").DefaultView
dv1.RowFilter = "Type =" & CType(Node.Tag, Integer)
For Each drLine As DataRowView In dv1
Dim SubNode As New TreeNode(drLine("Name").ToString())
SubNode.Tag = drLine("ID").ToString
Node.Nodes.Add(SubNode)
If Not SubNode.Tag Is String.Empty Then
AddSubNode(SubNode)
End If
Next
End Sub