.net menu控件手写数据绑定

最新推荐文章于 2025-08-07 14:50:49 发布

freeman127

最新推荐文章于 2025-08-07 14:50:49 发布

阅读量1.5k

点赞数

CC 4.0 BY-SA版权

文章标签： menu .net dataset string

本文链接：https://blog.youkuaiyun.com/freeman127/article/details/5773903

本文提供了一个二级菜单绑定的例子，展示了如何通过C#从数据库获取主菜单和子菜单数据，并将其添加到用户界面中。该示例包括了获取不同年份的视角（Perspective）和关键项（Critical Item）的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一个二级MENU绑定例子：

private void Menu(string strMainId, string strYear) { DataTable menuData = GetMenuDate(strYear); DataTable menuChildData = GetChildMenuDate(strMainId); AddTopMenuTop(menuData,menuChildData); } private DataTable GetChildMenuDate(string strMainid)//string Bu, string Department, string OfficeName, string Year) { //string strSql = "SELECT DISTINCT PERID,PERSPECTIVE,CRIID,CRITICALITEM,MainId FROM VIEW_KPIINF WHERE BU='" + Bu + "' AND SUPDEP='" + Department + "' AND DEP='"+OfficeName+"' AND YEAR='" + Year + "'"; string strSql = "SELECT DISTINCT PERID,PERSPECTIVE,CRITICALITEM FROM VIEW_KPIINF WHERE MAINID='" + strMainid + "'"; SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); SqlDataAdapter da = new SqlDataAdapter(strSql, con); DataSet ds = new DataSet(); da.Fill(ds, "View_KPIINF"); DataTable DT = ds.Tables[0]; return DT; } private DataTable GetMenuDate(string strYear) { string strSql = "SELECT DISTINCT PERID,PERSPECTIVE FROM KPI_PERSPECTIVE WHERE YEAR='" + strYear + "' Order by PerID Asc"; SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); SqlDataAdapter da = new SqlDataAdapter(strSql, con); DataSet ds = new DataSet(); da.Fill(ds, "View_KPIINF"); DataTable DT = ds.Tables[0]; return DT; } private void AddTopMenuTop(DataTable menuData,DataTable ChildMenuData) { DataView view = new DataView(menuData); DataView viewchild=new DataView(ChildMenuData); foreach(DataRowView row in view) { MenuItem newMenuItem=new MenuItem(row["Perspective"].ToString(),row["PerID"].ToString()); Menu1.Items.Add(newMenuItem); AddChildMenu(ChildMenuData, newMenuItem); } } private void AddChildMenu(DataTable ChildMenuData, MenuItem parentMenuItem) { DataView view = new DataView(ChildMenuData); view.RowFilter = "perid=" + parentMenuItem.Value; foreach (DataRowView row in view) { MenuItem newMenuItem = new MenuItem(row["CRITICALITEM"].ToString(), row["CRITICALITEM"].ToString()); parentMenuItem.ChildItems.Add(newMenuItem); } }