数据库里有多个字段,可是运行时只显示第一个字段,连下面的子菜单都没显示.if (!Page.IsPostBack)
{
cn.Open();
da = new OleDbDataAdapter("SELECT * FROM dl_info ORDER BY dl_taxis ASC", cn);
ds = new DataSet();
da.Fill(ds);
for (i = 0; i < ds.Tables[0].Rows.Count; i++)
{
MenuItem menuNode = new MenuItem(); menuNode.NavigateUrl = "product/default.aspx?dl=";
menuNode.Text = ds.Tables[0].Rows[i]["dl_name"].ToString(); xlda = new OleDbDataAdapter("SELECT * FROM xl_info WHERE (xl_dlid=" + ds.Tables[0].Rows[i]["dl_id"] + ") ORDER BY xl_taxis ASC",cn);
xlds = new DataSet();
xlda.Fill(xlds);
for (j = 0; j < xlds.Tables[0].Rows.Count; i++)
{
MenuItem xlmi = new MenuItem();
xlmi.NavigateUrl = "product/default.aspx?xl=";
xlmi.Text = xlds.Tables[0].Rows[j]["xl_name"].ToString();
menuNode.ChildItems.Add(xlmi);
} dlmenu.Items.Add(menuNode);
}
{
cn.Open();
da = new OleDbDataAdapter("SELECT * FROM dl_info ORDER BY dl_taxis ASC", cn);
ds = new DataSet();
da.Fill(ds);
for (i = 0; i < ds.Tables[0].Rows.Count; i++)
{
MenuItem menuNode = new MenuItem(); menuNode.NavigateUrl = "product/default.aspx?dl=";
menuNode.Text = ds.Tables[0].Rows[i]["dl_name"].ToString(); xlda = new OleDbDataAdapter("SELECT * FROM xl_info WHERE (xl_dlid=" + ds.Tables[0].Rows[i]["dl_id"] + ") ORDER BY xl_taxis ASC",cn);
xlds = new DataSet();
xlda.Fill(xlds);
for (j = 0; j < xlds.Tables[0].Rows.Count; i++)
{
MenuItem xlmi = new MenuItem();
xlmi.NavigateUrl = "product/default.aspx?xl=";
xlmi.Text = xlds.Tables[0].Rows[j]["xl_name"].ToString();
menuNode.ChildItems.Add(xlmi);
} dlmenu.Items.Add(menuNode);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货