[RESOLVED] Create nodes treeview from database

Ola,

I'm trying to create nodes from a .sdf database according to a specific value in a combobox.

Code:

---

strConn.Open()
Dim cmd_title As New SqlCeCommand("SELECT titles FROM myTable WHERE mytype = '" & cbo_type_select.Text & "'", strConn)
reader = cmd_title.ExecuteReader
While reader.Read
Dim tnode As TreeNode
.... how do I continue from here?
End While

---

Some help would be great. Thanks in advance.

E.g.

vb.net Code:

While reader.Read()
    myTreeView.Nodes.Add(reader.GetString(0))
End While

Thanks jmc. Helped me great. +REP.