GridView总结二：GridView自带编辑删除更新

时间：2021-07-17 16:07:16

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

效果图：

GridView总结二：GridView自带编辑删除更新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();

    }

}

　　效果图：

相关文章