binding to sqldatasource - URGENT Pls help me

[Abdul Kadar]

Hi .,
I want to bind a treeview with sql datasource.I use the below code.Pls guide me how to use parentid (I am using asp.net with vb)

 

<telerik:RadTreeView ID="RadTreeView1" runat="server" DataSourceID="SqlDataSource1" DataTextField="DESCRIPTION" DataValueField="CODE"></telerik:RadTreeView>
Using the above code, I got the output as 
                            

 

o   Scanner ( description)

o   Printer   ( description)

o   Laptop   ( description)

      o   Cute FTp  ( description)

o   Logmein  ( description

Below is sql select query

 

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:EsteeConnectionString %>"

 

 

SelectCommand="SELECT [CODE], [DESCRIPTION],[MAINCATEGORY] FROM [BRANDMASTER]"></asp:SqlDataSource>

 

I need the output as follows:

Ø  Hardware     ( maincategory )

o   Scanner ( description)

o   Printer   ( description)

o   Laptop   ( description)

Ø  Software   (maincategory)

o   Cute FTp  ( description)

o   Logmein  ( description)

 

[Shinu]

Hi Abdul,

Go through the following help articles which explain how to implement a hierarchical type of data-binding with TreeView. See how the DataFieldID and DataFieldParentID properties are used to set the DataBase relation.
SqlDataSource or AccessDataSource
Binding to a Database

Thanks,
Shinu.