服务器之家：专注于服务器技术及软件下载分享
分类导航

PHP教程|ASP.NET教程|JAVA教程|ASP教程|

服务器之家 - 编程语言 - ASP.NET教程 - GridView常用操作事件图文介绍

GridView常用操作事件图文介绍

2019-10-11 10:53asp.net教程网 ASP.NET教程

对于gridview学NET的同学再熟悉不过，但是其中功能事件是否能编码熟练实现

对于gridview学NET的同学再熟悉不过，但是其中功能事件是否能编码熟练实现？前不久看点博文，以及资料，综合自己的一些想法，汇总如下：

数据库设计如下，以便更好理解：

 

设计：

GridView常用操作事件图文介绍

实现：

GridView常用操作事件图文介绍

GridView无代码分页排序

小实例：

AllowSorting设为True，aspx代码中是AllowSorting="True"；

运行结果：

GridView常用操作事件图文介绍


GridView选中，编辑，取消，删除

小实例：

GridView.aspx

 

复制代码代码如下:

<asp:GridView ID="GridView1" runat="server" Height="138px" Width="1117px" 
AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" 
onpageindexchanging="GridView1_PageIndexChanging" 
onrowcancelingedit="GridView1_RowCancelingEdit" 
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" 
onrowupdating="GridView1_RowUpdating"> 
<Columns> 

<asp:TemplateField HeaderText="身份证号" SortExpression="pid"> 
<ItemTemplate> 
<asp:Label ID="Label1" runat="server" Text='<%# Bind("pid") %>'></asp:Label> 
</ItemTemplate> 
</asp:TemplateField> 
<%-- <asp:BoundField DataField="pid" HeaderText="身份证号" SortExpression="pid" />--%> 
<asp:BoundField DataField="pname" HeaderText="姓名" SortExpression="pname" /> 
<asp:BoundField DataField="psex" HeaderText="性别" SortExpression="psex" /> 
<asp:BoundField DataField="padress" HeaderText="地址" SortExpression="padress" /> 
<asp:BoundField DataField="pyoubiao" HeaderText="邮编" SortExpression="pyoubiao" /> 
<asp:BoundField DataField="pprice" HeaderText="工资起价" SortExpression="pprice" /> 
<asp:CommandField HeaderText="选择" ShowSelectButton="True" /> 
<asp:CommandField HeaderText="编辑" ShowEditButton="True" /> 
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" /> 
</Columns> 
<EmptyDataRowStyle BackColor="Red" /> 
<HeaderStyle BackColor="#0000CC" Font-Bold="True" ForeColor="White" /> 
<PagerStyle BackColor="#864" HorizontalAlign="Center" ForeColor="White"/> 
</asp:GridView> 



GridView.aspx.cs

复制代码代码如下:

//公有数据 
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString); 
SqlCommand cmd; 
protected void Page_Load(object sender, EventArgs e) 
{ 
if (!IsPostBack) 
{ 
bind(); //正常绑定 
} 
} 


/// <summary> 
/// 主题：绑定数据，查询显示个人信息 
/// 时间：2012年11月21日14:54:13 
/// 描述：通过简单的方法绑定，实现数据显示 
/// 作者：小伙 
/// </summary> 
public void bind() 
{ 
//数据连接web.config中已配置的数据 
SqlDataAdapter da = new SqlDataAdapter("select top 5 * from person", con);//使用数据适配器内置查询，自动开闭数据库 
DataSet ds = new DataSet();//使用数据集，采取断开式访问数据 
da.Fill(ds, "person"); 
GridView1.DataSource = ds; 
GridView1.DataKeyNames=new string[]{"pid"};//设置主键 
GridView1.DataBind(); 
} 

//实现分页 
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) 
{ 
GridView1.PageIndex = e.NewPageIndex; 
this.bind(); 
} 
//删除 
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) 
{ 
string sqlstr = "delete from person where pid='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; 
con.Open(); 
cmd = new SqlCommand(sqlstr, con); 
cmd.ExecuteNonQuery(); 
con.Close(); 
bind(); 


} 
//取消编辑 
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) 
{ 
GridView1.EditIndex = -1; 
bind(); 
} 
//编辑 
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) 
{ 
GridView1.EditIndex = e.NewEditIndex; 
bind(); 
} 

//更新 
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) 
{ 
string sqlstr = "update person set pname='" 
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',psex='" 
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim()+"',padress='" 
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim()+"',pyoubiao='" 
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim()+"',pprice='" 
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim()+"' where pid='" 
+GridView1.DataKeys[e.RowIndex].Value.ToString()+"'"; 
cmd = new SqlCommand(sqlstr, con); 
con.Open(); 
cmd.ExecuteNonQuery(); 
con.Close(); 
GridView1.EditIndex = -1; 
bind(); 

} 

 

运行结果：

运行初始页：

GridView常用操作事件图文介绍

点击编辑：

GridView常用操作事件图文介绍

更新后：

GridView常用操作事件图文介绍


GridView正反双向排序

小实例：

GridView.aspx

复制代码代码如下:

<asp:GridView ID="GridView1" runat="server" Height="138px" Width="1117px" 
AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" 
onpageindexchanging="GridView1_PageIndexChanging" 
onrowcancelingedit="GridView1_RowCancelingEdit" 
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" 
onrowupdating="GridView1_RowUpdating" onsorting="GridView1_Sorting"> 
<Columns> 

<%--<asp:TemplateField HeaderText="身份证号" SortExpression="pid"> 
<ItemTemplate> 
<asp:Label ID="Label1" runat="server" Text='<%# Bind("pid") %>'></asp:Label> 
</ItemTemplate> 
</asp:TemplateField>--%> 
<asp:BoundField DataField="pid" HeaderText="身份证号" SortExpression="pid" /> 
<asp:BoundField DataField="pname" HeaderText="姓名" SortExpression="pname" /> 
<asp:BoundField DataField="psex" HeaderText="性别" SortExpression="psex" /> 
<asp:BoundField DataField="padress" HeaderText="地址" SortExpression="padress" /> 
<asp:BoundField DataField="pyoubiao" HeaderText="邮编" SortExpression="pyoubiao" /> 
<asp:BoundField DataField="pprice" HeaderText="工资起价" SortExpression="pprice" /> 
<asp:CommandField HeaderText="选择" ShowSelectButton="True" /> 
<asp:CommandField HeaderText="编辑" ShowEditButton="True" /> 
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" /> 
</Columns> 
<EmptyDataRowStyle BackColor="Red" /> 
<HeaderStyle BackColor="#0000CC" Font-Bold="True" ForeColor="White" /> 
<PagerStyle BackColor="#864" HorizontalAlign="Center" ForeColor="White"/> 
</asp:GridView> 


GridView.aspx.cs

复制代码代码如下:

//公有数据 
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString); 
SqlCommand cmd; 
protected void Page_Load(object sender, EventArgs e) 
{ 
if (!IsPostBack) 
{ 
ViewState["SortOrder"] = "pname"; 
ViewState["OrderDire"] = "ASC"; 
Sortbind1();//排序绑定 
} 
} 


//排序绑定 
public void Sortbind1() 
{ 
string sqlstr = "select top 5 * from person"; 
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, con); 
DataSet ds = new DataSet(); 
con.Open(); 
myda.Fill(ds, "person"); 
DataView view = ds.Tables["person"].DefaultView; 
string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"]; 
view.Sort = sort; 
GridView1.DataSource = view; 
GridView1.DataBind(); 
con.Close(); 
} 

//排序 
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e) 
{ 
string sPage = e.SortExpression; 
if (ViewState["SortOrder"].ToString() == sPage) 
{ 
if (ViewState["OrderDire"].ToString() == "Desc") 
{ 
ViewState["OrderDire"] = "ASC"; 
} 
else 
{ 
ViewState["OrderDire"] = "Desc"; 
} 
} 
else 
{ 
ViewState["SortOrder"] = e.SortExpression; 
} 
Sortbind1(); 

} 

 

运行结果：

排序前：

GridView常用操作事件图文介绍

排序后：

GridView常用操作事件图文介绍

 

 



GridView和下拉菜单DropDownList结合

小实例：

GridView.aspx

 

复制代码代码如下:

<asp:GridView ID="GridView1" runat="server" Height="138px" Width="1117px" 
AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" 
onpageindexchanging="GridView1_PageIndexChanging" 
onrowcancelingedit="GridView1_RowCancelingEdit" 
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" 
onrowupdating="GridView1_RowUpdating" onsorting="GridView1_Sorting"> 
<Columns> 

<%--<asp:TemplateField HeaderText="身份证号" SortExpression="pid"> 
<ItemTemplate> 
<asp:Label ID="Label1" runat="server" Text='<%# Bind("pid") %>'></asp:Label> 
</ItemTemplate> 
</asp:TemplateField>--%> 
<asp:BoundField DataField="pid" HeaderText="身份证号" SortExpression="pid" /> 
<asp:BoundField DataField="pname" HeaderText="姓名" SortExpression="pname" /> 
<asp:TemplateField HeaderText="性别" SortExpression="psex" > 
<ItemTemplate> 
<asp:DropDownList ID="DropDownList1" runat="server" DataSource='<%# ddlbind()%>' DataValueField="psex" DataTextField="psex"/> 
</ItemTemplate> 
</asp:TemplateField> 
<asp:BoundField DataField="padress" HeaderText="地址" SortExpression="padress" /> 
<asp:BoundField DataField="pyoubiao" HeaderText="邮编" 
SortExpression="pyoubiao" /> 
<asp:BoundField DataField="pprice" HeaderText="工资起价" SortExpression="pprice" /> 
<asp:CommandField HeaderText="选择" ShowSelectButton="True" /> 
<asp:CommandField HeaderText="编辑" ShowEditButton="True" /> 
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" /> 
</Columns> 
<EmptyDataRowStyle BackColor="Red" /> 
<HeaderStyle BackColor="#0000CC" Font-Bold="True" ForeColor="White" /> 
<PagerStyle BackColor="#864" HorizontalAlign="Center" ForeColor="White"/> 
</asp:GridView> 

 

GridView.aspx.cs

 

复制代码代码如下:

//公有数据 
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString); 
SqlCommand cmd; 
protected void Page_Load(object sender, EventArgs e) 
{ 
if (!IsPostBack) 
{ 
Drpbind();//dropdown绑定 

} 
} 


//DropDownList绑定数据 
DropDownList ddl; 
public void Drpbind() 
{ 
string sqlstr = "select top 5 * from person"; 
con.Open(); 
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, con); 
DataSet ds = new DataSet(); 
myda.Fill(ds, "person"); 
GridView1.DataSource = ds; 
GridView1.DataBind(); 
for (int i = 0; i <= GridView1.Rows.Count - 1; i++) 
{ 
DataRowView mydrv = ds.Tables["person"].DefaultView[i]; 
if (Convert.ToString(mydrv["psex"]).Trim() == "男") 
{ 
ddl = (DropDownList)GridView1.Rows[i].FindControl("DropDownList1"); 
ddl.SelectedIndex = 0; 

} 
else if (Convert.ToString(mydrv["psex"]).Trim() == "女") 
{ 
ddl = (DropDownList)GridView1.Rows[i].FindControl("DropDownList1"); 
ddl.SelectedIndex = 1; 
} 
} 
con.Close(); 

} 


//GridView和下拉菜单DropDownList结合，前台性别列datasouce调用 
public SqlDataReader ddlbind() 
{ 

string sqlstr = "select distinct psex from person";//distinct只显示一次性别 
using (cmd = new SqlCommand(sqlstr, con)) 
{ 
con.Close(); 
con.Open(); 
return cmd.ExecuteReader(); 
} 
} 

 

运行结果：

GridView常用操作事件图文介绍

 



GridView和CheckBox结合

小实例：

GridView.aspx

 

复制代码代码如下:

<form id="form1" runat="server"> 
<asp:GridView ID="GridView1" runat="server" Height="138px" Width="1117px" 
AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" 
onpageindexchanging="GridView1_PageIndexChanging" 
onrowcancelingedit="GridView1_RowCancelingEdit" 
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" 
onrowupdating="GridView1_RowUpdating" PageSize="4"> 
<Columns> 
<asp:TemplateField> 
<ItemTemplate> 
<asp:CheckBox ID="CheckBox1" runat="server" /> 
</ItemTemplate> 
</asp:TemplateField> 
<asp:BoundField DataField="pid" HeaderText="身份证号" SortExpression="pid" /> 
<asp:BoundField DataField="pname" HeaderText="姓名" SortExpression="pname" /> 
<asp:BoundField DataField="psex" HeaderText="性别" SortExpression="psex" /> 
<asp:BoundField DataField="padress" HeaderText="地址" SortExpression="padress" /> 
<asp:BoundField DataField="pyoubiao" HeaderText="邮编" SortExpression="pyoubiao" /> 
<asp:BoundField DataField="pprice" HeaderText="工资起价" SortExpression="pprice" /> 
<%-- <asp:CommandField HeaderText="选择" ShowSelectButton="True" /> 
<asp:CommandField HeaderText="编辑" ShowEditButton="True" /> 
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" />--%> 
</Columns> 
<EmptyDataRowStyle BackColor="Red" /> 
<HeaderStyle BackColor="#0000CC" Font-Bold="True" ForeColor="White" /> 
<PagerStyle BackColor="#864" HorizontalAlign="Center" ForeColor="White"/> 
</asp:GridView> 
<br /> 
<asp:CheckBox ID="CheckBox2" runat="server" ForeColor="Red" Text="全选" 
AutoPostBack="True" oncheckedchanged="CheckBox2_CheckedChanged" /> 

                                
<asp:Button ID="Button1" runat="server" Font-Bold="true" ForeColor="red" 
Text="删除" onclick="Button1_Click" /> 
   
<asp:Button ID="Button2" runat="server" Font-Bold="true" ForeColor="red" 
Text="取消" onclick="Button2_Click" /> 
</form> 


GridView.aspx.cs

 

 

复制代码代码如下:

//公有数据 
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString); 
SqlCommand cmd; 
protected void Page_Load(object sender, EventArgs e) 
{ 
if (!IsPostBack) 
{ 
bind(); //正常绑定 
} 
} 


public void bind() 
{ 
//数据连接web.config中已配置的数据 
SqlDataAdapter da = new SqlDataAdapter("select * from person", con);//使用数据适配器内置查询，自动开闭数据库 
DataSet ds = new DataSet();//使用数据集，采取断开式访问数据 
da.Fill(ds, "person"); 
GridView1.DataSource = ds; 
GridView1.DataKeyNames=new string[]{"pid"};//设置主键 
GridView1.DataBind(); 
} 


//利用CheckBox选中信息 
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("CheckBox1"); 
if (CheckBox2.Checked == true) 
{ 
cbox.Checked = true; 
} 
else 
{ 
cbox.Checked = false; 
} 
} 

} 

//删除选中信息 
protected void Button1_Click(object sender, EventArgs e) 
{ 
for (int i = 0; i <= GridView1.Rows.Count - 1; i++) 
{ 
CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1"); 
if (cbox.Checked == true) 
{ 
string sqlstr = "delete from person where pid='" + GridView1.DataKeys[i].Value + "'"; 
cmd = new SqlCommand(sqlstr, con); 
con.Open(); 
cmd.ExecuteNonQuery(); 
con.Close(); 
} 
} 
bind(); 

} 
//取消选中信息 
protected void Button2_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("CheckBox1"); 
cbox.Checked = false; 
} 

} 

运行结果：

 

GridView常用操作事件图文介绍



鼠标移到GridView某一行时改变该行的背景色方法一

小实例：

GridView.aspx

 

复制代码代码如下:

<asp:GridView ID="GridView1" runat="server" Height="138px" Width="1117px" 
AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" 
onpageindexchanging="GridView1_PageIndexChanging" 
onrowcancelingedit="GridView1_RowCancelingEdit" 
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" 
onrowupdating="GridView1_RowUpdating" PageSize="4" 
onrowdatabound="GridView1_RowDataBound"> 
<Columns> 
<asp:TemplateField> 
<ItemTemplate> 
<asp:CheckBox ID="CheckBox1" runat="server" /> 
</ItemTemplate> 
</asp:TemplateField> 
<asp:BoundField DataField="pid" HeaderText="身份证号" SortExpression="pid" /> 
<asp:BoundField DataField="pname" HeaderText="姓名" SortExpression="pname" /> 
<asp:BoundField DataField="psex" HeaderText="性别" SortExpression="psex" /> 
<asp:BoundField DataField="padress" HeaderText="地址" SortExpression="padress" /> 
<asp:BoundField DataField="pyoubiao" HeaderText="邮编" SortExpression="pyoubiao" /> 
<asp:BoundField DataField="pprice" HeaderText="工资起价" SortExpression="pprice" /> 
<%-- <asp:CommandField HeaderText="选择" ShowSelectButton="True" /> 
<asp:CommandField HeaderText="编辑" ShowEditButton="True" /> 
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" />--%> 
</Columns> 
<EmptyDataRowStyle BackColor="Red" /> 
<HeaderStyle BackColor="#0000CC" Font-Bold="True" ForeColor="White" /> 
<PagerStyle BackColor="#864" HorizontalAlign="Center" ForeColor="White"/> 
</asp:GridView> 


GridView.aspx.cs

 

 

复制代码代码如下:

//公有数据 
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString); 
SqlCommand cmd; 
protected void Page_Load(object sender, EventArgs e) 
{ 
if (!IsPostBack) 
{ 
bind(); //正常绑定 
} 
} 

public void bind() 
{ 
//数据连接web.config中已配置的数据 
SqlDataAdapter da = new SqlDataAdapter("select * from person", con);//使用数据适配器内置查询，自动开闭数据库 
DataSet ds = new DataSet();//使用数据集，采取断开式访问数据 
da.Fill(ds, "person"); 
GridView1.DataSource = ds; 
GridView1.DataKeyNames=new string[]{"pid"};//设置主键 
GridView1.DataBind(); 
} 

//鼠标移动到某一行，改变改行颜色 
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) 
{ 
for (int i = 0; i < GridView1.Rows.Count+1; i++) //执行循环，保证每条数据都可以更新 
{ 
if (e.Row.RowType == DataControlRowType.DataRow) //首先判断是否是数据行 
{ 
//当鼠标停留时更改背景色 
e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#999'"); 
//当鼠标移开时还原背景色 
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c"); 
} 
} 

} 


运行结果：

 

GridView常用操作事件图文介绍

 



鼠标移到GridView某一行时改变该行的背景色方法二

小实例：

GridView.aspx

GridView.aspx.cs

 

复制代码代码如下:

//鼠标移动到某一行，改变改行颜色 
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) 
{ 
//如果是绑定数据行 
if (e.Row.RowType == DataControlRowType.DataRow) 
{ 
//鼠标经过时，行背景色变 
e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#999'"); 
//鼠标移出时，行背景色变 
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#087'"); 
} 
} 


运行结果：

 

GridView常用操作事件图文介绍

 

GridView实现删除时弹出确认对话框

小实例：

GridView.aspx

 

复制代码代码如下:

<asp:GridView ID="GridView1" runat="server" Height="138px" Width="1117px" 
AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" 
onpageindexchanging="GridView1_PageIndexChanging" 
onrowcancelingedit="GridView1_RowCancelingEdit" 
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" 
onrowupdating="GridView1_RowUpdating" PageSize="4" 
onrowdatabound="GridView1_RowDataBound"> 
<Columns> 
<asp:TemplateField> 
<ItemTemplate> 
<asp:CheckBox ID="CheckBox1" runat="server" /> 
</ItemTemplate> 
</asp:TemplateField> 
<asp:BoundField DataField="pid" HeaderText="身份证号" SortExpression="pid" /> 
<asp:BoundField DataField="pname" HeaderText="姓名" SortExpression="pname" /> 
<asp:BoundField DataField="psex" HeaderText="性别" SortExpression="psex" /> 
<asp:BoundField DataField="padress" HeaderText="地址" SortExpression="padress" /> 
<asp:BoundField DataField="pyoubiao" HeaderText="邮编" SortExpression="pyoubiao" /> 
<asp:BoundField DataField="pprice" HeaderText="工资起价" SortExpression="pprice" /> 
<%-- <asp:CommandField HeaderText="选择" ShowSelectButton="True" /> 
<asp:CommandField HeaderText="编辑" ShowEditButton="True" />--%> 
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" /> 
</Columns> 
<EmptyDataRowStyle BackColor="Red" /> 
<HeaderStyle BackColor="#0000CC" Font-Bold="True" ForeColor="White" /> 
<PagerStyle BackColor="#864" HorizontalAlign="Center" ForeColor="White"/> 
</asp:GridView> 

 

GridView.aspx.cs

 

复制代码代码如下:

//鼠标移动到某一行，改变改行颜色 
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) 
{ 
#region 
//如果是绑定数据行 
if (e.Row.RowType == DataControlRowType.DataRow) 
{ 
//鼠标经过时，行背景色变 
e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#999'"); 
//鼠标移出时，行背景色变 
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#087'"); 
} 
#endregion 
//如果是绑定数据行 
if (e.Row.RowType == DataControlRowType.DataRow) 
{ 
if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate) 
{ 
((LinkButton)e.Row.Cells[7].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除：\"" + e.Row.Cells[1].Text + "\"吗?')"); 
} 
} 
} 


运行结果：

 

GridView常用操作事件图文介绍


GridView实现自动编号

 

小实例：

GridView.aspx

前台代码如上

GridView.aspx.cs

绑定显示数据代码如上，不再总结，以下只做主要代码：

 

复制代码代码如下:

//实现自动编号 
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) 
{ 
#region 
//如果是绑定数据行 
if (e.Row.RowType == DataControlRowType.DataRow) 
{ 
//鼠标经过时，行背景色变 
e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#999'"); 
//鼠标移出时，行背景色变 
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#087'"); 
} 
#endregion 
#region 
//如果是绑定数据行 
if (e.Row.RowType == DataControlRowType.DataRow) 
{ 
if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate) 
{ 
((LinkButton)e.Row.Cells[8].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除：\"" + e.Row.Cells[1].Text + "\"吗?')"); 
} 
} 
#endregion 
if (e.Row.RowIndex != -1) 
{ 
int id = e.Row.RowIndex + 1; 
e.Row.Cells[0].Text = id.ToString(); 
} 
} 


运行结果：

 

GridView常用操作事件图文介绍


GridView实现用“...”代替超长字符串

 

小实例：

GridView.aspx

 

复制代码代码如下:

<asp:GridView ID="GridView1" runat="server" Height="138px" Width="1117px" 
AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" 
onpageindexchanging="GridView1_PageIndexChanging" 
onrowcancelingedit="GridView1_RowCancelingEdit" 
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" 
onrowupdating="GridView1_RowUpdating" PageSize="4" 
onrowdatabound="GridView1_RowDataBound"> 
<Columns> 
<asp:BoundField DataField="id" HeaderText="证号" SortExpression="id" /> 
<asp:TemplateField> 
<ItemTemplate> 
<asp:CheckBox ID="CheckBox1" runat="server" /> 
</ItemTemplate> 
</asp:TemplateField> 
<asp:BoundField DataField="pid" HeaderText="身份证号" SortExpression="pid" /> 
<asp:BoundField DataField="pname" HeaderText="姓名" SortExpression="pname" /> 
<asp:BoundField DataField="psex" HeaderText="性别" SortExpression="psex" /> 
<asp:BoundField DataField="padress" HeaderText="地址" SortExpression="padress" /> 
<asp:BoundField DataField="pyoubiao" HeaderText="邮编" SortExpression="pyoubiao" /> 
<asp:BoundField DataField="pprice" HeaderText="工资起价" SortExpression="pprice" /> 
<%-- <asp:CommandField HeaderText="选择" ShowSelectButton="True" /> 
<asp:CommandField HeaderText="编辑" ShowEditButton="True" />--%> 
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" /> 
</Columns> 
<EmptyDataRowStyle BackColor="Red" /> 
<HeaderStyle BackColor="#0000CC" Font-Bold="True" ForeColor="White" /> 
<PagerStyle BackColor="#864" HorizontalAlign="Center" ForeColor="White"/> 
</asp:GridView> 


GridView.aspx.cs

 

 

复制代码代码如下:

public void bind() 
{ 
//数据连接web.config中已配置的数据 
SqlDataAdapter da = new SqlDataAdapter("select * from person", con);//使用数据适配器内置查询，自动开闭数据库 
DataSet ds = new DataSet();//使用数据集，采取断开式访问数据 
da.Fill(ds, "person"); 
GridView1.DataSource = ds; 
GridView1.DataKeyNames=new string[]{"pid"};//设置主键 
GridView1.DataBind(); 
//省略字符 
for (int i = 0; i <= GridView1.Rows.Count - 1; i++) 
{ 
DataRowView mydrv; 
string gIntro; 
if (GridView1.PageIndex == 0) 
{ 
mydrv = ds.Tables["person"].DefaultView[i]; 
gIntro = Convert.ToString(mydrv["padress"]); 
GridView1.Rows[i].Cells[5].Text = SubStr(gIntro, 2); 
} 
else 
{ 
mydrv = ds.Tables["person"].DefaultView[i + (5 * GridView1.PageIndex)]; 
gIntro = Convert.ToString(mydrv["padress"]); 
GridView1.Rows[i].Cells[5].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; 
} 


运行结果：

 

GridView常用操作事件图文介绍



GridView显示隐藏某一列

小实例：

GridView.aspx

 

复制代码代码如下:

<asp:GridView ID="GridView1" runat="server" Height="138px" Width="1117px" 
AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" 
onpageindexchanging="GridView1_PageIndexChanging" 
onrowcancelingedit="GridView1_RowCancelingEdit" 
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" 
onrowupdating="GridView1_RowUpdating" PageSize="4" 
onrowdatabound="GridView1_RowDataBound"> 
<Columns> 
<asp:BoundField DataField="id" HeaderText="证号" SortExpression="id" /> 
<asp:TemplateField> 
<ItemTemplate> 
<asp:CheckBox ID="CheckBox1" AutoPostBack="true" runat="server" /> 
</ItemTemplate> 
</asp:TemplateField> 
<asp:BoundField DataField="pid" HeaderText="身份证号" SortExpression="pid" /> 
<asp:BoundField DataField="pname" HeaderText="姓名" SortExpression="pname" /> 
<asp:BoundField DataField="psex" HeaderText="性别" SortExpression="psex" /> 
<asp:BoundField DataField="padress" HeaderText="地址" SortExpression="padress" /> 
<asp:BoundField DataField="pyoubiao" HeaderText="邮编" SortExpression="pyoubiao" /> 
<asp:BoundField DataField="pprice" HeaderText="工资起价" SortExpression="pprice" /> 
<%-- <asp:CommandField HeaderText="选择" ShowSelectButton="True" /> 
<asp:CommandField HeaderText="编辑" ShowEditButton="True" />--%> 
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" /> 
</Columns> 
<EmptyDataRowStyle BackColor="Red" /> 
<HeaderStyle BackColor="#0000CC" Font-Bold="True" ForeColor="White" /> 
<PagerStyle BackColor="#864" HorizontalAlign="Center" ForeColor="White"/> 
</asp:GridView> 
<br /> 
<asp:CheckBox ID="CheckBox2" runat="server" ForeColor="Red" Text="全选" 
AutoPostBack="True" oncheckedchanged="CheckBox2_CheckedChanged" /> 

   <asp:CheckBox ID="CheckBox3" runat="server" ForeColor="Red" Text="隐藏工资起价" 
AutoPostBack="True" oncheckedchanged="CheckBox3_CheckedChanged" /> 

                             
<asp:Button ID="Button1" runat="server" Font-Bold="true" ForeColor="red" 
Text="删除" onclick="Button1_Click" /> 
   
<asp:Button ID="Button2" runat="server" Font-Bold="true" ForeColor="red" 
Text="取消" onclick="Button2_Click" /> 


GridView.aspx.cs

 

 

复制代码代码如下:

public void bind() 
{ 
//数据连接web.config中已配置的数据 
SqlDataAdapter da = new SqlDataAdapter("select * from person", con);//使用数据适配器内置查询，自动开闭数据库 
DataSet ds = new DataSet();//使用数据集，采取断开式访问数据 
da.Fill(ds, "person"); 
GridView1.DataSource = ds; 
GridView1.DataKeyNames=new string[]{"pid"};//设置主键 
GridView1.DataBind(); 
//省略字符 
#region 
for (int i = 0; i <= GridView1.Rows.Count - 1; i++) 
{ 
DataRowView mydrv; 
string gIntro; 
if (GridView1.PageIndex == 0) 
{ 
mydrv = ds.Tables["person"].DefaultView[i]; 
gIntro = Convert.ToString(mydrv["padress"]); 
GridView1.Rows[i].Cells[5].Text = SubStr(gIntro, 2); 
} 
else 
{ 
mydrv = ds.Tables["person"].DefaultView[i + (5 * GridView1.PageIndex)]; 
gIntro = Convert.ToString(mydrv["padress"]); 
GridView1.Rows[i].Cells[5].Text = SubStr(gIntro, 2); 
} 
} 
#endregion 
//隐藏列 
GridView1.Columns[7].Visible = false;//一开始隐藏 
CheckBox3.Checked = false;//如果不这样后面的代码会把他True 
} 



//隐藏列 
protected void CheckBox3_CheckedChanged(object sender, EventArgs e) 
{ 
GridView1.Columns[7].Visible = !GridView1.Columns[7].Visible; 
Response.Write("GridView1的第8列现在的显示隐藏状态是：" + GridView1.Columns[7].Visible.ToString()); 
} 


运行结果：

 

GridView常用操作事件图文介绍

 



GridView弹出新页面/弹出新窗口

小实例：

GridView.aspx

运行结果：

GridView常用操作事件图文介绍


GridView突出显示某一单元格（工资低于10000元）

 

小实例：

GridView.aspx

 

复制代码代码如下:

<asp:GridView ID="GridView1" runat="server" Height="138px" Width="1117px" 
AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" 
onpageindexchanging="GridView1_PageIndexChanging" 
onrowcancelingedit="GridView1_RowCancelingEdit" 
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" 
onrowupdating="GridView1_RowUpdating" PageSize="4" 
onrowdatabound="GridView1_RowDataBound"> 
<Columns> 
<asp:BoundField DataField="pid" HeaderText="身份证号" SortExpression="pid" /> 
<%-- <asp:BoundField DataField="pname" HeaderText="姓名" SortExpression="pname" />--%> 

<asp:HyperLinkField HeaderText="姓名" Text="姓名" DataNavigateUrlFields="pname" DataNavigateUrlFormatString="WebForm1.aspx?GoodsID={0}" Target="mainframe" NavigateUrl="~/WebForm1.aspx" DataTextField="pname" > 
</asp:HyperLinkField> 
<asp:BoundField DataField="psex" HeaderText="性别" SortExpression="psex" /> 
<asp:BoundField DataField="padress" HeaderText="地址" SortExpression="padress" /> 
<asp:BoundField DataField="pyoubiao" HeaderText="邮编" SortExpression="pyoubiao" /> 
<asp:BoundField DataField="pprice" HeaderText="工资起价" DataFormatString="{0:C}" SortExpression="pprice" /> 
<asp:CommandField HeaderText="选择" ShowSelectButton="True" /> 
<asp:CommandField HeaderText="编辑" ShowEditButton="True" /> 
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" /> 
</Columns> 
<EmptyDataRowStyle BackColor="Red" /> 
<HeaderStyle BackColor="#0000CC" Font-Bold="True" ForeColor="White" /> 
<PagerStyle BackColor="#864" HorizontalAlign="Center" ForeColor="White"/> 
</asp:GridView> 


GridView.aspx.cs

 

 

复制代码代码如下:

public void bind() 
{ 
//数据连接web.config中已配置的数据 
SqlDataAdapter da = new SqlDataAdapter("select * from person", con);//使用数据适配器内置查询，自动开闭数据库 
DataSet ds = new DataSet();//使用数据集，采取断开式访问数据 
da.Fill(ds, "person"); 
GridView1.DataSource = ds; 
GridView1.DataKeyNames=new string[]{"pid"};//设置主键 
GridView1.DataBind(); 
//省略字符 
#region 
//for (int i = 0; i <= GridView1.Rows.Count - 1; i++) 
//{ 
// DataRowView mydrv; 
// string gIntro; 
// if (GridView1.PageIndex == 0) 
// { 
// mydrv = ds.Tables["person"].DefaultView[i]; 
// gIntro = Convert.ToString(mydrv["padress"]); 
// GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2); 
// } 
// else 
// { 
// mydrv = ds.Tables["person"].DefaultView[i + (5 * GridView1.PageIndex)]; 
// gIntro = Convert.ToString(mydrv["padress"]); 
// GridView1.Rows[i].Cells[5].Text = SubStr(gIntro, 2); 
// } 
//} 
#endregion 
//隐藏列 
//GridView1.Columns[3].Visible = false;//一开始隐藏 
//CheckBox3.Checked = false;//如果不这样后面的代码会把他True 
//突出显示某一单元格（工资起价少于10000） 
for (int i = 0; i <= GridView1.Rows.Count - 1; i++) 
{ 
DataRowView mydrv = ds.Tables["person"].DefaultView[i]; 
string price = Convert.ToString(mydrv["pprice"]); 
if (Convert.ToDouble(price) < 10000)//大家这里根据具体情况设置可能ToInt32等等 
{ 
GridView1.Rows[i].Cells[5].BackColor = System.Drawing.Color.Red; 
} 
} 
} 


运行结果：

 

GridView常用操作事件图文介绍


GridView数据导入Excel/Excel数据读入GridView

小实例：

GridView.aspx

复制代码代码如下:
 
<asp:GridView ID="GridView1" runat="server" Height="138px" Width="1117px" 
AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" 
onpageindexchanging="GridView1_PageIndexChanging" 
onrowcancelingedit="GridView1_RowCancelingEdit" 
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" 
onrowupdating="GridView1_RowUpdating"> 
<Columns> 

<asp:TemplateField HeaderText="身份证号" SortExpression="pid"> 
<ItemTemplate> 
<asp:Label ID="Label1" runat="server" Text='<%# Bind("pid") %>'></asp:Label> 
</ItemTemplate> 
</asp:TemplateField> 
<%-- <asp:BoundField DataField="pid" HeaderText="身份证号" SortExpression="pid" />--%> 
<asp:BoundField DataField="pname" HeaderText="姓名" SortExpression="pname" /> 
<asp:BoundField DataField="psex" HeaderText="性别" SortExpression="psex" /> 
<asp:BoundField DataField="padress" HeaderText="地址" SortExpression="padress" /> 
<asp:BoundField DataField="pyoubiao" HeaderText="邮编" SortExpression="pyoubiao" /> 
<asp:BoundField DataField="pprice" HeaderText="工资起价" SortExpression="pprice" /> 
<asp:CommandField HeaderText="选择" ShowSelectButton="True" /> 
<asp:CommandField HeaderText="编辑" ShowEditButton="True" /> 
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" /> 
</Columns> 
<EmptyDataRowStyle BackColor="Red" /> 
<HeaderStyle BackColor="#0000CC" Font-Bold="True" ForeColor="White" /> 
<PagerStyle BackColor="#864" HorizontalAlign="Center" ForeColor="White"/> 
</asp:GridView>



GridView.aspx.cs

复制代码代码如下:

//公有数据 
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString); 
SqlCommand cmd; 
protected void Page_Load(object sender, EventArgs e) 
{ 
if (!IsPostBack) 
{ 
bind(); //正常绑定 
} 
} 


/// <summary> 
/// 主题：绑定数据，查询显示个人信息 
/// 时间：2012年11月21日14:54:13 
/// 描述：通过简单的方法绑定，实现数据显示 
/// 作者：小伙 
/// </summary> 
public void bind() 
{ 
//数据连接web.config中已配置的数据 
SqlDataAdapter da = new SqlDataAdapter("select top 5 * from person", con);//使用数据适配器内置查询，自动开闭数据库 
DataSet ds = new DataSet();//使用数据集，采取断开式访问数据 
da.Fill(ds, "person"); 
GridView1.DataSource = ds; 
GridView1.DataKeyNames=new string[]{"pid"};//设置主键 
GridView1.DataBind(); 
} 

//实现分页 
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) 
{ 
GridView1.PageIndex = e.NewPageIndex; 
this.bind(); 
} 
//删除 
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) 
{ 
string sqlstr = "delete from person where pid='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; 
con.Open(); 
cmd = new SqlCommand(sqlstr, con); 
cmd.ExecuteNonQuery(); 
con.Close(); 
bind(); 


} 
//取消编辑 
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) 
{ 
GridView1.EditIndex = -1; 
bind(); 
} 
//编辑 
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) 
{ 
GridView1.EditIndex = e.NewEditIndex; 
bind(); 
} 

//更新 
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) 
{ 
string sqlstr = "update person set pname='" 
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',psex='" 
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim()+"',padress='" 
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim()+"',pyoubiao='" 
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim()+"',pprice='" 
+((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim()+"' where pid='" 
+GridView1.DataKeys[e.RowIndex].Value.ToString()+"'"; 
cmd = new SqlCommand(sqlstr, con); 
con.Open(); 
cmd.ExecuteNonQuery(); 
con.Close(); 
GridView1.EditIndex = -1; 
bind(); 

}

 

运行结果：

GridView常用操作事件图文介绍

导出结果：

GridView常用操作事件图文介绍

  • Gridview

    • 延伸 · 阅读

    精彩推荐
    最近更新
    编辑推荐
    阅读排行
    热门标签
    BasePage 　 PostBack 　 数据驱动 　 本地化资源 　 provider 　 无法显示网页 　 asp.ne 　 滚动条 　 ASPNET PAGER 　 网址 　 文件夹数 　 B2B 　 鼠标悬浮变色 　 数据列 　 冒泡算法 　 左右移动 　 分级显示 　 DbProviderFactories 　 sys未定义 　 网站优化 　 索引优化 　 数据库优化 　 网站性能优化 　 缓冲写数据 　 多文件上传 　 word文档 　 状态管理 　 服务器状态管理 　 验证提示 　 母版页 　
    © 2019-2025 服务器之家 版权所有 www.zzvips.com 关于我们联系我们版权申明网站地图