private void PopulateUserMenu() { AppMenuBLL appMenu = new AppMenuBLL(); try { DataTable dtUserMenu = appMenu.GetUserGroupMenuData(userGroupIdForSetMenuHiddenField.Value.Trim(), menuForAppDropDownList.SelectedValue.Trim(), menuTypeDropDownList.SelectedValue.Trim()); DataTable dtAllMenu = appMenu.GetAllMenusForMappingUserMenu(menuForAppDropDownList.SelectedValue.Trim(), menuTypeDropDownList.SelectedValue.Trim()); DataRow dr = null; //for (int i = 0; i < dtUserMenu.Rows.Count; i++) //{ // if (dtUserMenu.Rows[i]["IsDisplay"].ToString() == "False") // { // dtUserMenu.Rows.RemoveAt(i); // i--; // } //} for (int i = 0; i < dtUserMenu.Rows.Count; i++) { for (int j = 0; j < dtAllMenu.Rows.Count; j++) { if (dtUserMenu.Rows[i]["ParentMenuId"].ToString() == dtAllMenu.Rows[j]["MenuId"].ToString()) { dr = dtUserMenu.NewRow(); dr["MenuId"] = dtAllMenu.Rows[j]["MenuId"].ToString(); dr["MenuName"] = dtAllMenu.Rows[j]["MenuName"].ToString(); dr["ToolTipDescription"] = dtAllMenu.Rows[j]["ToolTipDescription"].ToString(); dr["ParentMenuId"] = dtAllMenu.Rows[j]["ParentMenuId"].ToString(); dr["URL"] = dtAllMenu.Rows[j]["URL"].ToString(); dr["MenuSorting"] = dtAllMenu.Rows[j]["MenuSorting"].ToString(); dr["DisplayName"] = dtAllMenu.Rows[j]["DisplayName"].ToString(); dr["ImageURL"] = dtAllMenu.Rows[j]["ImageURL"].ToString(); dr["MenuTarget"] = dtAllMenu.Rows[j]["MenuTarget"].ToString(); dtUserMenu.Rows.Add(dr); } } } ///////////////////////////////to convert column data type//////////////////////////////// //DataTable dtCloned = dtUserMenu.Clone(); //dtCloned.Columns["UserMenuSorting"].DataType = typeof(Int32); //foreach (DataRow row in dtUserMenu.Rows) //{ // dtCloned.ImportRow(row); //} dtUserMenu = dtUserMenu.DefaultView.ToTable(true, "MenuId", "MenuName", "ToolTipDescription", "ParentMenuId", "URL", "MenuSorting", "DisplayName", "MenuTarget", "ImageURL"); dtUserMenu.DefaultView.Sort = "MenuSorting"; dtUserMenu = dtUserMenu.DefaultView.ToTable(); ///////////////////////////////to sort by column(s)/////////////////////////////////////// //if (dtUserMenu.Rows.Count > 0) //{ // DataView dv = dtUserMenu.DefaultView; // dv.Sort = "UserMenuSorting"; // dtUserMenu = dv.ToTable(); //} if (dtUserMenu.Rows.Count > 0) { //testAllMenu.Items.Clear(); AddTopMenuItems(dtUserMenu); } else { //msgbox.Visible = true; msgTitleLabel.Text = "User Menu Not Found!!!"; msgDetailLabel.Text = ""; } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { appMenu = null; } }