datalist隔行显示了,怎么解决啊
我用的是嵌套的datalist,但是不知道为什么里面的数据显示的是隔行隔行的,比如显示1.3.5,而2.4.6则没有显示,怎么回事呢...我要全部显示的,通宵搞这个小站,请大家帮我解决一下哦...下面贴一点代码:
protected void Page_Load(object sender, EventArgs e)
{
Bind();
}
protected void Bind()
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("~/database/ekubaodata.mdb"));
con.Open();
string sql = "select * from SClass where E_BClassName='常用网站' order by E_Num asc";
OleDbDataAdapter sda = new OleDbDataAdapter(sql,con);
DataSet ds = new DataSet();
sda.Fill(ds, "SClass");
DataRowView drv = ds.Tables["SClass"].DefaultView[0];
DataList1.DataSource = ds;
DataList1.DataBind();
}
protected void DataList_OnItemDataBound(object sender, DataListItemEventArgs e)
{
int index = e.Item.ItemIndex;
if (e.Item.ItemType == ListItemType.Item)
{
DataList dl = (DataList)e.Item.FindControl("DataList2");
string id = this.DataList1.DataKeys[index].ToString();
string sql = "select top 5 * from link where SClassId='"+id+"'";
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("~/database/ekubaodata.mdb"));
con.Open();
OleDbDataAdapter sda = new OleDbDataAdapter(sql, con);
DataSet ds = new DataSet();
sda.Fill(ds, "link");
DataRowView drv = ds.Tables["link"].DefaultView[0];
dl.DataSource = ds;
dl.DataBind();
}
}