how to bind database to tree view from three table

Question

1.00/5 (3 votes)

See more:

what is the coding for treeview to show dynamic content from database.
for example:
i have three table as shown below
1. category(cateId,cateName,CateDescrip)
2. Brand(catId,BrandId,BrandName,BrandDescrip)
3. Product(BrandId,ProId,ProName,Prodescrip)
and i want to show the tree view like this:

*Car
__*Tata
______*Indica
______*Nano
__*Honda
______*City
______*Crapter
*Bike
__*Bajaj
______*Pulsar
______* XCD
__*HeroHonda
______*CBZ
______*Splender

so plz provide me the code for this
as soon as possible.
regards
Balwant.

Posted 30-Nov-10 19:38pm

Balwant.mnd

Add a Solution

Comments

Sandeep Mewara 1-Dec-10 1:51am

No effort and asking for code!

rasada 1-Dec-10 9:32am

Submit your code what you have completed for this solution.

Abdul Quader Mamun 1-Dec-10 9:34am

Show your effort.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abdul Quader Mamun · Answer 1 · 2010-11-30T20:01:00

Solution 3

Thank you for your question. Follow the link.

http://www.codeproject.com/KB/aspnet/ParentChildTreeView.aspx[^]

Thanks,
Mamun

Posted 30-Nov-10 20:01pm

Abdul Quader Mamun

vivekse · Answer 2 · 2010-11-30T19:51:00

Solution 1

Hi Balwant

See this link.

http://www.codeproject.com/KB/aspnet/DataTreeView.aspx[^]

Posted 30-Nov-10 19:51pm

vivekse

Sandeep Mewara · Answer 3 · 2010-11-30T19:54:00

Solution 2

You should have tried! All you need is to form the dataset correctly such that the tree structure can be formed as desired.

There could be multiple ways to do it. Either have a well structured dataset/datatable or write a logic to form an XML as desired to feed into treeview.

Posted 30-Nov-10 19:54pm

Sandeep Mewara