Parent Columns and Child Columns don't have type-matching columns.]

2 posts, 0 answers
  1. ying
    ying avatar
    27 posts
    Member since:
    May 2011

    Posted 05 Jul 2011 Link to this post

    the below attach file is my database record

    and the below code is written at the page
    SELECT b.MenuTitle, b.RECID,a.Status,b.Img,
    CASE WHEN b.ParentRECID IS NULL then NULL
    ELSE b.ParentRECID END AS ParentRECID,b.FilePath
    FROM tblAdmin_Access a LEFT JOIN tblMenu b ON (a.MenuRECID = b.RECID)
    WHERE a.AdminRECID = "7fae422d-17a1-4109-9990-2dc284e2439e" AND a.Status ="A"
    ORDER BY b.SeqNo;
    I have use mySql as my database

                RadPanelBar1.DataSource = objDS.Tables(0)
                RadPanelBar1.DataFieldID = "RECID"
                RadPanelBar1.DataFieldParentID = "ParentRECID"
                RadPanelBar1.DataNavigateUrlField = "FilePath"
                RadPanelBar1.DataValueField = "Img"
                RadPanelBar1.DataTextField = "MenuTitle"
                RadPanelBar1.DataBind()

    bind to radpanelbar
  2. Dimitar Terziev
    Admin
    Dimitar Terziev avatar
    1266 posts

    Posted 08 Jul 2011 Link to this post

    Hello Ying,

    Please try to clarify what is the issue that you are experiencing so we could help you out.

    Greetings,
    Dimitar Terziev
    the Telerik team

    Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top