ASP.NET(C#) GridView （编辑、删除、更新、取消）

最新推荐文章于 2024-08-03 22:39:47 发布

weixin_34174422

最新推荐文章于 2024-08-03 22:39:47 发布

阅读量252

点赞数

文章标签： xhtml ui python

原文链接：https://my.oschina.net/dldlhrmc/blog/93458

版权

2019独角兽企业重金招聘Python工程师标准>>>

前台代码

<%@ 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>
     
         <asp:GridView ID="GridView1" runat="server" AutoGenerateDeleteButton="True" 
             AutoGenerateEditButton="True" DataKeyNames="id" 
             onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" 
             onrowupdating="GridView1_RowUpdating" 
             onrowcancelingedit="GridView1_RowCancelingEdit" >
         </asp:GridView>
     
     </div>
     </form>
 </body>
 </html>

后台代码

using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Web;
 using System.Web.UI;
 using System.Web.UI.WebControls;
 using System.Data.SqlClient;
 using System.Data;
 
 public partial class Default5 : System.Web.UI.Page
 {
     private void BindData()
     {
         String Strcon = "Data Source=.;Initial Catalog=testDB;Integrated Security=True";
         SqlConnection con = new SqlConnection(Strcon);
         String sql = "select userinfo.id,username,password,birthday from userinfo";
         SqlDataAdapter ad = new SqlDataAdapter(sql, con);
         DataSet ds = new DataSet();
         ad.Fill(ds);
         GridView1.DataSource = ds;
         GridView1.DataBind();
     }
 
     protected void Page_Load(object sender, EventArgs e)
     {
         if (!IsPostBack)  /*如果省略这句，下面的更新操作将无法完成，因为获得的值是不变的*/
         {
             BindData();
         }
     }
     protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
     {
         String Strcon = "Data Source=.;Initial Catalog=testDB;Integrated Security=True";
         SqlConnection con = new SqlConnection(Strcon);
         int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);/*获取主键，需要设置 DataKeyNames，这里设为 id */
         String sql = "delete from userinfo where id='" + id+"'";
         
         SqlCommand com = new SqlCommand(sql, con);
         con.Open();
         com.ExecuteNonQuery();
         con.Close();
         BindData();
 
     }
 
     /*编辑操作，利用e.NewEditIndex获取当前编辑行索引*/
     protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
     {
         GridView1.EditIndex = e.NewEditIndex;
         BindData();              /*再次绑定显示编辑行的原数据,不进行绑定要点2次编辑才能跳到编辑状态*/
     }
     protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
     {
         String Strcon = "Data Source=.;Initial Catalog=testDB;Integrated Security=True";
         SqlConnection con = new SqlConnection(Strcon);
         String username = (GridView1.Rows[e.RowIndex].Cells[2].Controls[0] as TextBox).Text.ToString();    /*获取要更新的数据*/
         String password = (GridView1.Rows[e.RowIndex].Cells[3].Controls[0] as TextBox).Text.ToString();
         String birthday = (GridView1.Rows[e.RowIndex].Cells[4].Controls[0] as TextBox).Text.ToString();
 
         int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);/*获取主键，需要设置 DataKeyNames，这里设为 id */
 
         String sql = "update userinfo set username='" + username + "',password='"+password+"',birthday='"+birthday+"' where id='"+id+"'";
 
         SqlCommand com = new SqlCommand(sql, con);
         con.Open();
         com.ExecuteNonQuery();
         con.Close();
         GridView1.EditIndex = -1;
         BindData();
     }
     protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
     {
         GridView1.EditIndex = -1;                 /*编辑索引赋值为-1，变回正常显示状态*/
         BindData();
     }
 }

SQL 脚本（SQL Server）

USE [testDB]
 GO
 
 /****** Object:  Table [dbo].[userinfo]    Script Date: 12/02/2012 22:20:46 ******/
 SET ANSI_NULLS ON
 GO
 
 SET QUOTED_IDENTIFIER ON
 GO
 
 SET ANSI_PADDING ON
 GO
 
 CREATE TABLE [dbo].[userinfo](
 	[id] [int] IDENTITY(1,1) NOT NULL,
 	[username] [varchar](50) NULL,
 	[password] [varchar](50) NULL,
 	[birthday] [varchar](50) NULL,
  CONSTRAINT [PK_userinfo] PRIMARY KEY CLUSTERED 
 (
 	[id] ASC
 )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 ) ON [PRIMARY]
 
 GO
 
 SET ANSI_PADDING OFF
 GO

本人菜鸟，勿喷！仅供参考。

转载于:https://my.oschina.net/dldlhrmc/blog/93458