GridView使用大全攻略

1.GridView代码分页排序： 效果图：

1.AllowSorting设为True，aspx代码中是AllowSorting=\；

2.默认1页10条，如果要修改每页条数，修改PageSize即可，在aspx代码中是PageSize=\。

3.默认的是单向排序的，右击GridView弹出“属性”，选择AllowSorting为True即可。

1：分页保存选中状态 保存CheckBox的值

GridView在分页过程中并不维护CheckBox的选择状态，幸运的是，我们可以使用Session来维护CheckBox的状态，这个功能使用RememberOldValues完成 private void RememberOldValues() {

ArrayList categoryIDList = new ArrayList(); int index = -1;

foreach (GridViewRow row in okZMGV.Rows) {

index =Convert .ToInt32( okZMGV.DataKeys[row.RowIndex].Value); bool result = ((CheckBox)row.FindControl(\)).Checked;

// Check in the Session if (Session[\] != null)

categoryIDList = (ArrayList)Session[\]; if (result) {

if (!categoryIDList.Contains(index)) categoryIDList.Add(index); } else

categoryIDList.Remove(index); }

if (categoryIDList != null && categoryIDList.Count > 0) Session[\] = categoryIDList;

}

还原CheckBox的状态

下一步，需要定义一个方法来还原Checkbox的状态值

private void RePopulateValues() {

ArrayList categoryIDList = (ArrayList)Session[\]; if (categoryIDList != null && categoryIDList.Count > 0) {

foreach (GridViewRow row in okZMGV .Rows) {

int index = (int)okZMGV.DataKeys[row.RowIndex].Value; if (categoryIDList.Contains(index)) {

CheckBox myCheckBox = (CheckBox)row.FindControl(\); myCheckBox.Checked = true; } } } }

最后，在分页事件里调用上面两个方法

protected void page_Click(object sender, ImageClickEventArgs e) {

RememberOldValues();

string count = ((ImageButton)sender).CommandArgument.ToString().ToLower (); switch(count) {

case \:

if (okZMGV.PageIndex > 0) {

okZMGV.PageIndex -= 1; } break; case \:

if (okZMGV.PageIndex < okZMGV.PageCount - 1) {

okZMGV.PageIndex += 1; } break; case \:

okZMGV.PageIndex=0; break; case \:

okZMGV.PageIndex= okZMGV.pagecount-1; break; }

BrndOKBind(); RePopulateValues(); }

2.GridView选中，编辑，取消，删除： 效果图：

后台代码：

你可以使用sqlhelper,本文没用。代码如下： using System; using System.Data;

using System.Configuration; 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; using System.Data.SqlClient;

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

//清清月儿http://blog.csdn.net/21aspnet SqlConnection sqlcon; SqlCommand sqlcom;

string strCon = \数据库名;Uid=帐号;Pwd=密码\ protected void Page_Load(object sender, EventArgs e) {

if (!IsPostBack) {

bind(); }

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) {

GridView1.EditIndex = e.NewEditIndex; bind(); } //删除

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) {

string sqlstr = \表 where id=''\GridView1.DataKeys[e.RowIndex].Value.ToString() + \ sqlcon = new SqlConnection(strCon); sqlcom = new SqlCommand(sqlstr,sqlcon); sqlcon.Open();

sqlcom.ExecuteNonQuery(); sqlcon.Close(); bind(); } //更新

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {

sqlcon = new SqlConnection(strCon); string sqlstr = \表 set 字段1=''\ +

((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + \字段2=''\ +

((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + \字段3=''\ +

((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + \

+ GridView1.DataKeys[e.RowIndex].Value.ToString() + \ sqlcom=new SqlCommand(sqlstr,sqlcon); sqlcon.Open();

sqlcom.ExecuteNonQuery(); sqlcon.Close();

GridView1.EditIndex = -1; bind(); } //取消

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) {

GridView1.EditIndex = -1; bind(); } //绑定

public void bind() {

string sqlstr = \表\ sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open(); myda.Fill(myds, \表\

GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { \主键 GridView1.DataBind(); sqlcon.Close(); } }

前台主要代码：

... ...

ForeColor=\OnRowDeleting=\OnRowEditing=\

OnRowUpdating=\OnRowCancelingEdit=\

ReadOnly=\

3.GridView正反双向排序：

效果图：点姓名各2次的排序，点其他也一样可以。

后台代码： 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; using System.Data.SqlClient;

public partial class Default3 : System.Web.UI.Page {

//清清月儿的博客http://blog.csdn.net/21aspnet SqlConnection sqlcon;

string strCon = \北风贸易;Uid=sa;Pwd=\ protected void Page_Load(object sender, EventArgs e) {

if (!IsPostBack) {

ViewState[\身份证号码\ ViewState[\ bind(); } }

protected void GridView1_Sorting(object sender, GridViewSortEventArgs e) {

string sPage = e.SortExpression;

if (ViewState[\ {

if (ViewState[\ ViewState[\ else

ViewState[\ } else {

ViewState[\ } bind(); }

public void bind() {

string sqlstr = \飞狐工作室\ sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open();

myda.Fill(myds, \飞狐工作室\

DataView view = myds.Tables[\飞狐工作室\ string sort = (string)ViewState[\

(string)ViewState[\ view.Sort = sort;

GridView1.DataSource = view; GridView1.DataBind(); sqlcon.Close(); } }

前台主要代码：

CellPadding=\

OnSorting=\BorderStyle=\

4.GridView和下拉菜单DropDownList结合： 效果图：

后台代码： 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; using System.Data.SqlClient;

public partial class Default4 : System.Web.UI.Page {

SqlConnection sqlcon;

string strCon = \北风贸易;Uid=sa;Pwd=sa\ protected void Page_Load(object sender, EventArgs e) {

DropDownList ddl; if (!IsPostBack) {

string sqlstr = \飞狐工作室\ sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open();

myda.Fill(myds, \飞狐工作室\ GridView1.DataSource = myds; GridView1.DataBind();

for (int i = 0; i <= GridView1.Rows.Count - 1; i++) {

DataRowView mydrv = myds.Tables[\飞狐工作室\ if (Convert.ToString(mydrv[\员工性别\ { ddl =

(DropDownList)GridView1.Rows[i].FindControl(\ ddl.SelectedIndex = 0; }

if (Convert.ToString(mydrv[\员工性别\ {

ddl =

(DropDownList)GridView1.Rows[i].FindControl(\ ddl.SelectedIndex = 1; } }

sqlcon.Close(); } }

public SqlDataReader ddlbind() {

string sqlstr = \员工性别 from 飞狐工作室\ sqlcon = new SqlConnection(strCon);

SqlCommand sqlcom = new SqlCommand(sqlstr, sqlcon); sqlcon.Open();

return sqlcom.ExecuteReader(); }

前台主要代码：

CellPadding=\BackColor=\BorderColor=\

'' DataValueField=\员工性别\员工性别\

5.GridView和CheckBox结合： 效果图：

后台代码： using System; using System.Data;

using System.Configuration; 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; using System.Data.SqlClient;

public partial class Default5 : System.Web.UI.Page {

//清清月儿http://blog.csdn.net/21aspnet SqlConnection sqlcon;

string strCon = \北风贸易;Uid=sa;Pwd=sa\ protected void Page_Load(object sender, EventArgs e) {

if (!IsPostBack) {

bind(); } }

protected void CheckBox2_CheckedChanged(object sender, EventArgs e) {

for (int i = 0; i <= GridView1.Rows.Count - 1; i++)

{

CheckBox cbox =

(CheckBox)GridView1.Rows[i].FindControl(\ if (CheckBox2.Checked == true) {

cbox.Checked = true; } else {

cbox.Checked = false; } } }

protected void Button2_Click(object sender, EventArgs e) {

sqlcon = new SqlConnection(strCon); SqlCommand sqlcom;

for (int i = 0; i <= GridView1.Rows.Count - 1; i++) {

CheckBox cbox =

(CheckBox)GridView1.Rows[i].FindControl(\ if (cbox.Checked == true) {

string sqlstr = \飞狐工作室 where 身份证号码=''\GridView1.DataKeys[i].Value + \

sqlcom = new SqlCommand(sqlstr, sqlcon); sqlcon.Open();

sqlcom.ExecuteNonQuery(); sqlcon.Close(); } } bind(); }

protected void Button1_Click(object sender, EventArgs e) {

CheckBox2.Checked = false;

for (int i = 0; i <= GridView1.Rows.Count - 1; i++) {

CheckBox cbox =

(CheckBox)GridView1.Rows[i].FindControl(\ cbox.Checked = false; } }

public void bind() {

string sqlstr = \飞狐工作室\ sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open();

myda.Fill(myds, \ GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { \身份证号码\ GridView1.DataBind(); sqlcon.Close(); } }

前台主要代码：

CellPadding=\BackColor=\BorderColor=\

OnCheckedChanged=\ Text=\全选\

6.鼠标移到GridView某一行时改变该行的背景色方法一： 效果图：

做法：

双击GridView的OnRowDataBound事件；

在后台的GridView1_RowDataBound()方法添加代码，最后代码如下所示：

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { int i;

//执行循环，保证每条数据都可以更新

for (i = 0; i < GridView1.Rows.Count; i++) {

//首先判断是否是数据行

if (e.Row.RowType == DataControlRowType.DataRow) {

//当鼠标停留时更改背景色

e.Row.Attributes.Add(\

\ //当鼠标移开时还原背景色

e.Row.Attributes.Add(\ } }

} 前台代码：

7.鼠标移到GridView某一行时改变该行的背景色方法二： 效果图：

做法：和上面的一样就是代码不同

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) {

//int i;

////执行循环，保证每条数据都可以更新

//for (i = 0; i < GridView1.Rows.Count; i++) //{

// //首先判断是否是数据行

// if (e.Row.RowType == DataControlRowType.DataRow) // {

// //当鼠标停留时更改背景色

// e.Row.Attributes.Add(\

\ // //当鼠标移开时还原背景色

// e.Row.Attributes.Add(\\ // } //}

//如果是绑定数据行

if (e.Row.RowType == DataControlRowType.DataRow) {

//鼠标经过时，行背景色变

e.Row.Attributes.Add(\\ //鼠标移出时，行背景色变

e.Row.Attributes.Add(\\ }

}

8.GridView实现删除时弹出确认对话框： 效果图：

实现方法：

双击GridView的OnRowDataBound事件；

在后台的GridView1_RowDataBound()方法添加代码，最后代码如下所示：

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) {

//如果是绑定数据行

if (e.Row.RowType == DataControlRowType.DataRow) {

if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate) {

((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add(\\你确认要删除：\\\吗?'')\ } } }

9.GridView实现自动编号： 效果图：

实现方法：

双击GridView的OnRowDataBound事件；

在后台的GridView1_RowDataBound()方法添加代码，最后代码如下所示： protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) {

//如果是绑定数据行 //清清月儿http://blog.csdn.net/21aspnet if (e.Row.RowType == DataControlRowType.DataRow) {

////鼠标经过时，行背景色变

//e.Row.Attributes.Add(\\ ////鼠标移出时，行背景色变

//e.Row.Attributes.Add(\\

////当有编辑列时，避免出错，要加的RowState判断

//if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate) //{

// ((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add(\\你确认要删除：\\\吗?'')\ //} }

if (e.Row.RowIndex != -1) {

int id = e.Row.RowIndex + 1; e.Row.Cells[0].Text = id.ToString(); } }

注意这时最好把前台的第一列的表头该为“编号”，因为以前的第一列被“吃掉”了。

OnRowUpdating=\

OnRowCancelingEdit=\BorderColor=\Font-Size=\

ShowSelectButton=\

10.GridView实现自定义时间货币等字符串格式： 效果图： 图1-未格式化前

图2-格式化后

解决方法：

在asp.net 2.0中，如果要在绑定列中显示比如日期格式等，如果用下面的方法是显示不了的

主要是由于htmlencode属性默认设置为true,已防止XSS攻击，安全起见而用的，所以，可以有以下两种方法解决 1、

HeaderText=\

将htmlencode设置为false即可 另外的解决方法为，使用模版列

Text=''<%# Eval(\

Text=’<%# Bind(\

前台代码：

DataSourceID=\BackColor=\BorderWidth=\OnRowDataBound=\

ConnectionString=\北风贸易ConnectionString1 %>\ SelectCommand=\出生日期], [起薪], [身份证号码], [姓名], [家庭住址], [邮政编码] FROM [飞狐工作室]\

DataSourceMode=\ 附录-常用格式化公式： {0:C} 货币；

{0:D4}由0填充的4个字符宽的字段中显示整数； {0:000.0}四舍五入小数点保留第几位有效数字；

{0:N2}小数点保留2位有效数字；{0:N2}% 小数点保留2位有效数字加百分号； {0:D}长日期；{0:d}短日期；{0:yy-MM-dd} 例如07-3-25；；{0:yyyy-MM-dd} 例如2007-3-25

11.GridView实现用“...”代替超长字符串： 效果图：

解决方法：数据绑定后过滤每一行即可

for (int i = 0; i <= GridView1.Rows.Count - 1; i++) {

DataRowView mydrv; string gIntro;

if (GridView1.PageIndex == 0) {

mydrv = myds.Tables[\飞狐工作室\表名 gIntro = Convert.ToString(mydrv[\家庭住址\所要处理的字段 GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2); } else {

mydrv = myds.Tables[\飞狐工作室\GridView1.PageIndex)];

gIntro = Convert.ToString(mydrv[\家庭住址\ GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2); } } 调用的方法：

public string SubStr(string sString, int nLeng) {

if (sString.Length <= nLeng) {

return sString; }

string sNewStr = sString.Substring(0, nLeng); sNewStr = sNewStr + \ return sNewStr; }

后台全部代码： using System; using System.Data;

using System.Configuration; 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; using System.Data.SqlClient;

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

SqlConnection sqlcon; SqlCommand sqlcom;

string strCon = \北风贸易;Uid=sa;Pwd=sa\ protected void Page_Load(object sender, EventArgs e) {

if (!IsPostBack) {

ViewState[\身份证号码\ ViewState[\

bind(); } }

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) {

GridView1.EditIndex = e.NewEditIndex; bind(); }

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) {

string sqlstr = \飞狐工作室 where 身份证号码=''\GridView1.DataKeys[e.RowIndex].Value.ToString() + \ sqlcon = new SqlConnection(strCon); sqlcom = new SqlCommand(sqlstr,sqlcon); sqlcon.Open();

sqlcom.ExecuteNonQuery(); sqlcon.Close(); bind(); }

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {

sqlcon = new SqlConnection(strCon);

string sqlstr = \飞狐工作室 set 姓名=''\ +

((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + \家庭住址=''\ +

((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + \身份证号码=''\

+ GridView1.DataKeys[e.RowIndex].Value.ToString() + \ sqlcom=new SqlCommand(sqlstr,sqlcon); sqlcon.Open();

sqlcom.ExecuteNonQuery(); sqlcon.Close();

GridView1.EditIndex = -1; bind(); }

protected void GridView1_RowCancelingEdit(object sender,

GridViewCancelEditEventArgs e) {

GridView1.EditIndex = -1; bind(); }

public void bind() {

string sqlstr = \飞狐工作室\ sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open();

myda.Fill(myds, \飞狐工作室\ GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { \身份证号码\ GridView1.DataBind();

for (int i = 0; i <= GridView1.Rows.Count - 1; i++) {

DataRowView mydrv; string gIntro;

if (GridView1.PageIndex == 0) {

mydrv = myds.Tables[\飞狐工作室\ gIntro = Convert.ToString(mydrv[\家庭住址\ GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2); } else {

mydrv = myds.Tables[\飞狐工作室\GridView1.PageIndex)];

gIntro = Convert.ToString(mydrv[\家庭住址\ GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2); } }

sqlcon.Close(); }

public string SubStr(string sString, int nLeng) {

if (sString.Length <= nLeng)

{

return sString; }

string sNewStr = sString.Substring(0, nLeng); sNewStr = sNewStr + \ return sNewStr; }

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) {

//如果是绑定数据行

if (e.Row.RowType == DataControlRowType.DataRow) {

////鼠标经过时，行背景色变

//e.Row.Attributes.Add(\\ ////鼠标移出时，行背景色变

//e.Row.Attributes.Add(\\

////当有编辑列时，避免出错，要加的RowState判断

//if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate) //{

// ((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add(\\你确认要删除：\\\吗?'')\ //} }

if (e.Row.RowIndex != -1) {

int id = e.Row.RowIndex + 1; e.Row.Cells[0].Text = id.ToString(); } } }

11.GridView一般换行与强制换行： 效果图：

首先设置

gridview里有一列绑定的数据很长，显示的时候在一行里面显示，页面拉得很宽。 原因是连续英文段为一个整体导致的，在RowDataBound中添加上了一句e.Row.Cells[2].Style.Add(\就可以。 如果要给所有的列增加此属性：

protected void Page_Load(object sender, EventArgs e) {

//正常换行

GridView1.Attributes.Add(\ //下面这行是自动换行

GridView1.Attributes.Add(\

\ if (!IsPostBack) {

bind();//调用数据绑定即可 } }

总之：善用CSS的word-break:break-all;word-wrap:break-word属性即可，这个属性是通用的对于顽固的南换行问题都可以解决，不局限于GridView。 12.GridView显示隐藏某一列：

本方案为月儿独创，不同于网上其他方式，我觉得用一个CheckBox更人性化，这样可以隐藏不必要的列，让用户自己选择需要出现的列，在处理多列时这是一个很好的解决方案！ 效果图： 图1-开始

图2-点击显示的CheckBox后

解决方案： public void bind() {

string sqlstr = \飞狐工作室\ sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open();

myda.Fill(myds, \飞狐工作室\

GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { \身份证号码\ GridView1.DataBind(); sqlcon.Close();

GridView1.Columns[3].Visible = false;//一开始隐藏

CheckBox1.Checked = false;//如果不这样后面的代码会把他True }

双击CheckBox1，在CheckedChanged方法里写上代码，最后代码如下： protected void CheckBox1_CheckedChanged(object sender, EventArgs e) {

GridView1.Columns[3].Visible=! GridView1.Columns[3].Visible; Response.Write(\的第4列现在的显示隐藏状态是：\ }

注意：CheckBox1的AutoPostBack要True！ 后台全部代码如下： using System; using System.Data;

using System.Configuration; 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; using System.Data.SqlClient;

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

SqlConnection sqlcon; SqlCommand sqlcom;

string strCon = \北风贸易;Uid=sa;Pwd=sa\ protected void Page_Load(object sender, EventArgs e) {

if (!IsPostBack) {

ViewState[\身份证号码\ ViewState[\

bind(); } }

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) {

GridView1.EditIndex = e.NewEditIndex; bind(); }

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) {

string sqlstr = \飞狐工作室 where 身份证号码=''\GridView1.DataKeys[e.RowIndex].Value.ToString() + \ sqlcon = new SqlConnection(strCon); sqlcom = new SqlCommand(sqlstr,sqlcon); sqlcon.Open();

sqlcom.ExecuteNonQuery(); sqlcon.Close(); bind(); }

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {

sqlcon = new SqlConnection(strCon);

string sqlstr = \飞狐工作室 set 姓名=''\ +

((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + \家庭住址=''\ +

((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + \身份证号码=''\

+ GridView1.DataKeys[e.RowIndex].Value.ToString() + \ sqlcom=new SqlCommand(sqlstr,sqlcon); sqlcon.Open();

sqlcom.ExecuteNonQuery(); sqlcon.Close();

GridView1.EditIndex = -1; bind(); }

protected void GridView1_RowCancelingEdit(object sender,

GridViewCancelEditEventArgs e) {

GridView1.EditIndex = -1; bind(); }

public void bind() {

string sqlstr = \飞狐工作室\ sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open();

myda.Fill(myds, \飞狐工作室\ GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { \身份证号码\ GridView1.DataBind(); sqlcon.Close();

GridView1.Columns[3].Visible = false; CheckBox1.Checked = false; }

protected void CheckBox1_CheckedChanged(object sender, EventArgs e) {

GridView1.Columns[3].Visible=! GridView1.Columns[3].Visible; Response.Write(\的第4列现在的显示隐藏状态是：\ } }

前台代码：

13.GridView弹出新页面/弹出制定大小位置新窗口：

效果图：

方案一：简单的方法，新窗口不固定大小

OnRowUpdating=\

OnRowCancelingEdit=\BorderColor=\Font-Size=\>

DataNavigateUrlFormatString=\

Target=\姓名\

DataNavigateUrlFields是链接的字段名，DataNavigateUrlFormatString是路径。 方案二：精确控制弹出窗口大小位置

DataNavigateUrlFormatString=\{0}'',null,''width=300,height=200'');window.Close();\ DataTextField=\

HeaderText=\

使用的是结合javascript的window.open方法，关于window.open的参数网上有很多帖子，本站也有许多参考

弹出窗口大全 http://blog.csdn.net/21aspnet/archive/2004/10/25/150231.aspx 即可！

14.GridView固定表头(不用javascript只用CSS!，很好用)： 效果图：

代码：

用法：CSS设如上的样式，HeaderStyle加CssClass=\，套住GridView的Div设置高度宽度

效果图：

后台代码： using System; using System.Data;

using System.Configuration; 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; using System.Data.SqlClient; using System.Drawing;

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

SqlConnection sqlcon; SqlCommand sqlcom;

string strCon = \北风贸易;Uid=sa;Pwd=sa\ protected void Page_Load(object sender, EventArgs e) {

if (!IsPostBack) {

bind(); } }

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) {

GridView1.EditIndex = e.NewEditIndex; bind(); }

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {

sqlcon = new SqlConnection(strCon);

string sqlstr = \飞狐工作室 set 姓名=''\ +

((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + \家庭住址=''\ +

((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + \身份证号码=''\

+ GridView1.DataKeys[e.RowIndex].Value.ToString() + \ sqlcom=new SqlCommand(sqlstr,sqlcon); sqlcon.Open();

sqlcom.ExecuteNonQuery(); sqlcon.Close();

GridView1.EditIndex = -1; bind(); }

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) {

GridView1.EditIndex = -1; bind(); }

public void bind() {

string sqlstr = \飞狐工作室\ sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open();

myda.Fill(myds, \飞狐工作室\ GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { \身份证号码\ GridView1.DataBind(); sqlcon.Close(); }

//这里就是解决方案

protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e) {

switch (e.Row.RowType) {

case DataControlRowType.Header: //第一行表头

TableCellCollection tcHeader = e.Row.Cells; tcHeader.Clear();

tcHeader.Add(new TableHeaderCell());

tcHeader[0].Attributes.Add(\跨Row tcHeader[0].Attributes.Add(\ tcHeader[0].Text = \

tcHeader.Add(new TableHeaderCell());

//tcHeader[1].Attributes.Add(\

tcHeader[1].Attributes.Add(\跨Column tcHeader[1].Text = \全部信息\ //第二行表头

tcHeader.Add(new TableHeaderCell());

tcHeader[2].Attributes.Add(\ tcHeader[2].Text = \身份证号码\ tcHeader.Add(new TableHeaderCell());

tcHeader[3].Attributes.Add(\ tcHeader[3].Attributes.Add(\ tcHeader[3].Text = \基本信息\

tcHeader.Add(new TableHeaderCell());

tcHeader[4].Attributes.Add(\ tcHeader[4].Text = \福利\

tcHeader.Add(new TableHeaderCell());

tcHeader[5].Attributes.Add(\ tcHeader[5].Attributes.Add(\ tcHeader[5].Text = \联系方式\ //第三行表头

tcHeader.Add(new TableHeaderCell());

tcHeader[6].Attributes.Add(\ tcHeader[6].Text = \身份证号码\ tcHeader.Add(new TableHeaderCell());

tcHeader[7].Attributes.Add(\ tcHeader[7].Text = \姓名\

tcHeader.Add(new TableHeaderCell());

tcHeader[8].Attributes.Add(\ tcHeader[8].Text = \出生日期\

tcHeader.Add(new TableHeaderCell());

tcHeader[9].Attributes.Add(\ tcHeader[9].Text = \薪水\

tcHeader.Add(new TableHeaderCell());

tcHeader[10].Attributes.Add(\ tcHeader[10].Text = \家庭住址\ tcHeader.Add(new TableHeaderCell());

tcHeader[11].Attributes.Add(\ tcHeader[11].Text = \邮政编码\ break; } } } 前台：

16.GridView突出显示某一单元格（例如金额低于多少，分数不及格等） 效果图：

解决方案：主要是绑定后过滤 GridView1.DataBind();

for (int i = 0; i <= GridView1.Rows.Count - 1; i++) {

DataRowView mydrv = myds.Tables[\飞狐工作室\ string score = Convert.ToString(mydrv[\起薪\

if (Convert.ToDouble(score) < 34297.00)//大家这里根据具体情况设置可能ToInt32等等 {

GridView1.Rows[i].Cells[4].BackColor = System.Drawing.Color.Red; } }

sqlcon.Close(); 全部后台代码： using System; using System.Data;

using System.Configuration; 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; using System.Data.SqlClient; using System.Drawing;

public partial class Default7 : System.Web.UI.Page {

SqlConnection sqlcon; SqlCommand sqlcom;

string strCon = \北风贸易;Uid=sa;Pwd=sa\ protected void Page_Load(object sender, EventArgs e) {

if (!IsPostBack) {

bind(); } }

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) {

GridView1.EditIndex = e.NewEditIndex; bind(); }

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {

sqlcon = new SqlConnection(strCon);

string sqlstr = \飞狐工作室 set 姓名=''\ +

((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + \家庭住址=''\ +

((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + \身份证号码=''\

+ GridView1.DataKeys[e.RowIndex].Value.ToString() + \ sqlcom = new SqlCommand(sqlstr, sqlcon);

sqlcon.Open();

sqlcom.ExecuteNonQuery(); sqlcon.Close();

GridView1.EditIndex = -1; bind(); }

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) {

GridView1.EditIndex = -1; bind(); }

public void bind() {

string sqlstr = \飞狐工作室\ sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open();

myda.Fill(myds, \飞狐工作室\ GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { \身份证号码\ GridView1.DataBind();

for (int i = 0; i <= GridView1.Rows.Count - 1; i++) {

DataRowView mydrv = myds.Tables[\飞狐工作室\ string score = Convert.ToString(mydrv[\起薪\

if (Convert.ToDouble(score) < 34297.00)//大家这里根据具体情况设置可能ToInt32等等

{

GridView1.Rows[i].Cells[4].BackColor = System.Drawing.Color.Red; } }

sqlcon.Close(); } }

前台代码：

17.GridView加入自动求和求平均值小计 效果图： 解决方案：

private double sum = 0;//取指定列的数据和，你要根据具体情况对待可能你要处理的是int protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) {

if (e.Row.RowIndex >= 0) {

sum += Convert.ToDouble(e.Row.Cells[6].Text); }

else if (e.Row.RowType == DataControlRowType.Footer) {

e.Row.Cells[5].Text = \总薪水为：\ e.Row.Cells[6].Text = sum.ToString(); e.Row.Cells[3].Text = \平均薪水为：\

e.Row.Cells[4].Text = ((int)(sum / GridView1.Rows.Count)).ToString(); } }

后台全部代码： using System; using System.Data;

using System.Configuration; 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;

using System.Data.SqlClient; using System.Drawing;

public partial class Default7 : System.Web.UI.Page {

SqlConnection sqlcon; SqlCommand sqlcom;

string strCon = \北风贸易;Uid=sa;Pwd=sa\ protected void Page_Load(object sender, EventArgs e) {

if (!IsPostBack) {

bind(); } }

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) {

GridView1.EditIndex = e.NewEditIndex; bind(); }

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {

sqlcon = new SqlConnection(strCon);

string sqlstr = \飞狐工作室 set 姓名=''\ +

((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + \家庭住址=''\ +

((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + \身份证号码=''\

+ GridView1.DataKeys[e.RowIndex].Value.ToString() + \ sqlcom = new SqlCommand(sqlstr, sqlcon); sqlcon.Open();

sqlcom.ExecuteNonQuery(); sqlcon.Close();

GridView1.EditIndex = -1; bind(); }

protected void GridView1_RowCancelingEdit(object sender,

GridViewCancelEditEventArgs e) {

GridView1.EditIndex = -1; bind(); }

public void bind() {

string sqlstr = \飞狐工作室\ sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open();

myda.Fill(myds, \飞狐工作室\ GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { \身份证号码\ GridView1.DataBind(); sqlcon.Close(); }

private double sum = 0;//取指定列的数据和

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) {

if (e.Row.RowIndex >= 0) {

sum += Convert.ToDouble(e.Row.Cells[6].Text); }

else if (e.Row.RowType == DataControlRowType.Footer) {

e.Row.Cells[5].Text = \总薪水为：\ e.Row.Cells[6].Text = sum.ToString(); e.Row.Cells[3].Text = \平均薪水为：\

e.Row.Cells[4].Text = ((int)(sum / GridView1.Rows.Count)).ToString(); } } }

前台：唯一的花头就是设置ShowFooter=\ ，否则默认表头为隐藏的！

OnRowUpdating=\

OnRowCancelingEdit=\BorderColor=\Font-Size=\ShowFooter=\>

18.GridView数据导入Excel/Excel数据读入GridView 效果图：

解决方案：

页面增加一个按钮，单击事件添加如下方法：

protected void Button1_Click(object sender, EventArgs e) {

Export(\学生成绩报表.xls\ }

private void Export(string FileType, string FileName) {

Response.Charset = \

Response.ContentEncoding = System.Text.Encoding.UTF7;

Response.AppendHeader(\HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString()); Response.ContentType = FileType; this.EnableViewState = false;

StringWriter tw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(tw); GridView1.RenderControl(hw); Response.Write(tw.ToString()); Response.End(); }

//如果没有下面方法会报错类型“GridView”的控件“GridView1”必须放在具有 runat=server 的窗体标记内

public override void VerifyRenderingInServerForm(Control control) { }

还有由于是文件操作所以要引入名称空间IO和Text 后台代码： using System; using System.Data;

using System.Configuration; 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; using System.Data.SqlClient; using System.Drawing; using System.IO; using System.Text;

public partial class Default7 : System.Web.UI.Page {

SqlConnection sqlcon;

SqlCommand sqlcom;

string strCon = \北风贸易;Uid=sa;Pwd=sa\ protected void Page_Load(object sender, EventArgs e) {

if (!IsPostBack) {

bind(); } }

public void bind() {

string sqlstr = \飞狐工作室\ sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open();

myda.Fill(myds, \飞狐工作室\ GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { \身份证号码\ GridView1.DataBind(); sqlcon.Close(); }

protected void Button1_Click(object sender, EventArgs e) {

Export(\学生成绩报表.xls\ }

private void Export(string FileType, string FileName) {

Response.Charset = \

Response.ContentEncoding = System.Text.Encoding.UTF7;

Response.AppendHeader(\HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString()); Response.ContentType = FileType; this.EnableViewState = false;

StringWriter tw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(tw); GridView1.RenderControl(hw);

Response.Write(tw.ToString()); Response.End(); }

public override void VerifyRenderingInServerForm(Control control) { } } 前台：

BackColor=\BorderStyle=\>

读取Excel数据的代码：这个很简单的 private DataSet CreateDataSource()

{

string strCon;

strCon = \Server.MapPath(\ OleDbConnection olecon = new OleDbConnection(strCon);

OleDbDataAdapter myda = new OleDbDataAdapter(\[Sheet1$]\

DataSet myds = new DataSet(); myda.Fill(myds); return myds; }

protected void Button1_Click(object sender, EventArgs e) {

GridView1.DataSource = CreateDataSource(); GridView1.DataBind(); }

如果GridView存在模板列，其中包含子控件，例如CheckBox等，导出EXCEL后就会出现该区域的不规律。所以要对模板列单独处理（转载）

public static void PrepareGridViewForExport(Control gv)//模式化特殊元素 flashcong

{

LinkButton lb = new LinkButton(); Literal l = new Literal(); string name = String.Empty;

for (int i = 0; i < gv.Controls.Count; i++) {

if (gv.Controls[i].GetType() == typeof(LinkButton)) {

l.Text = (gv.Controls[i] as LinkButton).Text; gv.Controls.Remove(gv.Controls[i]);

gv.Controls.AddAt(i, l);

}

else if (gv.Controls[i].GetType() == typeof(DropDownList)) {

l.Text = (gv.Controls[i] as DropDownList).SelectedItem.Text; gv.Controls.Remove(gv.Controls[i]); gv.Controls.AddAt(i, l);

}

{

l.Text = (gv.Controls[i] e\

gv.Controls.Remove(gv.Controls[i]); gv.Controls.AddAt(i, l);

}

{

l.Text = \ gv.Controls.Remove(gv.Controls[i]); gv.Controls.AddAt(i, l); }

{

PrepareGridViewForExport(gv.Controls[i]); }

}

}

else if (gv.Controls[i].GetType() == typeof(CheckBox)) as CheckBox).Checked ? \else if (gv.Controls[i].GetType() == typeof(ImageButton)) 图片\

if (gv.Controls[i].HasControls())

本文来源：https://www.bwwdw.com/article/rijo.html