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

技术  /  管理员 发布于 7年前   228

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

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


  • 上一条：
    解析GridView自带分页及与DropDownList结合使用
    下一条：
    详解在DevExpress程序中使用TreeList控件以及节点查询的处理

    • 昵称：

    邮箱：

    0条评论 (评论内容有缓存机制,请悉知!)
    Top

    Copyright·© 2019 侯体宗版权所有· 粤ICP备20027696号 PHP交流群

    侯体宗的博客