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