using System.Collections.Generic;
public class CategoryInfo
{
int categoryid;
string categoryname;
string categorydesc;
IListArticleInfo> articles;
/// summary>
/// 1,子嵌套數(shù)據(jù)
/// /summary>
public IListArticleInfo> Articles
{
get { return articles; }
set { articles = value; }
}
public int Categoryid
{
get { return categoryid; }
set { categoryid = value; }
}
public string Categoryname
{
get { return categoryname; }
set { categoryname = value; }
}
public string Categorydesc
{
get { return categorydesc; }
set { categorydesc = value; }
}
public CategoryInfo()
{
}
public CategoryInfo(int categoryid, string categoryname, string categorydesc,IListArticleInfo> articles)
{
this.categoryid = categoryid;
this.categoryname = categoryname;
this.categorydesc = categorydesc;
this.articles = articles;
}
}

using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
public class CategoryOper
{
public static IListCategoryInfo> SelectAll()
{
IListCategoryInfo> allcate = new ListCategoryInfo>();
string sql = "select category.categoryid,categoryname,categorydesc,id,title,author from category inner join article on category.categoryid=article.categoryid order by category.categoryid";
SqlConnection con = new DBConnection().Con;
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandText = sql;
com.CommandType = CommandType.Text;
con.Open();
SqlDataReader sdr = com.ExecuteReader();
int tempcategoryid=0;
CategoryInfo cate=null;
while (sdr.Read())
{
int categoryid=sdr.GetInt32(0);
//如果類(lèi)別改變則創(chuàng)建一個(gè)新的 cate 對(duì)象
if(categoryid!=tempcategoryid)
{
cate = new CategoryInfo(sdr.GetInt32(0), sdr.GetString(1), sdr.GetString(2), new ListArticleInfo>());
allcate.Add(cate);
tempcategoryid = categoryid; //把新類(lèi)別編號(hào)付給標(biāo)識(shí)
}
ArticleInfo art = new ArticleInfo(sdr.GetInt32(3), sdr.GetString(4), sdr.GetString(5));
cate.Articles.Add(art);
}
con.Close();
return allcate;
}
public CategoryOper()
{
//
// TODO: 在此處添加構(gòu)造函數(shù)邏輯
//
}
}

%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
html xmlns="http://www.w3.org/1999/xhtml" >
head runat="server">
title>無(wú)標(biāo)題頁(yè)/title>
/head>
body>
form id="form1" runat="server">
div style="text-align:center">
asp:Repeater ID="RepCate" runat="server">
HeaderTemplate>
table border="1">
tr>
td>分類(lèi)編號(hào)/td>
td>分類(lèi)名稱/td>
td>分類(lèi)描述/td>
/tr>
/HeaderTemplate>
ItemTemplate>
tr>
td>%#Eval("categoryid") %>/td>
td>%#Eval("categoryname") %>/td>
td>%#Eval("categorydesc") %>/td>
/tr>
tr>
td>本類(lèi)新聞/td>
td colspan="2">
asp:Repeater ID="RepArticle" runat="server" DataSource='%#Eval("articles") %>' >
HeaderTemplate>
table border="1" style="background-color:#00FF00;">
tr>
td>新聞編號(hào)/td>
td>新聞標(biāo)題/td>
td>新聞作者/td>
/tr>
/HeaderTemplate>
ItemTemplate>
tr>
td>%#Eval("id") %>/td>
td>
asp:HyperLink ID="Hl1" runat="server" Text='%#Eval("title") %>' NavigateUrl='%#string.Format("ShowArticle.aspx?id={0}",Eval("id") ) %>' >/asp:HyperLink>
/td>
td>%#Eval("author") %>/td>
/tr>
/ItemTemplate>
FooterTemplate>
/table>
/FooterTemplate>
/asp:Repeater>
/td>
/tr>
/ItemTemplate>
FooterTemplate>
/table>
/FooterTemplate>
/asp:Repeater>
/div>
/form>
/body>
/html>

using System;
public partial class _Default : System.Web.UI.Page
{
private void BindCategory()
{
RepCate.DataSource = CategoryOper.SelectAll();
RepCate.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindCategory();
}
}
}