how to display categories by tree view in vb.net

[Milad Biroonvand]

I have a table in the following format and I want to create a form with a tree view control to display the data to the end user. All the rows with LeafCategory is 0 have children. Leaf category 1 means its last category. i.e not expandable. In the following example category id 20081 is the Main category. A category is considered main category when the CategoryID and CategoryParentId are same. CategoryId 's 37903 and 4707 are children of 20081. 37909, 63516, 37911 are childen of 4707... etc. I don't want to write a sql statmet for each node to find out the childen. I'm looking for a solution with arrays, hash table .. etc. VB.NET CategoryId CategoryLevel CategoryName CategoryParentId LeafCategory ----------- ------------- -------------------------------------------------- ---------------- ------------ 20081 1 Antiques 20081 0 37903 2 Antiquities (Classical, Amer.) 20081 0 4707 2 Architectural & Garden 20081 0 37909 3 Ceiling Tins 4707 1 63516 3 Chandeliers, Fixtures, Sconces 4707 1 37911 3 Hardware 4707 0 37912 4 Door Bells, Knockers 37911 1 37913 4 Hooks & Brackets 37911 1 37914 4 Knobs & Handles 37911 1

[Milad Biroonvand]

pleass this see but in vb.net

[DaveAuld]

Better be quick, your assignment for school must be due on Monday is it? FAIL

Dave Who am I?: Web|Facebook|Twitter|LinkedIn|Bebo

[Milad Biroonvand]

no

[Milad Biroonvand]

please help!!!!!!!!!!!!!!!!!!!!!!!!!

[DaveAuld]

If you want help you are going about it the wrong way. READ THE POSTS AT THE TOP OF THE FORUM - They are easy to understand!

Dave Who am I?: Web|Facebook|Twitter|LinkedIn|Bebo

[Milad Biroonvand]

ok ,now help

[DaveAuld]

i think not.

Dave Who am I?: Web|Facebook|Twitter|LinkedIn|Bebo

[Milad Biroonvand]

no problem...

[Lost User]

miladbiranvand wrote:

ok ,now help

Ha, I almost gave a 5 to this for the amount of LOL.

Check out the CodeProject forum Guidelines[^] The original soapbox 1.0 is back![^]