关于repeater

 

<asp:repeater id="parent" runat="server">
            <itemtemplate>
                <table width="97%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#6595D6">
                    <tr class="title_link">
                        <td class="title"><img src="skin/dvbbs/images/-.gif" width="9" height="9" hspace="6" align="absmiddle" />
                            <a href='list.aspx?f1_id=<%# DataBinder.Eval(Container.DataItem,"f1_id") %>'>
                                <%# DataBinder.Eval(Container.DataItem,"f1_caption") %>
                            </a>
                        </td>
                    </tr>
                    <!-- start child repeater -->
                    <asp:repeater id="child" DataSource='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("myrelation") %>' runat="server">
                        <itemtemplate>
                            <tr>
                                <td class="board">
                                    <table width="100%" border="0" cellspacing="0" cellpadding="3">
                                        <tr>
                                            <td width="9%" rowspan="2" align="center" class="boardstate"><img src='<%#GetPath1(DataBinder.Eval(Container.DataItem,"[\"f2_pass\"]"))%>' width="24" height="24" /><div align="center"></div>
                                            </td>
                                            <td width="77%"><table width="100%" height="100%" border="0" cellpadding="2" cellspacing="0">
                                                    <tr>
                                                        <td width="67%"><font color="#000000">『<a href='maintable.aspx?f2_id=<%#DataBinder.Eval(Container.DataItem,"[\"f2_id\"]")%>'>
                                                                    <%#DataBinder.Eval(Container.DataItem,"[\"f2_caption\"]")%>
                                                                </a>』</font>
                                                        </td>
                                                        <td width="10%" rowspan="3"><%# GetPath(DataBinder.Eval(Container.DataItem,"[\"f2_forumpic\"]"))%>
                                                        </td>
                                                        <td width="23%">主题： <a href='article_det.aspx?f2_id=<%#DataBinder.Eval(Container.DataItem,"[\"f2_id\"]")%>&f3_id=<%#DataBinder.Eval(Container.DataItem,"[\"f2_lastrootid\"]")%>&pageindex=1'>
                                                                <%#FilterBadWords(dotrim(DataBinder.Eval(Container.DataItem,"[\"f2_lasttopic\"]").ToString(),8))%>
                                                            </a>
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <td width="67%" rowspan="2" valign="top"><img src="skin/dvbbs/images/forum_readme.gif" width="5" height="9" />
                                                            <%#DataBinder.Eval(Container.DataItem,"[\"f2_explain\"]")%>
                                                            <font color="#000000">&nbsp; </font>
                                                        </td>
                                                        <td>作者： <a href='user_infor.aspx?u_user=<%#DataBinder.Eval(Container.DataItem,"[\"f2_lastpostuser\"]")%>' target="_blank">
                                                                <%#DataBinder.Eval(Container.DataItem,"[\"f2_lastpostuser\"]")%>
                                                            </a>
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <td width="23%">日期：
                                                            <%#DataBinder.Eval(Container.DataItem,"[\"f2_lastposttime\"]")%>
                                                            <img src="skin/dvbbs/images/lastpost.gif" width="11" height="10" hspace="7" align="bottom" />
                                                        </td>
                                                    </tr>
                                                </table>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td bgcolor="#E2EBF5">
                                                <table width="100%" border="0" cellspacing="0" cellpadding="1">
                                                    <tr>
                                                        <td width="50%">版主：
                                                            <%#getModerator(DataBinder.Eval(Container.DataItem,"[\"f2_master\"]").ToString())%>
                                                        </td>
                                                        <td width="50%"><table width="60%" border="0" align="right" cellpadding="0" cellspacing="0">
                                                                <tr>
                                                                    <td width="30"><img src="images/Forum_today.gif" width="25" height="10"></td>
                                                                    <td width="200"><div align="center"><a href='user_infor.aspx?u_user=<%#DataBinder.Eval(Container.DataItem,"[\"f2_lastpostuser\"]")%>' target="_blank">
                                                                                <%#DataBinder.Eval(Container.DataItem,"[\"f2_todaynum\"]")%>
                                                                            </a>
                                                                        </div>
                                                                    </td>
                                                                    <td width="30"><img src="images/post.gif" width="25" height="10"></td>
                                                                    <td width="200"><div align="center"><a href='user_infor.aspx?u_user=<%#DataBinder.Eval(Container.DataItem,"[\"f2_lastpostuser\"]")%>' target="_blank">
                                                                                <%#DataBinder.Eval(Container.DataItem,"[\"f2_topicnum\"]")%>
                                                                            </a>
                                                                        </div>
                                                                        </div>
                                                                    </td>
                                                                    <td width="30"><img src="images/topic.gif" width="25" height="10"></td>
                                                                    <td width="200">
                                                                        <div align="center"><a href='user_infor.aspx?u_user=<%#DataBinder.Eval(Container.DataItem,"[\"f2_lastpostuser\"]")%>' target="_blank">
                                                                                <%#Convert.ToInt32(DataBinder.Eval(Container.DataItem,"[\"f2_topicnum\"]").ToString())+Convert.ToInt32(DataBinder.Eval(Container.DataItem,"[\"f2_replynum\"]").ToString())%>
                                                                            </a>
                                                                        </div>
                                                                    </td>
                                                                </tr>
                                                            </table>
                                                        </td>
                                                    </tr>
                                                </table>
                                            </td>
                                        </tr>
                                    </table>
                                </td>
                            </tr>
                        </itemtemplate>
                    </asp:repeater>
                    <!-- end child repeater -->
                </table>
                <table border="0" cellspacing="0" cellpadding="0">
                    <tr>
                        <td height="18"></td>
                    </tr>
                </table>
            </itemtemplate>
        </asp:repeater>

 

            if (Request.Cookies["iscookies"]==null)
            {
                Response.Cookies["iscookies"].Value="0";
                Response.Cookies["iscookies"].Expires=DateTime.Now.AddDays(3650);
                Response.Write ("<META http-equiv=Content-Type content=text/html; charset=gb2312><meta HTTP-EQUIV=REFRESH CONTENT=3>正在登陆论坛……<br><br>本系统要求使用COOKIES，假如您的浏览器禁用COOKIES，您将不能登录本系统……<br><img src=images/quickstart.gif><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>");
            }
            DataSet ds = new DataSet();
            cnn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source="+Server.MapPath("aa.mdb"));
            OleDbDataAdapter cmd1 = new OleDbDataAdapter("select * from forum_1  order by f1_order",cnn);
            cmd1.Fill(ds,"forum_1");
            OleDbDataAdapter cmd2 = new OleDbDataAdapter("select * from forum_2 order by f2_by",cnn);
            cmd2.Fill(ds,"forum_2");
            ds.Relations.Add("myrelation",ds.Tables["forum_1"].Columns["f1_id"],ds.Tables["forum_2"].Columns["f2_sy"]);
            parent.DataSource = ds.Tables["forum_1"].DefaultView;
            Page.DataBind();
            cnn.Close();

 

    public string GetPath1(object o)
        {
            if ((string)o == "1")
                return "skin/dvbbs/images/forum_lock.gif";
            else
                return "skin/dvbbs/images/forum_nonews.gif";
        }