//Generates Parent Menu public static String GenerateMenu() { //Create and Instanciate our Table Adapter holding navigation details from the Robot Dataset RobotStandardTableAdapters.navigationmenuTableAdapter table = new RobotStandardTableAdapters.navigationmenuTableAdapter(); //Create and Instanciate our Table Adapter holding navigation Authorization details from the Robot Dataset of tables RobotStandardTableAdapters.navigationmenu_authoriseTableAdapter authoriseAdapter = new RobotStandardTableAdapters.navigationmenu_authoriseTableAdapter(); DataTable authoriseTbl = authoriseAdapter.GetData(); DataTable myTable; if (authoriseTbl.Rows.Count > 0) { myTable = table.GetParentMenuAuthorized(GetAssignedPrivileges());// returns Active Authorised Menus } else { myTable = table.GetParentMenu(); //Returns All active Menus } //Retrive values and set to the DataTable //Menu String Variable String menuHtml = ""; // Loop each Row of the ResultSet foreach (DataRow row in myTable.Rows) { menuHtml += "<li><a href=\"" + row["menu_url"].ToString() + "\"><span class=\"l\"></span><span class=\"r\"></span><span class=\"t\"><b>" + row["menu_name"].ToString() + "</b></span></a>" + GenerateSubMenu(Convert.ToInt32(row["menuID"].ToString())) + "</li>"; } //return menu String to the master Page return menuHtml; }