关于数据在后台的删除修改（代码有错误等待更正不完全）

最新推荐文章于 2022-05-30 16:45:11 发布

yhh345814509

最新推荐文章于 2022-05-30 16:45:11 发布

阅读量397

点赞数

CC 4.0 BY-SA版权

文章标签： dataset datagrid textbox object asp server

本文链接：https://blog.youkuaiyun.com/yhh345814509/article/details/6987208

本文介绍了一个使用 ASP.NET 和 C# 实现的简单 Web 应用示例，该应用通过 DataGrid 控件展示并允许用户编辑数据库中的用户信息记录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication3._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 WebApplication3
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                loadgrid();
            }
        }
        protected void loadgrid()
        {
            string strconn = "server=.\\SQLEXPRESS;database=text;integrated security=true;";
            SqlConnection conn = new SqlConnection(strconn);
            string sqlstr = "SELECT * FROM text";
            SqlDataAdapter adapter = new SqlDataAdapter(sqlstr ,conn );
            DataSet ds = new DataSet();
            adapter.Fill(ds);

            conn.Open();
            dg1.DataSource = ds;
            dg1.DataBind();
            conn.Close();

        }
        public void editrecord(object sender, DataGridCommandEventArgs e)
        {
            dg1.EditItemIndex = e.Item.TabIndex;
            loadgrid();
        }
        public void cancelrecord(object sender, DataGridCommandEventArgs e)
        {
            dg1.EditItemIndex = -1;
            loadgrid();
        }
        public void updaterecord(object sender, DataGridCommandEventArgs e)
        {
            int id = Convert.ToInt32(e.Item.Cells[0].Text);
            TextBox nameTextBox = (TextBox)e.Item.Cells[2].Controls[0];
            Decimal name = Convert.ToDecimal(nameTextBox.Text );