binding to sqldatasource - URGENT Pls help me

2 posts, 0 answers
  1. Abdul Kadar
    Abdul Kadar avatar
    35 posts
    Member since:
    Oct 2008

    Posted 18 Jan 2009 Link to this post

    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)

     




  2. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 19 Jan 2009 Link to this post

    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.
Back to Top