GridView1 修改,删除操作

最新推荐文章于 2024-04-14 17:03:53 发布

wklilong

最新推荐文章于 2024-04-14 17:03:53 发布

阅读量714

点赞数

文章标签： textbox dataset object server string xhtml

本文链接：https://blog.csdn.net/wklilong/article/details/2443837

版权

后台代码

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Collections.Generic;
using System.Text;
using Lucene.Net.Analysis.Standard;
using Lucene.Net.Analysis;
using Lucene.Net.Index;
using Lucene.Net.Documents;
using System.IO;
using Lucene.Net.Analysis.Cn;
using Rainsoft.WordSeg;
using System.Data.SqlClient;
using bean;

public partial class aspx_demo : System.Web.UI.Page
{
    conn con = new conn();
    protected void Page_Load(object sender, EventArgs e)
    {
        //初始化控件属性
        this.GridView1.AutoGenerateDeleteButton = true;
        this.GridView1.AutoGenerateEditButton = true;
        this.GridView1.Width = new System.Web.UI.WebControls.Unit("100%");
        this.GridView1.AllowPaging = true;
        this.GridView1.PageSize = 3;

this.BangDing();
}

    //绑定函数
    public void BangDing()
    {
        string sql = "select * from guanjianci";
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(sql, con.CreateConnection());
        da.Fill(ds, "List");

GridView1.DataKeyNames = new string[] { "id" }; //主键

        this.GridView1.DataSource = ds.Tables["List"].DefaultView;
        this.GridView1.DataBind();
    }

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string sqlstr = "delete from guanjianci where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        Response.Write(sqlstr);
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        this.TextBox1.Text = this.GridView1.Rows[e.NewEditIndex].Cells[2].Text;
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        int index = e.NewPageIndex;
        Response.Write(index+"<br>");
        this.GridView1.PageIndex = index;
        BangDing();
    }
}

前台代码

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="demo.aspx.cs" Inherits="aspx_demo" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

wklilong

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
GridView1 修改,删除操作

后台代码 using System;using System.Collections;using System.Configuration;using System.Data;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.W
复制链接

扫一扫