Hello everybody!
I have a problem when I use radmenu. I need load menu form a SQL database. I done, but I can't use multi-column (Error in IE9 and Firefox ) and when I use scrolling : my radmenu is 2 rows (Error in IE9 but not in FireFox).
Have you any ideas! Thank you very much!
My code is upload in link:
http://www.mediafire.com/?8d1g24e6i5ee1tz
Or:
Code behind:
UI:
I have a problem when I use radmenu. I need load menu form a SQL database. I done, but I can't use multi-column (Error in IE9 and Firefox ) and when I use scrolling : my radmenu is 2 rows (Error in IE9 but not in FireFox).
Have you any ideas! Thank you very much!
My code is upload in link:
http://www.mediafire.com/?8d1g24e6i5ee1tz
Or:
Code behind:
string connectionString = @"Server=PHAMDUCANH-PC\SQLEXPRESS; database=TestDB;Integrated Security = True";
string command = "SELECT * FROM Menu";
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = new SqlCommand(command, conn);
da.SelectCommand = cmd;
da.Fill(ds);
ds.AcceptChanges();
DataSet dsMenu = new DataSet();
dsMenu.Tables.Add(ds.Tables[0].Copy());
if (dsMenu != null && dsMenu.Tables.Count > 0 && dsMenu.Tables[0].Rows.Count > 0)
{
mnuMenu.Items.Clear();
var drGoc = dsMenu.Tables[0].Select("ParentMenuID = -1");
if (drGoc != null && drGoc.Length > 0)
{
foreach (DataRow dr in drGoc)
{
RadMenuItem item = new RadMenuItem();
item.Value = dr["MenuID"].ToString().Trim();
item.Text = dr["Header"].ToString().Trim();
CreateTree(item, dsMenu);
mnuMenu.Items.Add(item);
}
}
}
}
}
public void CreateTree(RadMenuItem node, DataSet ds)
{
try
{
node.Items.Clear();
var p = ds.Tables[0].Select("ParentMenuID=" + node.Value);
if (p != null && p.Length > 0)
{
foreach (DataRow dr in p)
{
RadMenuItem item = new RadMenuItem();
item.Value = dr["MenuID"].ToString().Trim();
item.Text = dr["Header"].ToString().Trim();
if (dr["Path"].ToString().Trim().Length > 0)
{
item.NavigateUrl = "~/Default.aspx?Menu=" + dr["Path"].ToString().Trim();
}
node.Items.Add(item);
CreateTree(item, ds);
}
}
}
catch
{
}
}
<
telerik:RadMenu
runat
=
"server"
ID
=
"mnuMenu"
EnableRootItemScroll
=
"true"
Width
=
"400px"
EnableRoundedCorners
=
"true"
EnableShadows
=
"true"
Skin
=
"WebBlue"
>
<
DefaultGroupSettings
Height
=
"100px"
RepeatColumns
=
"2"
/>
<
Items
>
<
telerik:RadMenuItem
Text
=
"New..."
>
<
GroupSettings
Height
=
"100px"
RepeatColumns
=
"2"
></
GroupSettings
>
<
Items
>
<
telerik:RadMenuItem
Text
=
"File"
></
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Folder"
></
telerik:RadMenuItem
>
</
Items
>
</
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Open"
>
<
GroupSettings
Height
=
"100px"
></
GroupSettings
>
<
Items
>
<
telerik:RadMenuItem
Text
=
"File"
></
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Folder"
></
telerik:RadMenuItem
>
</
Items
>
</
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Close"
>
<
GroupSettings
Height
=
"100px"
></
GroupSettings
>
<
Items
>
<
telerik:RadMenuItem
Text
=
"File"
></
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Folder"
></
telerik:RadMenuItem
>
</
Items
>
</
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Save"
>
<
GroupSettings
Height
=
"100px"
></
GroupSettings
>
<
Items
>
<
telerik:RadMenuItem
Text
=
"File"
></
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Folder"
></
telerik:RadMenuItem
>
</
Items
>
</
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Save as ..."
>
<
GroupSettings
Height
=
"100px"
></
GroupSettings
>
<
Items
>
<
telerik:RadMenuItem
Text
=
"File"
></
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Folder"
></
telerik:RadMenuItem
>
</
Items
>
</
telerik:RadMenuItem
>
</
Items
>
</
telerik:RadMenu
>