请问在一个论坛里如何动态加载所有论题的名称

Question

<table cellSpacing="1" cellPadding="3" width="748" align="center" class="tbbk1">
<asp:repeater id="repeaterClass" runat="server">
<headertemplate>
<tr class="tdbk3">
<td width="30"></td>
<td>论坛</td>
<td width="150">说明</td>
<td width="100">斑竹</td>
<td width="50">主题</td>
<td width="50">回复</td>
<td>最后发表</td>
</tr>
</headertemplate>
<itemtemplate>
<tr class="tdbk2">
<td><img src="images/img1.gif"></td>
<td colspan="6" align="left"><%# DataBinder.Eval(Container.DataItem,"Class_Name") %></td>
</tr>
<asp:Repeater id="repeaterBoard" runat="server" datasource='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("Board_Class")%>'>
<itemtemplate>
<tr class="tdbk1">
<td><img src='images/board_state_<%# DataBinder.Eval(Container.DataItem,"[\"Board_State\"]")%>.gif'></td>
<td>
<a title="进入这个板块" href='main.aspx?Board_ID=<%# DataBinder.Eval(Container.DataItem,"[\"Board_ID\"]")%>'><%# DataBinder.Eval(Container.DataItem,"[\"Board_Name\"]")%></a>
</td>
<td><%# DataBinder.Eval(Container.DataItem,"[\"Board_Brief\"]") %></td>
<td>斑竹</td>
<td><%# DataBinder.Eval(Container.DataItem,"[\"Board_TopicNum\"]") %></td>
<td><%# DataBinder.Eval(Container.DataItem,"[\"Board_ReplyNum\"]") %></td>
<td class="pad">
<a title="转到这个帖子" href='topic.aspx?Topic_ID=<%# DataBinder.Eval(Container.DataItem,"[\"Board_LastPost_Topic_ID\"]") %>'><%# DataBinder.Eval(Container.DataItem,"[\"Board_LastPost_Topic_Subject\"]") %></a>
<br>
<a title="查看这个用户" href='user.aspx?User_ID=<%# DataBinder.Eval(Container.DataItem,"[\"Board_LastPost_Topic_PostUser_ID\"]") %>'><%# DataBinder.Eval(Container.DataItem,"[\"Board_LastPost_Topic_PostUser_Name\"]") %></a>
于
<%# DataBinder.Eval(Container.DataItem,"[\"Board_LastPost_Topic_PostTime\"]") %>
</td>
</tr>
</itemtemplate>
</asp:Repeater>
</itemtemplate>
</asp:repeater>
</table>

Answer 1

# region 论坛首页类别和板块数据
public static DataSet GetClassAndBoard()
{
if(System.Web.HttpContext.Current.Cache["ClassAndBoard"]==null)
{
DataSet ds=new DataSet();
SqlHelper.FillDataset(Conn.strconn,CommandType.StoredProcedure,"sp_SelectClass",ds,new string[]{"tb_class"});
SqlHelper.FillDataset(Conn.strconn,CommandType.StoredProcedure,"sp_SelectBoard",ds,new string[]{"tb_board"});
ds.Relations.Add("Board_Class",ds.Tables["tb_class"].Columns["Class_ID"],ds.Tables["tb_board"].Columns["Board_Class_ID"]);
System.Web.HttpContext.Current.Cache["ClassAndBoard"]=ds;
return ds;
}
else
{
return (DataSet)System.Web.HttpContext.Current.Cache["ClassAndBoard"];
}
}
# endregion

Answer 2

http://dotnet.aspx.cc/ShowDetail.aspx?id=149E5DD7-3B32-461e-ACC6-51D1652E6746