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

[ying]

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

[Dimitar Terziev]

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