像上图那样动态获取数据
第一级的我已取出,第二级的怎么显示? 请各位大侠帮忙看看!!!!!
private void ShowData(OracleDb Conn)
{
string strSql="";
if (Request.QueryString["search"].ToString() != null)
{
if (Request.QueryString["ss"] != null)
{
strhref+="&ss="+Request.QueryString["ss"].ToString();
strSql = " and name_cn like '%"+Request.QueryString["ss"]+"%'";
}
}
string sql = "select industry_id,name_cn from industry_type where status='0' and Code Between 'A' And 'T' "+strSql+" order By industry_id ";
DataTable dt = Conn.GetDtRecorder(sql);
StringBuilder html = new StringBuilder();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
html.Append("<li><a href='industryitem.aspx?industry_id=" + dt.Rows[i]["industry_id"] + "'" + CutString(dt.Rows[i]["name_cn"].ToString(), 30) + "</a></li>");
}
}
else
{
html.Append("<li>暂无数据!</li>");
}
Showitem(Conn)//这是二级的数据
industry_list.InnerHtml = html.ToString();
} private void Showitem(OracleDb Conn)
{
string sql_item = "select * from industry_type where status='0' and code between '01' and '98' order by industry_id";
DataTable dt = Conn.GetDtRecorder(sql_item);
StringBuilder htm = new StringBuilder(); for (int j = 0; j < dt.Rows.Count; j++)
{
htm.Append("<ul><li><a href='industryitem.aspx?industry_id=" + dt.Rows[j]["industry_id"] + "'" + CutString(dt.Rows[j]["name_cn"].ToString(), 30) + "</a></li><ul>");
}
item_list.InnerHtml = htm.ToString();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货