手动绑定数据到GridView并实现编辑，删除，取消···

最新推荐文章于 2025-07-22 13:14:47 发布

转载最新推荐文章于 2025-07-22 13:14:47 发布 · 379 阅读

C# 同时被 3 个专栏收录

44 篇文章

订阅专栏

HTML

12 篇文章

订阅专栏

数据库

12 篇文章

订阅专栏

本文详细介绍了ASP.NET中GridView控件的应用方法，包括如何实现数据绑定、编辑、删除等操作，并通过一个具体示例展示了如何从数据库读取学生信息并进行增删改查。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default5.aspx.cs" Inherits="Default5" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

CellPadding="4" ForeColor="#333333" GridLines="None" Height="285px"

onrowcancelingedit="GridView1_RowCancelingEdit"

onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing"

onrowupdating="GridView1_RowUpdating" Width="771px">

<asp:BoundField DataField="id" HeaderText="学号" />

<asp:BoundField DataField="name" HeaderText="姓名" />

<asp:BoundField DataField="sex" HeaderText="性别" />

<asp:BoundField DataField="age" HeaderText="年龄" />

<asp:BoundField DataField="department" HeaderText="专业" />

<asp:BoundField DataField="grade" HeaderText="班级" />

<asp:CommandField HeaderText="编辑 " ShowEditButton="True" />

<asp:CommandField HeaderText="选择" ShowSelectButton="True" />

<asp:TemplateField HeaderText="删除 " ShowHeader="False">

<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False"

CommandName="Delete" Text="删除" OnClientClick="return confirm('你确定要删除吗？')"></asp:LinkButton>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</div>

</form>

</body>

</html>

后台代码：

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Data.SqlClient;

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

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

Bind();

}

private void Bind()

{

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Personal"].ConnectionString);

SqlDataAdapter adq = new SqlDataAdapter("select * from information", conn);

DataSet dataset=new DataSet();

adq.Fill(dataset,"information");

GridView1.DataSource=dataset;

GridView1.DataKeyNames=new String[]{"id"};

GridView1.DataBind();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;

Bind();

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Personal"].ConnectionString);

SqlCommand comm = new SqlCommand("delete from information where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'",conn);

conn.Open();

try

{

int i = Convert.ToInt32(comm.ExecuteNonQuery());

if (i > 0)

{

Response.Write("<script language=javascript>alert('删除成功！')</script>");

}

else

{

Response.Write("<script language=javascript>alert('删除失败！')</script>");

}

Bind();

}

catch (Exception erro)

{

Response.Write("错误信息:"+erro.Message);

}

finally

{

conn.Close();

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

string id = ((TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text.ToString().Trim();

string name = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString().Trim();

string sex = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.ToString().Trim();

string age= ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text.ToString().Trim();

string department = ((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text.ToString().Trim();

string grade = ((TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0]).Text.ToString().Trim();

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Personal"].ConnectionString);

SqlCommand comm = new SqlCommand("update information set id='"+id+"', name='"+name+"' , sex='"+sex+"' , age='"+age+"' , department='"+department+"' , grade='"+grade+"' where id='"+GridView1.DataKeys[e.RowIndex].Value.ToString()+"'", conn);

conn.Open();

try

{

int i = Convert.ToInt32(comm.ExecuteNonQuery());

if (i > 0)

{

Response.Write("<script language=javascript>alert('保存成功！')</script>");

}

else

{

Response.Write("<script language=javascript>alert('保存失败！')</script>");

}

GridView1.EditIndex = -1;

Bind();

}

catch (Exception erro)

{

Response.Write("错误信息:" + erro.Message);

}

finally

{

conn.Close();

}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

Bind();

}

原文地址：http://www.cnblogs.com/dushouke/archive/2008/03/24/1120377.html