如何将菜单控件与子节点绑定 [英] How to bind menu control with child node

问题描述

朋友们...
给我一些将菜单控件绑定到数据库的想法.

Hi friends...
Give me some ideas to bind menu control to database.

推荐答案

使用System;
使用System.Collections.Generic;
使用System.Linq;
使用System.Web;
使用System.Web.UI;
使用System.Web.UI.WebControls;
使用System.Data.SqlClient;
使用System.Data;

公共局部类_Default:System.Web.UI.Page
{
受保护的void Page_Load(对象发送者，EventArgs e)
{

如果(！IsPostBack)
{

populateMenuItem();
}
}

私有void populateMenuItem()
{

DataTable menuData = GetMenuData();
AddTopMenuItems(menuData);

}

私有DataTable GetMenuData()
{
使用(SqlConnection con = new SqlConnection(数据源=.\\ SQLEXPRESS; AttachDbFilename = | DataDirectory | \\ Database.mdf; Integrated Security = True; User Instance = True"))
{
使用(SqlCommand cmd =新的SqlCommand("SELECT Id，ParentId，Name from tblProduct"，con))
{
SqlDataAdapter da =新的SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}

}
}

///过滤数据以仅获取具有
的行 ///null ParentID(这将出现在顶层菜单项中)

私有无效AddTopMenuItems(DataTable menuData)
{
DataView视图=新的DataView(menuData);
view.RowFilter ="ParentID IS NULL";
foreach(视图中为DataRowView行)
{
MenuItem newMenuItem =新的MenuItem(row ["Name"].ToString()，row ["Id"].ToString());
Menu1.Items.Add(newMenuItem);
AddChildMenuItems(menuData，newMenuItem);
}

}

//此代码用于通过按ParentID过滤递归地添加子菜单项

私有无效AddChildMenuItems(DataTable menuData，MenuItem parentMenuItem)
{
DataView视图=新的DataView(menuData);
view.RowFilter ="ParentID =" + parentMenuItem.Value;
foreach(视图中为DataRowView行)
{
MenuItem newMenuItem =新的MenuItem(row ["Name"].ToString()，row ["Id"].ToString());
parentMenuItem.ChildItems.Add(newMenuItem);
AddChildMenuItems(menuData，newMenuItem);
}
}

}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

if (!IsPostBack)
{

populateMenuItem();
}
}

private void populateMenuItem()
{

DataTable menuData = GetMenuData();
AddTopMenuItems(menuData);

}

private DataTable GetMenuData()
{
using (SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database.mdf;Integrated Security=True;User Instance=True"))
{
using (SqlCommand cmd = new SqlCommand("SELECT Id,ParentId,Name FROM tblProduct", con))
{
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}

}
}

/// Filter the data to get only the rows that have a
/// null ParentID (This will come on the top-level menu items)

private void AddTopMenuItems(DataTable menuData)
{
DataView view = new DataView(menuData);
view.RowFilter = "ParentID IS NULL";
foreach (DataRowView row in view)
{
MenuItem newMenuItem = new MenuItem(row["Name"].ToString(), row["Id"].ToString());
Menu1.Items.Add(newMenuItem);
AddChildMenuItems(menuData, newMenuItem);
}

}

//This code is used to recursively add child menu items by filtering by ParentID

private void AddChildMenuItems(DataTable menuData, MenuItem parentMenuItem)
{
DataView view = new DataView(menuData);
view.RowFilter = "ParentID=" + parentMenuItem.Value;
foreach (DataRowView row in view)
{
MenuItem newMenuItem = new MenuItem(row["Name"].ToString(), row["Id"].ToString());
parentMenuItem.ChildItems.Add(newMenuItem);
AddChildMenuItems(menuData, newMenuItem);
}
}

}

这篇关于如何将菜单控件与子节点绑定的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！