void Bind()
{
try
{
SqlConnection Cn = new SqlConnection(constsql1);
userid = Session["Userid"].ToString();
userids = Convert.ToInt32(Session["Userids"]);
SQL = "SELECT MENUITEMS.PARENTID, MENUITEMS.ID, MENUITEMS.TEXT, MENUITEMS.URL, MENUITEMS.URLTARGET FROM MENUITEMS INNER JOIN MENU_RIGHTS ON MENUITEMS.ID = MENU_RIGHTS.Menuids WHERE MENU_RIGHTS.USERID=" + userids + " ORDER BY MENUITEMS.ID";
Cn.Open();
SqlDataAdapter adapter = new SqlDataAdapter(SQL, Cn);
DataSet dsMenus = new DataSet("Menus");
adapter.Fill(dsMenus);
RadPanelBar1.DataSource = dsMenus;
RadPanelBar1.DataFieldID = "ID";
RadPanelBar1.DataFieldParentID = "PARENTID";
RadPanelBar1.DataTextField = "Text";
RadPanelBar1.DataValueField = "ID";
RadPanelBar1.DataNavigateUrlField = "URL";
RadPanelBar1.ExpandMode = PanelBarExpandMode.MultipleExpandedItems;
RadPanelBar1.DataBind();
}
catch (Exception ex)
{
Utility.insertError(ex.Message);
Response.Write("<script>top.location='logout.aspx'</script>");
}
}
