数据在后台修改删除更新正确代码（共享）

来源：互联网发布：matlab保存数组到文件编辑：程序博客网时间：2024/05/05 02:27

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="update2.aspx.cs" Inherits="update2" EnableViewState="false" %>

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class update2 : System.Web.UI.Page
{
    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbcon"].ConnectionString);
    protected void Page_Load(object sender, EventArgs e)
    {
        getda();
    }

    protected void getda()
    {
        SqlCommand cmd = new SqlCommand("select * from lxnews", conn);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds, "lxnews");
        this.GridView1.DataSource = ds.Tables[0].DefaultView;
        this.GridView1.DataBind();
    }
    protected void GridView1_PageIndexChanging1(object sender, GridViewPageEventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        getda();
    }
    protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
    {

    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        this.GridView1.EditIndex = e.NewEditIndex;
        getda();
    }

    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        this.GridView1.EditIndex = -1;
        getda();
    }

    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
            string newid = this.GridView1.DataKeys[e.RowIndex][0].ToString();
            string lxtitle = ((TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text.ToString();//可以在此设置断点试一下
            string lxtj = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString();
            //Response.Write(newid + "-----" + lxtitle);
            //Response.End();
            updatenews(newid, lxtitle, lxtj);
            this.GridView1.EditIndex = -1;
            getda();
    }
    public void updatenews(string newsid, string newstitle, string newstj)
    {
        SqlCommand cmd = new SqlCommand("update lxnews set newstitle='" + newstitle + "',tj='" + newstj + "' where newsid=" + Convert.ToInt32(newsid) + "", conn);
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string newid = this.GridView1.DataKeys[e.RowIndex][0].ToString();
        SqlCommand cmd = new SqlCommand("delete from lxnews where newsid=" + Convert.ToInt32(newid) + "", conn);
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
        getda();
    }

}

更改后的代码及效果 //更新为更新第一次 id赋值给 username 更新第二次 id赋值给 pwd 根本无法更真实文档

已经实现成功 pageload 必须加入 if(!ispostback){

}

前台页面

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication75._Default" %>

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

后台

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace WebApplication75
{
//更新为更新第一次 id赋值给 username 更新第二次 id赋值给 pwd 根本无法更真实文档

    public partial class _Default : System.Web.UI.Page
    {
        //string strconn = "server=.;database=admin;integrated security=true;";
        //SqlConnection conn = new SqlConnection(strconn);
        protected void Page_Load(object sender, EventArgs e)
        {
            getda();
        }

        protected void getda()
        {
            string strconn = "server=.;database=admin;integrated security=true;";
            SqlConnection conn = new SqlConnection(strconn);
            SqlCommand cmd = new SqlCommand("select * from admin", conn);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds, "admin");
            this.GridView1.DataSource = ds.Tables[0].DefaultView;
            this.GridView1.DataBind();
        }
        protected void GridView1_PageIndexChanging1(object sender, GridViewPageEventArgs e)
        {
            this.GridView1.PageIndex = e.NewPageIndex;
            getda();
        }
        protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
        {

        }
        protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
        {
            this.GridView1.EditIndex = e.NewEditIndex;
            getda();
        }

        protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            this.GridView1.EditIndex = -1;
            getda();
        }

        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            string id = this.GridView1.DataKeys[e.RowIndex][0].ToString();
            string username = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString();//可以在此设置断点试一下
            string pwd = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.ToString();
            //Response.Write(newid + "-----" + lxtitle);
            //Response.End();
            updatenews(id, username , pwd );
            this.GridView1.EditIndex = -1;
            getda();
        }
        public void updatenews(string id, string username, string pwd)
        {
            string strconn = "server=.;database=admin;integrated security=true;";
            SqlConnection conn = new SqlConnection(strconn);
            SqlCommand cmd = new SqlCommand("update admin set username='" + username + "',pwd='" + pwd + "' where id=" + Convert.ToInt32(id) + "", conn);
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
        }
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            string strconn = "server=.;database=admin;integrated security=true;";
            SqlConnection conn = new SqlConnection(strconn);
            string id = this.GridView1.DataKeys[e.RowIndex][0].ToString();
            SqlCommand cmd = new SqlCommand("delete from admin where id=" + Convert.ToInt32(id) + "", conn);
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
            getda();
        }
    }
}

数据在后台修改 删除 更新 正确代码（共享）

数据在后台修改删除更新正确代码（共享）