treeview handle by database

[jawaidmcs550]

i want to learn treeview handle by database

[shweta123]

Hi,

What platform are you using and What do you want to do with the treeview?

i want to learn treeview handle by database

[gmail]

Hi,

What platform are you using and What do you want to do with the treeview?

Hi Friend,
I am also trying to get somme info about tree view . can you please let me kinow about the reusability of tree view.

TIOA,
Gmail

[Frinavale]

Have you guys checked out MSDN's Library on the TreeView Class?

It has a lot of examples in both VB.NET and C#.


Cheers!
-Frinny

[shweta123]

Hi,

You can have this code to add nodes using db.

 Dim con As New OleDbConnection
        Dim ds As New DataSet
        Dim da As OleDbDataAdapter
        Dim dt As New DataTable
        Dim td As TreeNode
        Dim td1 As TreeNode
 
        Dim sql As String
 
        con.ConnectionString = "Provider=SQLOLEDB.1;............"
        con.Open()
 
        sql = "Select .............."
        da = New OleDbDataAdapter(sql, con)
        da.Fill(dt)
 
        For i As Integer = 0 To dt.Rows.Count - 1
            td = New TreeNode(dt.Rows(i).Item(0))
            ' To add Parent nodes
            TreeView1.Nodes.Add(td)
 
            ' To add the child nodes
             td1 = New TreeNode(dt.Rows(i).Item(0))
            td.Nodes.Add(td1)
        Next
        con.Close()