c# datatable 添删改datarow

最新推荐文章于 2021-11-07 10:45:10 发布

曹振华

最新推荐文章于 2021-11-07 10:45:10 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： c# web 文章标签： c# web datatable 添删改datarow

本文链接：https://blog.youkuaiyun.com/chadcao/article/details/7782078

c# web 专栏收录该内容

54 篇文章

订阅专栏

本文介绍了一个使用ASP.NET实现的简单示例，该示例展示了如何利用GridView控件完成基本的增删改查(CRUD)操作。示例中包含了前端页面布局与后端逻辑处理的完整代码。

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

1）前台

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication14._Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="gvwTest" runat="server" AutoGenerateColumns="false">
        <Columns>
            <asp:BoundField HeaderText="id" DataField="id" />
            <asp:BoundField HeaderText="name" DataField="name" />
        </Columns>
        </asp:GridView>
        <asp:Button ID="btnAdd" runat="server" Text="add" οnclick="btnAdd_Click" />
        <asp:Button ID="btnUpdate" runat="server" Text="update" 
            οnclick="btnUpdate_Click" />
        <asp:Button ID="btnDelete" runat="server" Text="delete" οnclick="btnDelete_Click" />
    </div>
    </form>
</body>
</html>

2）后台

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
namespace WebApplication14
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if(!IsPostBack)
            {
                ViewState["dtTest"]=null;
                ViewState["id"]=1;
                InitTable();
                BindGridView();
            }
        }
        private void BindGridView()
        {
            gvwTest.DataSource = (DataTable)ViewState["dtTest"];
            gvwTest.DataBind();
        }
        private void InitTable()
        {
            DataTable dtTest = new DataTable();
            dtTest.Columns.Add(new DataColumn("id"));
            dtTest.Columns.Add(new DataColumn("name"));
            dtTest.PrimaryKey = new DataColumn[] { dtTest.Columns["id"] };
            ViewState["dtTest"] = dtTest;
        }
        /// <summary>
        /// add
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            DataTable dtTest = (DataTable)ViewState["dtTest"];
            DataRow dr = dtTest.NewRow();
            dr["id"] = ViewState["id"];
            ViewState["id"] = Convert.ToInt32(ViewState["id"]) + 1;
            dr["name"] = "zhangsan";
            dtTest.Rows.Add(dr);
            BindGridView();
        }
        /// <summary>
        /// update
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            DataTable dtTest = (DataTable)ViewState["dtTest"];
            DataRow dr = dtTest.Rows.Find(1);
            dr.BeginEdit();
            dr["name"] = "lisi";
            dr.EndEdit();
            BindGridView();
        }
        /// <summary>
        /// delete
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnDelete_Click(object sender, EventArgs e)
        {
            DataTable dtTest = (DataTable)ViewState["dtTest"];
            dtTest.Rows.Find(1).Delete();
            BindGridView();
        }
       
    }
}