从数据库生成动态菜单,以在aps.net和c#中创建CSS和jquery菜单 [英] Generate dynamic menus from database to create css and jquery menus in aps.net and c#
本文介绍了从数据库生成动态菜单,以在aps.net和c#中创建CSS和jquery菜单的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨!
对不起,我的英语不好!
我有这个 imageDB
数据库,我想生成这种格式
Hi!
I am sorry for my poor english!
i have this imageDB
database and i want generate this format
<li>main</li>
<ul>
<li>sub</li>
<li>sub</li>
</ul>
来自c#和asp.net的这张表,请帮助我,它很紧急.
谢谢.
by c# and asp.net from this table please help me it''s urgent.
Thanks.
推荐答案
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection("connectionStringHere");
con.Open();
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
//you need to customize sp as you want
cmd.CommandText = "sp_Here";
System.Data.SqlClient.SqlDataReader reader;
reader = cmd.ExecuteReader();
System.Text.StringBuilder sb=new System.Text.StringBuilder()
sb.AppenedLine("<ul>");
while(reader.Read())
{
//you need to customize this as you want
sb.AppenedFormat("<li>{0}</li>" reader.GetString(0));
}
sb.AppenedLine("</ul>");
尝试使用此代码.
谢谢,
马蒙
Try with this code.
Thanks,
Mamun
这篇关于从数据库生成动态菜单,以在aps.net和c#中创建CSS和jquery菜单的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文