11-03-2012، 03:07 PM
blank_pageسلام
ساخت menu sub menu یا child menu فکر کنم گیر باشید.
اینو بگیر :
https://github.com/dotnetcurry/DynamicMenus/
یه مثال ::
Creating Dynamic Menu in ASP.net using the Menu Control by fetching the data from the databse.
Introduction
To create a dynamic menu for the website we would use ASP Menu Control, we can’t bind a Menu control directly to database data. Neither the SqlDataSource nor ObjectDataSource controls implement the IHierachicalDataSource interface. Therefore, if we want to represent database data with the Menu control, we need to perform some more work i.e. build the menu items programmatically in the Menu control. This is the approach followed here.
Imagine that you want to represent the contents of the database table with a
Menu control:
This database table represents menu items. The menu items are nested with the help Of the Parent column. For example, the customer menu item is nested under the User management as shown similarly the further nesting can also be done.
LISTING 1.1 MenuDatabase.aspx
protected void Page_Load(object sender, EventArgs e)
{
#region Page-Load-Code
if (!Page.IsPostBack)
PopulateTreeView();
#endregion
}
private void PopulateTreeView()
{
DataTable treeViewData = GetTreeViewData();
AddTopTreeViewNodes(treeViewData);
}
private DataTable GetTreeViewData()
{
// Get Menu table
string selectCommand = "SELECT Id,Parent,Description FROM MenuBarMaster";
string conString = ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString;
SqlDataAdapter dad = new SqlDataAdapter(selectCommand, conString);
DataTable dtblDiscuss = new DataTable();
dad.Fill(dtblDiscuss);
return dtblDiscuss;
}
// This will Get Parent elements from the datatable i.e the root values
private void AddTopTreeViewNodes(DataTable treeViewData)
{
try
{
DataView view = new DataView(treeViewData);
view.RowFilter = "[Parent] IS NULL";
foreach (DataRowView row in view)
{
TreeNode newNode = new TreeNode(row["Description"].ToString(), row["Id"].ToString());
TreeView1.Nodes.Add(newNode);
AddChildTreeViewNodes(treeViewData, newNode);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "dialog", "alert('Unexpected Error');", true);
}
}
// Add child Nodes for the menu
private void AddChildTreeViewNodes(DataTable treeViewData, TreeNode parentTreeViewNode)
{
try
{
DataView view = new DataView(treeViewData);
view.RowFilter = "[Parent]=" + parentTreeViewNode.Value;
foreach (DataRowView row in view)
{
TreeNode newNode = new TreeNode(row["Description"].ToString(), row["Id"].ToString());
parentTreeViewNode.ChildNodes.Add(newNode);
AddChildTreeViewNodes(treeViewData, newNode);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "dialog", "alert('Unexpected Error');", true);
}
}
Now Format Menu Control in .aspx page as shown below:
The menu items are added to the Menu control in the PopulateMenu() method. This
Method first grabs a DataTable that contains the contents of the MenuMaster database table.
Next, it creates a menu item for each row that does not have a parent row (each row Where the Parent column has the value null).The child menu items for each menu item are added recursively. The Parent column is used to ....... the contents of the Menu Master DataTable.
Hope this was useful !
Thanks for reading, do let me know your comments or feedback by replying to this article.
اینم ببین :
http://www.dotnetcurry.com/ShowArticle.aspx?ID=811
این سورس هم ببین :
Article_src(pxr.ir.zip (اندازه 10.99 KB / تعداد دانلود: 6)
ساخت menu sub menu یا child menu فکر کنم گیر باشید.
اینو بگیر :
https://github.com/dotnetcurry/DynamicMenus/
یه مثال ::
Creating Dynamic Menu in ASP.net using the Menu Control by fetching the data from the databse.
Introduction
To create a dynamic menu for the website we would use ASP Menu Control, we can’t bind a Menu control directly to database data. Neither the SqlDataSource nor ObjectDataSource controls implement the IHierachicalDataSource interface. Therefore, if we want to represent database data with the Menu control, we need to perform some more work i.e. build the menu items programmatically in the Menu control. This is the approach followed here.
Imagine that you want to represent the contents of the database table with a
Menu control:
This database table represents menu items. The menu items are nested with the help Of the Parent column. For example, the customer menu item is nested under the User management as shown similarly the further nesting can also be done.
LISTING 1.1 MenuDatabase.aspx
protected void Page_Load(object sender, EventArgs e)
{
#region Page-Load-Code
if (!Page.IsPostBack)
PopulateTreeView();
#endregion
}
private void PopulateTreeView()
{
DataTable treeViewData = GetTreeViewData();
AddTopTreeViewNodes(treeViewData);
}
private DataTable GetTreeViewData()
{
// Get Menu table
string selectCommand = "SELECT Id,Parent,Description FROM MenuBarMaster";
string conString = ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString;
SqlDataAdapter dad = new SqlDataAdapter(selectCommand, conString);
DataTable dtblDiscuss = new DataTable();
dad.Fill(dtblDiscuss);
return dtblDiscuss;
}
// This will Get Parent elements from the datatable i.e the root values
private void AddTopTreeViewNodes(DataTable treeViewData)
{
try
{
DataView view = new DataView(treeViewData);
view.RowFilter = "[Parent] IS NULL";
foreach (DataRowView row in view)
{
TreeNode newNode = new TreeNode(row["Description"].ToString(), row["Id"].ToString());
TreeView1.Nodes.Add(newNode);
AddChildTreeViewNodes(treeViewData, newNode);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "dialog", "alert('Unexpected Error');", true);
}
}
// Add child Nodes for the menu
private void AddChildTreeViewNodes(DataTable treeViewData, TreeNode parentTreeViewNode)
{
try
{
DataView view = new DataView(treeViewData);
view.RowFilter = "[Parent]=" + parentTreeViewNode.Value;
foreach (DataRowView row in view)
{
TreeNode newNode = new TreeNode(row["Description"].ToString(), row["Id"].ToString());
parentTreeViewNode.ChildNodes.Add(newNode);
AddChildTreeViewNodes(treeViewData, newNode);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "dialog", "alert('Unexpected Error');", true);
}
}
Now Format Menu Control in .aspx page as shown below:
کد:
<asp:Menu ID="Menu1" runat="server" Width="236px" OnMenuItemClick="Menu1_MenuItemClick" Height="99px"><DynamicHoverStyle Font-Bold="True" Font-Names="Verdana" Font-Size="14px"/> <DynamicMenuItemStyle BackColor="#F3F3F3" BorderColor="#F3F3F3"Font-Names="Verdana" Font-Size="16px" ItemSpacing="5px" /><DynamicMenuStyle BorderColor="#F3F3F3" BackColor="#F3F3F3" /><StaticHoverStyle Font-Names="Verdana" Font-Size="14px" /><StaticMenuItemStyle Font-Bold="True" Font-Names="Verdana" Font-Size="16px" ItemSpacing="4px" /><StaticMenuStyle HorizontalPadding="5px" VerticalPadding="10px" /></asp:Menu>
The menu items are added to the Menu control in the PopulateMenu() method. This
Method first grabs a DataTable that contains the contents of the MenuMaster database table.
Next, it creates a menu item for each row that does not have a parent row (each row Where the Parent column has the value null).The child menu items for each menu item are added recursively. The Parent column is used to ....... the contents of the Menu Master DataTable.
Hope this was useful !
Thanks for reading, do let me know your comments or feedback by replying to this article.
اینم ببین :
http://www.dotnetcurry.com/ShowArticle.aspx?ID=811
این سورس هم ببین :
Article_src(pxr.ir.zip (اندازه 10.99 KB / تعداد دانلود: 6)
گروه دور همی پارسی کدرز
https://t.me/joinchat/GxVRww3ykLynHFsdCvb7eg
https://t.me/joinchat/GxVRww3ykLynHFsdCvb7eg