First create a menu table in the database like this
GO
/****** Object: Table [dbo].[menu] Script Date: 08/03/2013 00:03:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[menu](
[id] [int] IDENTITY(1,1) NOT NULL,
[rootmenu] [varchar](50) COLLATE Latin1_General_CI_AI NULL,
[childmenu] [varchar](50) COLLATE Latin1_General_CI_AI NULL,
[subchildmenu] [varchar](50) COLLATE Latin1_General_CI_AI NULL,
CONSTRAINT [PK_menu] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
After that create a page Default.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="DynamicMenu._Default" %>
<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>
<!DOCTYPE html>
<html>
<head id="Head1" runat="server">
<title>Dynamic Menu</title>
<link href="/resources/css/examples.css" rel="stylesheet" />
</head>
<body>
<ext:ResourceManager runat="server" />
<asp:PlaceHolder ID="PlaceHolder1" runat="server" />
</body>
</html>
Then at code behind give the following code
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using Ext.Net;
using System.Data.SqlClient;
namespace DynamicMenu
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataSet PrSet = PDataset("Select * from menu");
foreach (DataRow dr in PrSet.Tables[0].Rows)
{
TreePanel tree = new TreePanel();
tree.RootVisible = false;
Ext.Net.Node root = new Ext.Net.Node();
root.NodeID = dr["rootmenu"].ToString();
root.Expanded = true;
tree.Root.Add(root);
Ext.Net.Node node1 = new Ext.Net.Node();
node1.Text = dr["childmenu"].ToString();
node1.Expanded = true;
node1.Children.Add(new Ext.Net.Node()
{
Text = dr["subchildmenu"].ToString(),
Href = "Default.aspx",
Icon = Icon.User,
Leaf = true
});
root.Children.Add(node1);
Ext.Net.Node node2 = new Ext.Net.Node();
node2.Text = dr["childmenu"].ToString();
node2.Expanded = true;
node2.Children.Add(new Ext.Net.Node()
{
Text = dr["subchildmenu"].ToString(),
Icon = Icon.UserFemale,
Leaf = true
});
root.Children.Add(node2);
Ext.Net.Panel window = new Ext.Net.Panel();
window.Title = dr["RootMenu"].ToString();
window.Width = Unit.Pixel(250);
window.BodyBorder = 0;
window.Layout = "Accordion";
window.Collapsible = true;
window.Items.Add(tree);
this.PlaceHolder1.Controls.Add(window);
}
}
protected DataSet PDataset(string Select_Statement)
{
SqlConnection SqlCon = new SqlConnection("Your Connectionstring");
SqlDataAdapter ad = new SqlDataAdapter(Select_Statement, SqlCon);
DataSet ds = new DataSet();
ad.Fill(ds);
return ds;
}
}
}
Thanks Nimbus77.................
ReplyDelete