the below attach file is my database record
and the below code is written at the page
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
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;
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