从数据库生成动态菜单，以在aps.net和c#中创建CSS和jquery菜单 [英] Generate dynamic menus from database to create css and jquery menus in aps.net and c#

问题描述

嗨！
对不起，我的英语不好！
我有这个 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屋！