[ASP.NET]"GridView合併儲存格"的相關資源

2008-10-29

19287
0
ASP.NET

最近看到有人在討論GridView合併儲存格的問題...
網路上有有很多人也都寫了相關的文章..如下列網址

最近看到有人在討論GridView合併儲存格的問題...

網路上有有很多人也都寫了相關的文章..如下列網址

藍色小舖討論區
http://epaper.blueshop.com.tw/board/show.asp?subcde=BRD20061225110536B4G&fumcde=FUM20050124192253INM

點部落-mis2000lab
http://www.dotblogs.com.tw/mis2000lab/archive/2008/04/24/3451.aspx

MSDN論壇
http://forums.microsoft.com/MSDN-CHT/ShowPost.aspx?PostID=2688678&SiteID=14

鳥毅的Blog
http://blog.tenyi.com/2008/03/gridview.html

小弟就選最後一個網址的做法實作看看...

asp.net(c#)
GridViewCombinField.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridViewCombinField.aspx.cs" Inherits="GridViewCombinField" %> <!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> <table style="width: 50%" id="TABLE1"> <tr> <td> 原始表格<asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" CellSpacing="1" DataSourceID="SqlDataSource1" EmptyDataText="沒有資料錄可顯示。" GridLines="None"> <RowStyle BackColor="#DEDFDE" ForeColor="Black" /> <Columns> <asp:BoundField DataField="Group1" HeaderText="Group1" SortExpression="Group1" /> <asp:BoundField DataField="Group2" HeaderText="Group2" SortExpression="Group2" /> <asp:BoundField DataField="Item" HeaderText="Item" SortExpression="Item" /> </Columns> <FooterStyle BackColor="#C6C3C6" ForeColor="Black" /> <PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" /> <SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" /> </asp:GridView> </td> <td> 合併Group1 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" CellSpacing="1" DataSourceID="SqlDataSource1" EmptyDataText="沒有資料錄可顯示。" GridLines="None" OnPreRender="GridView1_PreRender"> <RowStyle BackColor="#DEDFDE" ForeColor="Black" /> <Columns> <asp:BoundField DataField="Group1" HeaderText="Group1" SortExpression="Group1" /> <asp:BoundField DataField="Group2" HeaderText="Group2" SortExpression="Group2" /> <asp:BoundField DataField="Item" HeaderText="Item" SortExpression="Item" /> </Columns> <FooterStyle BackColor="#C6C3C6" ForeColor="Black" /> <PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" /> <SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" /> </asp:GridView> </td> <td> 合併Group1與Group2 <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" CellSpacing="1" DataSourceID="SqlDataSource1" EmptyDataText="沒有資料錄可顯示。" GridLines="None" OnPreRender="GridView2_PreRender"> <RowStyle BackColor="#DEDFDE" ForeColor="Black" /> <Columns> <asp:BoundField DataField="Group1" HeaderText="Group1" SortExpression="Group1" /> <asp:BoundField DataField="Group2" HeaderText="Group2" SortExpression="Group2" /> <asp:BoundField DataField="Item" HeaderText="Item" SortExpression="Item" /> </Columns> <FooterStyle BackColor="#C6C3C6" ForeColor="Black" /> <PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" /> <SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" /> </asp:GridView> </td> </tr> </table>   <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT [Group1], [Group2], [Item] FROM [Table3]"> </asp:SqlDataSource> </div> </form> </body> </html>

GridViewCombinField.aspx.cs

using System; using System.Data; 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.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class GridViewCombinField : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void GridView1_PreRender(object sender, EventArgs e) { int[] mergeColumns = { 0 }; //要合併的欄位(合併Group1) foreach (int mergeColumn in mergeColumns) { int i = 1; foreach (GridViewRow wkItem in GridView1.Rows) { if (wkItem.RowIndex != 0) { if (wkItem.Cells[mergeColumn].Text.Trim() == GridView1.Rows[(wkItem.RowIndex - i)].Cells[mergeColumn].Text.Trim()) { GridView1.Rows[(wkItem.RowIndex - i)].Cells[mergeColumn].RowSpan += 1; wkItem.Cells[mergeColumn].Visible = false; i = i + 1; } else { GridView1.Rows[(wkItem.RowIndex)].Cells[mergeColumn].RowSpan += 1; i = 1; } } else { wkItem.Cells[mergeColumn].RowSpan = 1; } } } } protected void GridView2_PreRender(object sender, EventArgs e) { int[] mergeColumns = { 0, 1 }; //要合併的欄位(合併Group1與Group2) foreach (int mergeColumn in mergeColumns) { int i = 1; foreach (GridViewRow wkItem in GridView2.Rows) { if (wkItem.RowIndex != 0) { if (wkItem.Cells[mergeColumn].Text.Trim() == GridView2.Rows[(wkItem.RowIndex - i)].Cells[mergeColumn].Text.Trim()) { GridView2.Rows[(wkItem.RowIndex - i)].Cells[mergeColumn].RowSpan += 1; wkItem.Cells[mergeColumn].Visible = false; i = i + 1; } else { GridView2.Rows[(wkItem.RowIndex)].Cells[mergeColumn].RowSpan += 1; i = 1; } } else { wkItem.Cells[mergeColumn].RowSpan = 1; } } } } }

執行結果：

回首頁