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

ASP.NET

JavaScript ASP.NET PHP编程正则表达式 AJAX相关 ASP编程 JSP编程编程10000问 CSS/HTML Flex 脚本加解密 web2.0 XML/RSS 网页编辑器相关技巧安全相关网页播放器 Dart Vue.js

上一篇: 解析GridView自带分页及与DropDo... 下一篇:有关.NET参数传递的方式引发的思...

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

发布时间：2022-04-16 发布网站：脚本宝典

脚本宝典收集整理的这篇文章主要介绍了详解GridView自带的编辑删除更新功能，脚本宝典觉得挺不错的，现在分享给大家，也给大家做个参考。

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

效果图：

前台代码：

<%@ 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>

后台代码：

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();
 }
}

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

您可能感兴趣的文章: