首頁 > 其他

利用DataGrid控制項顯示主－從關係資料表

來源：互聯網
上載者：User
創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

<%@ Page language="c#" Codebehind="ComputeBySNO.aspx.cs" AutoEventWireup="false" Inherits="DataGridInDataGrid.WebForm1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
 <HEAD>
  <title>WebForm1</title>
  <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
  <meta content="C#" name="CODE_LANGUAGE">
  <meta content="JavaScript" name="vs_defaultClientScript">
  <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
 </HEAD>
 <body>
  <h2>按學號統計</h2>
  <hr align="left" width="80%" noShade SIZE="4">
  <br>
  <form id="Form1" method="post" runat="server">
   <FONT face="宋體">
    <div align="left">
     <asp:DataGrid id="dgMaster" runat="server" AutoGenerateColumns="False" ShowHeader="False" GridLines="None">
      <Columns>
       <asp:TemplateColumn>
        <ItemTemplate>
         <TABLE style="FONT-SIZE: 13px" width="400" align="center">
          <TR bgColor="#cccccc">
           <TD>學號：<%# DataBinder.Eval(Container.DataItem,"SNO") %></TD>
           <TD>姓名：<%# DataBinder.Eval(Container.DataItem,"SName") %></TD>
           <TD>性別：<%# Convert.ToInt32(DataBinder.Eval(Container.DataItem,"Sex"))==1?"男":"女" %></TD>
          </TR>
          <TR>
           <TD colSpan="3">
            <asp:DataGrid id=dgDetails runat="server" AutoGenerateColumns="False" OnItemDataBound="dgDetails_ItemDataBound" ShowFooter="True" CellPadding="3" BackColor="White" BorderWidth="1px" BorderStyle="None" BorderColor="#CCCCCC" Width="100%" DataSource='<%# ((System.Data.DataRowView)Container.DataItem).CreateChildView("tableRelation") %>'>
             <FooterStyle Font-Size="12px" ForeColor="#000066" BackColor="White"></FooterStyle>
             <SelectedItemStyle Font-Bold="True" ForeColor="White" BackColor="#669999"></SelectedItemStyle>
             <ItemStyle Font-Size="12px" ForeColor="#000066"></ItemStyle>
             <HeaderStyle Font-Size="12px" Font-Bold="True" ForeColor="White" BackColor="#006699"></HeaderStyle>
             <Columns>
              <asp:TemplateColumn HeaderText="課程名">
               <ItemTemplate>
                <asp:Label runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.CourseName") %>'>
                </asp:Label>
               </ItemTemplate>
               <EditItemTemplate>
                <asp:TextBox runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.CourseName") %>'>
                </asp:TextBox>
               </EditItemTemplate>
              </asp:TemplateColumn>
              <asp:TemplateColumn HeaderText="成績">
               <ItemTemplate>
                <asp:Label ID="lbl_score" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Grade") %>'>
                </asp:Label>
               </ItemTemplate>
               <EditItemTemplate>
                <asp:TextBox runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Grade") %>'>
                </asp:TextBox>
               </EditItemTemplate>
              </asp:TemplateColumn>
              <asp:TemplateColumn HeaderText="任課教師">
               <ItemTemplate>
                <asp:Label runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Teacher") %>'>
                </asp:Label>
               </ItemTemplate>
               <EditItemTemplate>
                <asp:TextBox runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Teacher") %>'>
                </asp:TextBox>
               </EditItemTemplate>
              </asp:TemplateColumn>
             </Columns>
             <PagerStyle HorizontalAlign="Left" ForeColor="#000066" BackColor="White" Mode="NumericPages"></PagerStyle>
            </asp:DataGrid></TD>
          </TR>
          <TR>
           <TD colSpan="3">
            <HR>
           </TD>
          </TR>
         </TABLE>
        </ItemTemplate>
       </asp:TemplateColumn>
      </Columns>
     </asp:DataGrid></div>
   </FONT>
  </form>
 </body>
</HTML>
--------------------------------------------------------------------------------------
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

namespace DataGridInDataGrid
{
 /// <summary>
 /// WebForm1 的摘要說明。
 /// </summary>
 public class WebForm1 : System.Web.UI.Page
 {
  private int SumScore=0;
  private int MaxScore=0;
  private int MinScore=100;//每門課的滿分為100

  protected System.Web.UI.WebControls.DataGrid dgMaster;
  protected System.Web.UI.WebControls.DataGrid DataGrid2;
 
  private void Page_Load(object sender, System.EventArgs e)
  {
   if(!Page.IsPostBack)
   {
    this.BindData();
   }
  }

  private void BindData()
  {
   SqlConnection MyCn=new SqlConnection();
   MyCn.ConnectionString=@"Server=BOBO\PLAYBOY;Database=StudyStatus;Uid=sa;Pwd=840616";
  
   string str_sql = @"select * from students;select SNO,Course.CourseName,Score.Grade,Course.Teacher from Score,Course where Score.CourseNum=Course.CourseNum";
   SqlDataAdapter Myda=new SqlDataAdapter(str_sql,MyCn);

   DataSet ds=new DataSet();
   Myda.Fill(ds);
   ds.Tables[0].TableName="students";
   ds.Tables[1].TableName="Score";

   DataColumn parent=ds.Tables["students"].Columns["SNO"];
   DataColumn child=ds.Tables["Score"].Columns["SNO"];

   DataRelation tableRelation=new DataRelation("tableRelation",parent,child,false);
   ds.Relations.Add(tableRelation);
   
   this.dgMaster.DataSource=ds.Tables["students"].DefaultView;
   this.dgMaster.DataBind();
  }

  /// <summary>
  /// 模板列中的 DataGrid控制項 的ItemDataBound事件
  /// </summary>
  /// <param name="sender"></param>
  /// <param name="e"></param>
  public void dgDetails_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
  {
   DataGrid dg=(DataGrid)(e.Item.Parent.Parent);
  
   if(e.Item.ItemIndex>=0)
   {
    Label lbl_score=(Label)e.Item.Cells[1].FindControl("lbl_score");
    int CurScore=int.Parse(lbl_score.Text);
    
    this.SumScore+=CurScore;
    if(this.MaxScore<CurScore)
    {
     this.MaxScore=CurScore;
    }
    if(this.MinScore>CurScore)
    {
     this.MinScore=CurScore;
    }
   }

   if(e.Item.ItemType==ListItemType.Footer)
   {
    if(dg.Items.Count!=0)
    {
     e.Item.Cells[0].Text="成績統計：[總分]"+this.SumScore.ToString()+"    [平均分]"+String.Format("{0:N2}",(float)SumScore/(float)dg.Items.Count);
     e.Item.Cells[1].Text="[最高分]"+this.MaxScore.ToString();
     e.Item.Cells[2].Text="[最低分]"+this.MinScore.ToString();

     //綁定完後，資料恢複
     this.SumScore=this.MaxScore=0;
     this.MinScore=100;
    }
   }
  }
  #region Web Form設計器產生的程式碼
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 該調用是 ASP.NET Web Form設計器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  /// <summary>
  /// 設計器支援所需的方法 - 不要使用代碼編輯器修改
  /// 此方法的內容。
  /// </summary>
  private void InitializeComponent()
  {   
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion
 }
}

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

聯繫我們

該頁面正文內容均來源於網絡整理，並不代表阿里雲官方的觀點，該頁面所提到的產品和服務也與阿里云無關，如果該頁面內容對您造成了困擾，歡迎寫郵件給我們，收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容，歡迎發送郵件至： info-contact@alibabacloud.com 進行舉報並提供相關證據，工作人員會在 5 個工作天內聯絡您，一經查實，本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More