1.无限级菜单绑定
using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "M_ID,M_NAME,M_LEVEL", "[S_MENU]", "WHERE 1=1", "ORDER BY M_ORDERPATH ASC")) //查询所有菜单
{
if (dt != null && dt.Rows.Count > 0)
{
ddlParentId.DataSource = dt;
ddlParentId.DataTextField = "M_NAME";
ddlParentId.DataValueField = "M_ID";
ddlParentId.DataSimulateTreeLevelField = "M_LEVEL";//指定父节点字段
ddlParentId.DataBind();
}
}
ddlParentId.Items.Insert(0, new FineUI.ListItem("≡ 作为一级菜单 ≡", "0", true));