萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 網路程式設計 >> ASP.NET 程式設計

ASP.NET GridView 完整 CRUD 實作 (編輯、更新、刪除、分頁、新增)

前言

GridView 是 Web Forms 最核心的資料呈現控制項,內建支援分頁、排序、編輯、刪除。本文提供完整可運作的範例,涵蓋 `TemplateField` 自訂編輯介面、參數化 SQL、例外處理與使用者體驗優化。

前端 .aspx 完整標記

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Demo.Default" %>
<html><body>
<form id="form1" runat="server">
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Num"
        OnRowEditing="GridView1_RowEditing"
        OnRowCancelingEdit="GridView1_RowCancelingEdit"
        OnRowUpdating="GridView1_RowUpdating"
        OnRowDeleting="GridView1_RowDeleting"
        OnPageIndexChanging="GridView1_PageIndexChanging"
        AllowPaging="True" PageSize="10"
        CssClass="table table-striped">
        <Columns>
            <asp:TemplateField HeaderText="編號" Visible="False">
                <ItemTemplate>
                    <asp:Label ID="lblNum" runat="server" Text='<%# Eval("Num") %>' />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="姓名">
                <ItemTemplate><asp:Label ID="lblName" runat="server" Text='<%# Eval("TableName") %>' /></ItemTemplate>
                <EditItemTemplate><asp:TextBox ID="txtName" runat="server" Text='<%# Bind("TableName") %>' /></EditItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="地址">
                <ItemTemplate><asp:Label ID="lblAddr" runat="server" Text='<%# Eval("TextName") %>' /></ItemTemplate>
                <EditItemTemplate><asp:TextBox ID="txtAddr" runat="server" Text='<%# Bind("TextName") %>' /></EditItemTemplate>
            </asp:TemplateField>
            <asp:CommandField HeaderText="操作" ShowEditButton="True" ShowDeleteButton="True" ShowCancelButton="True" />
        </Columns>
    </asp:GridView>
    <br />
    <asp:Button ID="btnAdd" runat="server" Text="新增" OnClick="btnAdd_Click" CssClass="btn btn-primary" />
</form>
</body></html>

後端 .aspx.cs 完整程式碼

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.UI.WebControls;

namespace Demo
{
    public partial class Default : System.Web.UI.Page
    {
        private string ConnStr => ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack) BindGrid();
        }

        private void BindGrid()
        {
            const string sql = "SELECT Num, TableName, TextName FROM dbo.GroupType_Demo ORDER BY Num";
            using (var conn = new SqlConnection(ConnStr))
            using (var da = new SqlDataAdapter(sql, conn))
            {
                var dt = new DataTable();
                da.Fill(dt);
                GridView1.DataSource = dt;
                GridView1.DataBind();
            }
        }

        protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            GridView1.PageIndex = e.NewPageIndex;
            BindGrid();
        }

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

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

        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            int num = (int)GridView1.DataKeys[e.RowIndex].Value; // 取主鍵,比 FindControl 可靠
            string name = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtName")).Text.Trim();
            string addr = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtAddr")).Text.Trim();

            const string sql = "UPDATE dbo.GroupType_Demo SET TableName=@Name, TextName=@Addr WHERE Num=@Num";
            ExecuteNonQuery(sql, ("@Name", name), ("@Addr", addr), ("@Num", num));
            
            GridView1.EditIndex = -1;
            BindGrid();
            ShowMessage("更新成功");
        }

        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            int num = (int)GridView1.DataKeys[e.RowIndex].Value;
            ExecuteNonQuery("DELETE FROM dbo.GroupType_Demo WHERE Num=@Num", ("@Num", num));
            BindGrid();
            ShowMessage("刪除成功");
        }

        protected void btnAdd_Click(object sender, EventArgs e)
        {
            Response.Redirect("~/AddItem.aspx"); // 導向新增頁面
        }

        private void ExecuteNonQuery(string sql, params (string, object)[] parameters)
        {
            using (var conn = new SqlConnection(ConnStr))
            using (var cmd = new SqlCommand(sql, conn))
            {
                foreach (var (name, val) in parameters) cmd.Parameters.AddWithValue(name, val);
                conn.Open();
                cmd.ExecuteNonQuery();
            }
        }

        private void ShowMessage(string msg) => 
            ClientScript.RegisterStartupScript(GetType(), "msg", $"alert('{msg}');", true);
    }
}

關鍵最佳實務

  1. DataKeyNames="Num":指定主鍵欄位,`GridView1.DataKeys[rowIndex].Value` 直接取得,避免隱藏 Label 找控制項。
  2. Bind() vs Eval():編輯模板用 `Bind("Column")` 雙向綁定,顯示模板用 `Eval("Column")`。
  3. 參數化查詢:所有 SQL 使用 `@Param`,防止注入。
  4. using 區塊:連線、命令、DataAdapter 全部包在 using,確保資源釋放。
  5. 例外處理:實務上 `ExecuteNonQuery` 應包 try-catch,記錄錯誤並友善提示。

新增頁面 (AddItem.aspx) 簡易範例

<asp:TextBox ID="txtName" runat="server" /> <asp:RequiredFieldValidator ControlToValidate="txtName" Text="*" />
<asp:TextBox ID="txtAddr" runat="server" />
<asp:Button Text="儲存" OnClick="btnSave_Click" />

// 後台
protected void btnSave_Click(object sender, EventArgs e)
{
    ExecuteNonQuery("INSERT INTO GroupType_Demo (TableName, TextName) VALUES (@Name, @Addr)", 
        ("@Name", txtName.Text), ("@Addr", txtAddr.Text));
    Response.Redirect("Default.aspx");
}
copyright © 萬盛學電腦網 all rights reserved