asp.net旅行
实现效果:
Id |
Full Name |
Depart |
1 |
fname1 |
lname1 |
Sales |
2 |
fname2 |
lname2 |
3 |
fname3 |
lname3 |
4 |
fname4 |
lname4 |
5 |
fname5 |
lname5 |
6 |
fname6 |
lname6 |
IT |
7 |
fname7 |
lname7 |
8 |
fname8 |
lname8 |
9 |
fname9 |
lname9 |
10 |
fname10 |
lname10 |
代码:
using System;
using System.Data;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Collections.Generic;

public partial class _Default : System.Web.UI.Page


{
protected void Page_Load(object sender, EventArgs e)

{
if (!IsPostBack) bindPersons();
}


//绑定GridView
protected void bindPersons()

{
this.GridView1.DataSource = getSource();
this.GridView1.DataBind();
}

//创建数据源
protected DataTable getSource()

{

/**//**-----------------------------------------
* Id FisrtName LastName Depart
* -----------------------------------------
* 1 fname1 lname1 Sales
* 1 fname2 lname2 IT
* -----------------------------------------
* */
DataTable persons = new DataTable();
persons.Columns.Add("Id", typeof(System.Int32));
persons.Columns.Add("FirstName", typeof(System.String));
persons.Columns.Add("LastName", typeof(System.String));
persons.Columns.Add("Depart", typeof(System.String));

for (int i = 0; i < 10; i++)

{
DataRow row = persons.NewRow();
row["Id"] = i+1;
row["FirstName"] = "fname" + (i + 1);
row["LastName"] = "lname" + (i + 1);
if (i < 5)
row["Depart"] = "Sales";
else
row["Depart"] = "IT";
persons.Rows.Add(row);
}
return persons;
}
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)

{//合并header的firstName和lastName列
if (e.Row.RowType == DataControlRowType.Header)

{
//删除lastName列
e.Row.Cells.RemoveAt(2);
//合并列
e.Row.Cells[1].Attributes["colspan"] = "2";
//设置列标签
e.Row.Cells[1].Text = "<font color=\"red\">Full Name</font>";
}

}

protected void GridView1_PreRender(object sender, EventArgs e)

{//合并datarow
Dictionary<string,List<GridViewRow>> rowList = new Dictionary<string,List<GridViewRow>>();
foreach (GridViewRow row in GridView1.Rows)

{
string departName = row.Cells[3].Text;
if (!rowList.ContainsKey(departName))

{
rowList[departName] = new List<GridViewRow>();
}
rowList[departName].Add(row);
}

foreach (KeyValuePair<string, List<GridViewRow>> departList in rowList)

{
int i = 0;
foreach (GridViewRow row in departList.Value)

{

if (i == 0)

{
row.Cells[3].Attributes["rowspan"] = departList.Value.Count.ToString();
row.Cells[3].Attributes["valign"] = "center";
i++;
}
else

{
row.Cells.RemoveAt(3);
}
}
}

}
}

下载:
文件