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

最新推荐文章于 2025-05-31 10:36:05 发布

cileen

最新推荐文章于 2025-05-31 10:36:05 发布

阅读量445

点赞数

文章标签： textbox server dataset delete asp c#

本文链接：https://blog.csdn.net/cileen/article/details/5632405

版权

本文介绍了一个使用ASP.NET中的GridView控件实现增删改查功能的实例。该示例展示了如何通过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 " >

< html xmlns = " http://www.w3.org/1999/xhtml " >
< head runat = " server " >
     < title > 无标题页 </ title >
</ head >
< body >
     < form id = " form1 " runat = " server " >
     < div align = " center " >

         < 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 " >
             < FooterStyle BackColor = " #5D7B9D " Font - Bold = " True " ForeColor = " White " />
             < RowStyle BackColor = " #F7F6F3 " ForeColor = " #333333 " />
             < Columns >
                 < 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 " >
                     < ItemTemplate >
                         < asp:LinkButton ID = " LinkButton1 " runat = " server " CausesValidation = " False "
                            CommandName = " Delete " Text = " 删除 " OnClientClick = " return confirm('你确定要删除吗？') " ></ asp:LinkButton >
                     </ ItemTemplate >
                 </ asp:TemplateField >
             </ Columns >
             < PagerStyle BackColor = " #284775 " ForeColor = " White " HorizontalAlign = " Center " />
             < SelectedRowStyle BackColor = " #E2DED6 " Font - Bold = " True " ForeColor = " #333333 " />
             < HeaderStyle BackColor = " #5D7B9D " Font - Bold = " True " ForeColor = " White " />
             < EditRowStyle BackColor = " #999999 " />
             < AlternatingRowStyle BackColor = " White " ForeColor = " #284775 " />
         </ 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();
    }