前台
<asp:DataList ID="dlDongtai" runat="server" RepeatColumns="1">
<ItemTemplate>
<table>
<tr>
<td>
<%#Eval("xingwei") %>
</td>
</tr>
<tr>
<td><a href="<%#Eval("xwLujing")%><%#Eval("id") %>"><%#Eval("mingcheng") %></a></td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>
后台
protected void Page_Load(object sender, EventArgs e)
{
bindUserDongtai();
}
protected void bindUserDongtai()
{
string sqlSel = "select * from TimeLineDevelopment where youxiang= '" + Session["youxiang"] + "'";
dlDongtai.DataSource = operateData.getRows(sqlSel);
dlDongtai.DataBind();
}
数据库设计
效果图