Re: Treeview control

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jan Hyde (StellaDrinker_at_REMOVE.ME.uboot.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 15:30:10 +0100

"Hrcko" <anonymous@discussions.microsoft.com>'s wild
thoughts were released on Tue, 30 Mar 2004 05:16:13 -0800
bearing the following fruit:

>How can I fill TreeView control with information from sql database?
>Name of the film in root, and information about film(actors,yera of production...) in child ?

The obvious answer is to loop through your recordset and use
.Nodes.add() but I'm guessing you wanted more than that? 

-- 
Jan Hyde (MVP - Visual Basic)
Farmers and sailors make a living off the land. (Jumble) 
[Abolish the TV Licence - http://www.tvlicensing.biz/]

Relevant Pages

  • Re: For each record..Execute... Next
    ... I thought a "For" loop would be the most practical. ... > I'm guessing you're accessing your records through a recordset of some ... >> Public Function Extract(Account_Code As String) As String ...
    (microsoft.public.access.modulesdaovba)
  • Re: For each record..Execute... Next
    ... I'm guessing you're accessing your records through a recordset of some ... That type of loop has worked for me. ... > Dim Tokens() As String ... > I am guessing that the problem I am experiencing is due to the fact that I ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to speed up ADO connection?
    ... following fruit: ... First I joined them in one SQL statement, then loop through one ... Then I split into 2 recordset (one loop for folders and another for ...
    (microsoft.public.vb.database.ado)
  • Re: DAO MUCH faster than ADO in this test
    ... DAO is well-known to be faster than ADO. ... Of course the DAO loop ran faster than the SQL loop; ... advantage of a table-type recordset, which only works on local tables. ... Dim starttime As Single, finishtime As Single ...
    (microsoft.public.access.modulesdaovba)
  • Re: Do While Loop nested in another While causes error
    ... still doesn't explain why a nested DO loop would cause problems. ... Until you sort out the contents of the recordset, ... idHolder = rsGuestbook ... display that new ID. ...
    (microsoft.public.inetserver.asp.db)