个人中心
gpt4 book ai didi

详解GridView自带的编辑删除更新功能

转载 作者：qq735679552 更新时间：2022-09-29 22:32:09 27 4
gpt4 key购买 nike

CFSDN坚持开源创造价值，我们致力于搭建一个资源共享平台，让每一个IT人在这里找到属于你的精彩世界.

这篇CFSDN的博客文章详解GridView自带的编辑删除更新功能由作者收集整理，如果你对这篇文章有兴趣，记得点赞哟.

GridView自带编辑删除更新逻辑很简单：操作完，重新绑定。总结总结，防止忘记。。.

效果图:

详解GridView自带的编辑删除更新功能

详解GridView自带的编辑删除更新功能

前台代码:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="gridView_bianjidelete.aspx.cs" Inherits="gridView_bianjidelete" %>
<!DOCTYPE html>
< html xmlns = "http://www.w3.org/1999/xhtml" >
< head runat = "server" >
< meta http-equiv = "Content-Type" content = "text/html; charset=utf-8" />
  < title ></ title >
</ head >
< body >
  < form id = "form1" runat = "server" >
  < div >
  < asp:GridView ID = "GridView1" runat = "server" AutoGenerateColumns = "False" CellPadding = "4"
    ForeColor = "#333333" GridLines = "None" OnRowDeleting = "GridView1_RowDeleting" OnRowEditing = "GridView1_RowEditing"
    OnRowUpdating = "GridView1_RowUpdating" OnRowCancelingEdit = "GridView1_RowCancelingEdit" >
       < FooterStyle BackColor = "#990000" Font-Bold = "True" ForeColor = "White" />
       < Columns >
        < asp:BoundField DataField = "ID" HeaderText = "产品ID" ReadOnly = "True" />
        < asp:BoundField DataField = "name" HeaderText = "产品name" />
        < asp:BoundField DataField = "stock" HeaderText = "库存" />
        < asp:CommandField HeaderText = "选择" ShowSelectButton = "True" />
        < asp:CommandField HeaderText = "编辑" ShowEditButton = "True" />
        < asp:CommandField HeaderText = "删除" ShowDeleteButton = "True" />
       </ Columns >
       < RowStyle ForeColor = "#000066" />
       < SelectedRowStyle BackColor = "#669999" Font-Bold = "True" ForeColor = "Red" />
       < PagerStyle BackColor = "White" ForeColor = "#000066" HorizontalAlign = "Left" />
       < HeaderStyle BackColor = "#006699" Font-Bold = "True" ForeColor = "White" />
      </ asp:GridView >
  </ div >
  </ form >
</ body >
</ html >

后台代码:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class gridView_bianjidelete : System.Web.UI.Page
{ //清清月儿http://blog.csdn.net/21aspnet
  SqlConnection sqlcon;
  SqlCommand sqlcom;
  string strCon = ConfigurationManager.ConnectionStrings[ "SQLCONNECTIONSTRING" ].ConnectionString;
  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 = "delete from product where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'" ;
   sqlcon = new SqlConnection(strCon);
   sqlcom = new SqlCommand(sqlstr, sqlcon);
   sqlcon.Open();
   sqlcom.ExecuteNonQuery();
   sqlcon.Close();
   GridView1.DataBind();
   bind();
  }
  //更新
  protected void GridView1_RowUpdating( object sender, GridViewUpdateEventArgs e)
  {
   sqlcon = new SqlConnection(strCon);
   string sqlstr = "update product set name='"
    + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',stock='"
    + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "' where id='"
    + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'" ;
   sqlcom = new SqlCommand(sqlstr, sqlcon);
   sqlcon.Open();
   sqlcom.ExecuteNonQuery();
   sqlcon.Close();
   GridView1.EditIndex = -1;
   // GridView1.DataBind();
   bind();
  }
  //取消
  protected void GridView1_RowCancelingEdit( object sender, GridViewCancelEditEventArgs e)
  {
   GridView1.EditIndex = -1;
   bind();
  }
  //绑定
  public void bind()
  {
   string sqlstr = "select * from product p,Uuser u where p.userid=u.id" ;
   sqlcon = new SqlConnection(strCon);
   SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
   DataSet myds = new DataSet();
   sqlcon.Open();
   myda.Fill(myds, "datatable" );
   GridView1.DataSource = myds;
   GridView1.DataKeyNames = new string [] { "id" }; //主键
   GridView1.DataBind();
   sqlcon.Close();
  }
}

以上就是本文的全部内容，希望本文的内容对大家的学习或者工作能带来一定的帮助，同时也希望多多支持我！ 。

原文链接：http://www.cnblogs.com/jycboy/p/5172385.html 。

最后此篇关于详解GridView自带的编辑删除更新功能的文章就讲到这里了,如果你想了解更多关于详解GridView自带的编辑删除更新功能的内容请搜索CFSDN的文章或继续浏览相关文章，希望大家以后支持我的博客！ 。

27 4 0
文章推荐： 一步步教你在Asp.net Mvc中使用UEditor编辑器
文章推荐： 解析GridView自带分页及与DropDownList结合使用
文章推荐： 有关.NET参数传递的方式引发的思考
文章推荐： CentOS 6.2使用yum安装LAMP以及phpMyadmin详解
qq735679552
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com