DataList嵌套GridView实现文章分类列表显示

昨天晚上花了三个多小时写一个程序实现下面这种功能的：

现在我把我的代码贴上来大家分享一下，这个用到一个DataList，和GridView。先到Dreamwaver里面把布局布好，我用的是div+css布局的
然后在DataList中嵌套进GridView控件，在把样式做好，然后就开始写代码了
.aspx中代码：

 1<div id="div_bodyright">
 2
 3<asp:DataList ID="list" runat="server" RepeatColumns="2" RepeatDirection="Horizontal" DataKeyField="TypeID"
 4    RepeatLayout="Flow" OnItemDataBound="list_ItemDataBound">
 5    <ItemTemplate>
 6        <div id="div11" class="bodyleft">
 7            <div id="title1" class="cls_title">
 8                <div id="tl1" class="cls_tleft"><img src="images/bullet1.gif" alt="Title"/>&nbsp;<label id="t1" class="lbTxt"><%# DataBinder.Eval(Container.DataItem, "TypeName")%></label></div>
 9                <div id="tr1" class="cls_tright"><img src="images/more.gif" alt="More" /></div> 
10            </div>
11            <div id="list1" class="divlist">
12            <asp:GridView ID="gvArticle1" runat="server" ShowHeader="false" ShowFooter="false" AutoGenerateColumns="False"  CellPadding="4" ForeColor="#333333" GridLines="None" width="100%">
13            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
14                <Columns>
15                    <asp:TemplateField HeaderText="标题">
16                        <ItemStyle Width="80%" />
17                        <ItemTemplate>
18                            <asp:HyperLink ID="title" runat="server" NavigateUrl='<%#"Article.aspx?aid=" + DataBinder.Eval(Container.DataItem,"ArticleId")%>' title='<%#"标题：" + DataBinder.Eval(Container.DataItem, "ArticleTitle") + "\n发布日期：" + DataBinder.Eval(Container.DataItem,"ArticleDateTime") + "\n点击量：" + DataBinder.Eval(Container.DataItem,"ArticleClick")%>'><%# DataBinder.Eval(Container.DataItem, "ArticleTitle")%></asp:HyperLink>
19                        </ItemTemplate>
20                    </asp:TemplateField>
21                    <asp:BoundField DataField="ArticleDate" HeaderText="日期" ItemStyle-Width="20%" />
22                    
23                </Columns>
24                <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
25                <EditRowStyle BackColor="#999999" />
26                <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
27                <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
28                <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
29                <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
30            </asp:GridView>
31            </div>
32        </div>
33    </ItemTemplate>
34    <AlternatingItemTemplate>
35        <div id="div12" class="bodyright">
36            <div id="title2" class="cls_title">
37                <div id="tl2" class="cls_tleft"><img src="images/bullet1.gif" alt="Title"/>&nbsp;<label id="t2" class="lbTxt"><%# DataBinder.Eval(Container.DataItem, "TypeName")%></label></div>
38                <div id="tr2" class="cls_tright"><img src="images/more.gif" alt="More" /></div>
39            </div>
40            <div id="list1" class="divlist">
41            <asp:GridView ID="gvArticle2" runat="server" ShowHeader="false"  AutoGenerateColumns="False" ShowFooter="false" CellPadding="4" ForeColor="#333333" GridLines="None"  width="100%">
42            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
43                <Columns>
44                    <asp:TemplateField HeaderText="标题">
45                        <ItemStyle Width="80%" />
46                        <ItemTemplate>
47                            <asp:HyperLink ID="title" runat="server" NavigateUrl='<%#"Article.aspx?aid=" + DataBinder.Eval(Container.DataItem,"ArticleId")%>' title='<%#"标题：" + DataBinder.Eval(Container.DataItem, "ArticleTitle") + "\n发布日期：" + DataBinder.Eval(Container.DataItem,"ArticleDateTime") + "\n点击量：" + DataBinder.Eval(Container.DataItem,"ArticleClick")%>'><%# DataBinder.Eval(Container.DataItem, "ArticleTitle")%></asp:HyperLink>
48                        </ItemTemplate>
49                    </asp:TemplateField>
50                    <asp:BoundField DataField="ArticleDate" HeaderText="日期" ItemStyle-Width="20%" />
51                    
52                </Columns>
53                <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
54                <EditRowStyle BackColor="#999999" />
55                <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
56                <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
57                <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
58                <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
59            </asp:GridView>     
60            </div>       
61        </div>
62    </AlternatingItemTemplate>
63</asp:DataList>
64</div>

.cs中的代码：

    BllArticle bll = new BllArticle();

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            list.DataSource = bll.GetTypeList(false);
            list.DataBind();
        }
    }
    protected void list_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            if (e.Item.ItemType == ListItemType.Item)
            {
                GridView gvList1 = (GridView)e.Item.FindControl("gvArticle1");

                gvList1.DataSource = bll.GetArticles(int.Parse(list.DataKeys[e.Item.ItemIndex].ToString()));
                gvList1.DataBind();

            }
            if (e.Item.ItemType == ListItemType.AlternatingItem)
            {                
                GridView gvList2 = (GridView)e.Item.FindControl("gvArticle2");
                gvList2.DataSource = bll.GetArticles(int.Parse(list.DataKeys[e.Item.ItemIndex].ToString()));
                gvList2.DataBind();
            }
        }
    }

在数据层中的代码：

        /**//// <summary>
        /// 获取文章类别的信息 IsAll是不是显示全部信息
        /// </summary>
        /// <param name="IsAll">true 显示所有，false 显示允许显示的内容</param>
        /// <returns></returns>
        public DataSet GetTypeList(bool IsAll)
        {
            using (SqlConnection conn = new SqlConnection(DBSqlHelper.DBConnectionString))
            {
                StringBuilder sb = new StringBuilder();
                if(IsAll)
                {
                    sb.Append(" select * from Info_Type order by TypeOrder desc");
                    return DBSqlHelper.GetDataSet(conn,CommandType.Text,sb.ToString());
                }
                else
                {
                    sb.Append(" select * from Info_Type where TypeVisible=@Visible order by TypeOrder desc");
                    SqlParameter parm = new SqlParameter("@Visible",SqlDbType.VarChar,0);
                    parm.Value = "1";
                    return DBSqlHelper.GetDataSet(conn, CommandType.Text, sb.ToString(), parm);
                }
            }
        }

        /**//// <summary>
        /// 获取前N条文章列表数据
        /// </summary>
        /// <param name="TypeID"></param>
        /// <returns></returns>
        public DataSet GetArticles(int TypeID)
        {
            using (SqlConnection conn = new SqlConnection(DBSqlHelper.DBConnectionString))
            {
                StringBuilder sb = new StringBuilder();
                sb.Append(" select top 10 ArticleId,ArticleTitle,replace(convert(varchar(12),ArticleDate,111),'/','-') as ArticleDate,");
                sb.Append(" ArticleDate as ArticleDateTime,ArticleClick from Info_Article where ArticleType=@typeid order by ArticleId desc");

                SqlParameter parm = new SqlParameter("@typeid", SqlDbType.Int, 0);
                parm.Value = TypeID;

                return DBSqlHelper.GetDataSet(conn, CommandType.Text, sb.ToString(),parm);
            }
        }

这样就可以了，不过我这里就不把CSS文件的代码贴上来了，实现的效果就是上面截图那样的