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

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

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

<% @ Page Language="C#" AutoEventWireup="true" CodeFile="GridView_GirdView.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 ="server" >
     < title > 无标题页 </ title >
</ head >
< body >
     < form  id ="form1"  runat ="server" >
     < div >
         < asp:GridView  ID ="GridView1"  runat ="server"  AutoGenerateColumns ="False"  DataKeyNames ="deptid"
            DataSourceID ="AccessDataSource1"  AllowPaging ="True"  AllowSorting ="True"  PageSize ="2"  OnRowDataBound ="GridView1_RowDataBound" >
             < Columns >
                 < asp:BoundField  DataField ="deptid"  HeaderText ="部门编号"  InsertVisible ="False"  ReadOnly ="True"
                    SortExpression ="deptid"   />
                 < asp:BoundField  DataField ="deptname"  HeaderText ="部门名称"  SortExpression ="deptname"   />
                 < asp:BoundField  DataField ="deptremark"  HeaderText ="备注"  SortExpression ="deptremark"   />
                 < asp:TemplateField  HeaderText ="人员信息" >
                     < ItemTemplate >
                         < asp:GridView  ID ="GridView2"  runat ="server"  AutoGenerateColumns ="False"  DataKeyNames ="id"
                            DataSourceID ="AccessDataSource2"  AllowPaging ="True"  AllowSorting ="True"  PageSize ="5" >
                             < Columns >
                                 < asp:BoundField  DataField ="id"  HeaderText ="人员编号"  InsertVisible ="False"  ReadOnly ="True"
                                    SortExpression ="id"   />
                                 < asp:BoundField  DataField ="name"  HeaderText ="姓名"  SortExpression ="name"   />
                                 < asp:BoundField  DataField ="sex"  HeaderText ="性别"  SortExpression ="sex"   />
                             </ Columns >
                             < PagerSettings  FirstPageText ="首页"  LastPageText ="末页"  Mode ="NextPreviousFirstLast"
                NextPageText ="下一页"  PreviousPageText ="上一页"   />
                         </ asp:GridView >
                         < asp:AccessDataSource  ID ="AccessDataSource2"  runat ="server"  DataFile ="~/App_Data/test.mdb"
                            SelectCommand ="SELECT [id], [name], [sex], [deptid] FROM [employees] WHERE ([deptid] = ?)" >
                             < SelectParameters >
                                 < asp:Parameter  Name ="deptid"  Type ="Int32"   />
                             </ SelectParameters >
                         </ asp:AccessDataSource >< br >
                     </ ItemTemplate >
                 </ asp:TemplateField >
                
             </ Columns >
             < PagerSettings  FirstPageText ="首页"  LastPageText ="末页"
                NextPageText ="下一页"  PreviousPageText ="上一页"   />
         </ asp:GridView >
         < asp:AccessDataSource  ID ="AccessDataSource1"  runat ="server"  DataFile ="~/App_Data/test.mdb"
            SelectCommand ="SELECT [deptid], [deptname], [deptremark], [createdate] FROM [departments]" >
         </ asp:AccessDataSource >
    
     </ div >
     </ form >
</ body >
</ html >

 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
12 public  partial  class  GridSamples_GridView_GirdView : System.Web.UI.Page
13 {
14    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
15    {
16        if (e.Row.RowIndex > -1)
17        {
18            AccessDataSource accessDS = e.Row.FindControl("AccessDataSource2") as AccessDataSource;
19            accessDS.SelectParameters["deptid"].DefaultValue = e.Row.Cells[0].Text;
20        }
21    }
22}