GridView模版列嵌套GirdView显示主从表数据

<div id="article_content" class="article_content clearfix"> <div id="content_views" class="htmledit_views"> 当需要在一个列表中显示主从表（例如部门-人员的信息），在html" title=asp>asp.net1.1中我们可能会使用DataGrid模版列嵌套DataGrid的方法实现，然而，处理模版列里的DataGrid的翻页、排序、编辑等功能时都比较麻烦。在html" title=asp>asp.net2.0中，配合DataSource控件的使用让这个问题变得非常简单！

<% @ Page Language="C#" AutoEventWireup="true" CodeFile="GridView_GirdView.html" title=asp>aspx.cs" Inherits="GridSamples_GridView_GirdView" %>

<! 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 ="html" title=server>server" >

< title > 无标题页 </ title >

</ head >

< body >

< form id ="form1" runat ="html" title=server>server" >

< div >

< html" title=asp>asp:GridView ID ="GridView1" runat ="html" title=server>server" AutoGenerateColumns ="False" DataKeyNames ="deptid"

DataSourceID ="AccessDataSource1" AllowPaging ="True" AllowSorting ="True" PageSize ="2" OnRowDataBound ="GridView1_RowDataBound" >

< Columns >

< html" title=asp>asp:BoundField DataField ="deptid" HeaderText ="部门编号" InsertVisible ="False" ReadOnly ="True"

SortExpression ="deptid" />

< html" title=asp>asp:BoundField DataField ="deptname" HeaderText ="部门名称" SortExpression ="deptname" />

< html" title=asp>asp:BoundField DataField ="deptremark" HeaderText ="备注" SortExpression ="deptremark" />

< html" title=asp>asp:TemplateField HeaderText ="人员信息" >

< ItemTemplate >

< html" title=asp>asp:GridView ID ="GridView2" runat ="html" title=server>server" AutoGenerateColumns ="False" DataKeyNames ="id"

DataSourceID ="AccessDataSource2" AllowPaging ="True" AllowSorting ="True" PageSize ="5" >

< Columns >

< html" title=asp>asp:BoundField DataField ="id" HeaderText ="人员编号" InsertVisible ="False" ReadOnly ="True"

SortExpression ="id" />

< html" title=asp>asp:BoundField DataField ="name" HeaderText ="姓名" SortExpression ="name" />

< html" title=asp>asp:BoundField DataField ="sex" HeaderText ="性别" SortExpression ="sex" />

</ Columns >

< PagerSettings FirstPageText ="首页" LastPageText ="末页" Mode ="NextPreviousFirstLast"

NextPageText ="下一页" PreviousPageText ="上一页" />

</ html" title=asp>asp:GridView >

< html" title=asp>asp:AccessDataSource ID ="AccessDataSource2" runat ="html" title=server>server" DataFile ="~/App_Data/test.mdb"

SelectCommand ="SELECT [id], [name], [sex], [deptid] FROM [employees] WHERE ([deptid] = ?)" >

< SelectParameters >

< html" title=asp>asp:Parameter Name ="deptid" Type ="Int32" />

</ SelectParameters >

</ html" title=asp>asp:AccessDataSource >< br >

</ ItemTemplate >

</ html" title=asp>asp:TemplateField >

</ Columns >

< PagerSettings FirstPageText ="首页" LastPageText ="末页"

NextPageText ="下一页" PreviousPageText ="上一页" />

</ html" title=asp>asp:GridView >

< html" title=asp>asp:AccessDataSource ID ="AccessDataSource1" runat ="html" title=server>server" DataFile ="~/App_Data/test.mdb"

SelectCommand ="SELECT [deptid], [deptname], [deptremark], [createdate] FROM [departments]" >

</ html" title=asp>asp:AccessDataSource >

</ div >

</ form >

</ body >

</ html >

div> <div style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee"> 1

using System;
2

using System.Data;
3

using System.Configuration;
4

using System.Collections;
5

using System.Web;
6

using System.Web.Security;
7

using System.Web.UI;
8

using System.Web.UI.WebControls;
9

using System.Web.UI.WebControls.WebParts;
10

using System.Web.UI.HtmlControls;
11

public partial class GridSamples_GridView_GirdView : System.Web.UI.Page
13

{
14