利用GridView显示主细表并添加打开、关闭功能-优快云博客

本文链接：https://blog.youkuaiyun.com/anotherlilei/article/details/5767380

本文例子使用嵌套的 GridView 来显示主细表，并使用 JavaScript 来控制明细表的显示与隐藏。值得注意的是：在 GridView 的 RowDataBound 的事件里，不要多次执行数据库的打开，否则，将很快会导致连接数已满的问题。

例子中的数据库，请参照《 ASP.NET 2.0应用开发技术》一书中附带的光盘中的数据库。

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridViewNested.aspx.cs" Inherits="Exam_GridViewNested" %> <!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>利用GridView显示主细表并添加打开、关闭功能</title> <mce:style type="text/css"></mce:style><style type="text/css" mce_bogus="1"> td,div,a {font-size:12px} </style> <mce:script type="text/javascript"></mce:script> </head> <body> <form id="form1" runat="server"> <asp:GridView ID="MasterGridView" runat="server" AutoGenerateColumns="false" Width="760px" BorderWidth="1" OnRowDataBound="MasterGridView_RowDataBound" DataKeyNames="id" ShowHeader="false"> <Columns> <asp:TemplateField> <ItemTemplate> <div style="width: 100%; padding: 2px; font-weight: bold; background-color: #DEDEDE; float: left"> <span style="float: left" mce_style="float: left">栏目名称：<%#Eval("Title") %></span><span style="float: right; color: Red; cursor: pointer" mce_style="float: right; color: Red; cursor: pointer" οnclick="ShowHidden('<%#Eval("id") %>',event)">隐藏</span></div> <div style="background-color: #FFF; padding-left: 60px;clear:both" mce_style="background-color: #FFF; padding-left: 60px;clear:both" id="div<%#Eval("id") %>"> <asp:GridView ID="DetailGridView" runat="server" AutoGenerateColumns="false" ShowHeader="true" Width="100%" HorizontalAlign="left"> <HeaderStyle BackColor="#9999FF" /> <Columns> <asp:TemplateField HeaderText="文章名称"> <ItemTemplate> <a href="/article/<%#Eval(" mce_href="article/<%#Eval("objectGuid") %>/read.aspx"> <%#Eval("Title") %> </a>[<%# Eval("HitCount") %>] </ItemTemplate> </asp:TemplateField> <asp:BoundField HeaderText="发布日期" DataField="CreateDate" HtmlEncode="false" DataFormatString="{0:yyyy年MM月dd日}" ItemStyle-Width="100px" ItemStyle-HorizontalAlign="Center" /> </Columns> </asp:GridView> </div> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> </form> </body> </html> 本文来自优快云博客，转载请标明出处：http://blog.youkuaiyun.com/net_lover/archive/2006/12/10/1437535.aspx

using System; using System.Data; using System.Data.OleDb; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; public partial class Exam_GridViewNested : System.Web.UI.Page { string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|aspxWeb.mdb;Persist Security Info=True"; OleDbConnection cn1; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { OleDbConnection cn = new OleDbConnection(ConnectionString); cn.Open(); cn1 = new OleDbConnection(ConnectionString); cn1.Open(); OleDbCommand cmd = new OleDbCommand("select * from [Subject]", cn); OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); MasterGridView.DataSource = dr; MasterGridView.DataBind(); dr.Close(); cmd.Dispose(); cn.Dispose(); cn1.Dispose(); cn = cn1 = null; } } protected void MasterGridView_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { GridView oGridView = (GridView)e.Row.FindControl("DetailGridView"); if (oGridView != null) { OleDbCommand cmd = new OleDbCommand("select top 10 * from Document Where pid = " + MasterGridView.DataKeys[e.Row.RowIndex].Value, cn1); OleDbDataReader dr1 = cmd.ExecuteReader(); oGridView.DataSource = dr1; oGridView.DataBind(); dr1.Close(); cmd.Dispose(); } } } } 本文来自优快云博客，转载请标明出处：http://blog.youkuaiyun.com/net_lover/archive/2006/12/10/1437535.aspx