<%@ Control Language="C#" AutoEventWireup="true" CodeFile="CategoryAdd.ascx.cs" Inherits="CategoryAddControl" %>
<table style="width: 100%">
    <tr>
        <td style="width: 100%">
            <h1>
                카테고리 등록</h1>
            카테고리명:
            <asp:TextBox ID="txtCategoryName" runat="server"></asp:TextBox>&nbsp;
            <asp:Button ID="btnAddCategory" runat="server" Text="추가" OnClick="btnAddCategory_Click" />
            <br />
            <br />
            [코드 기반 출력]<br />
            <asp:GridView ID="ctlCategoryList" runat="server" AutoGenerateColumns="false">
                <Columns>
                    <asp:BoundField DataField="CategoryID" HeaderText="CategoryID" InsertVisible="False"
                        ReadOnly="True" SortExpression="CategoryID" />
                    <asp:BoundField DataField="CategoryName" HeaderText="CategoryName" SortExpression="CategoryName" />
                </Columns>
            </asp:GridView>
            <br />
            <hr />
            <br />
            [컨트롤 기반 출력]<br />
            <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
                AutoGenerateColumns="False" DataKeyNames="CategoryID" DataSourceID="sdsCategory"
                OnDataBound="GridView1_DataBound">
                <Columns>
                    <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowSelectButton="True" />
                    <asp:BoundField DataField="CategoryID" HeaderText="CategoryID" InsertVisible="False"
                        ReadOnly="True" SortExpression="CategoryID" />
                    <asp:BoundField DataField="CategoryName" HeaderText="CategoryName" SortExpression="CategoryName" />
                </Columns>
            </asp:GridView>
            <asp:SqlDataSource ID="sdsCategory" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
                DeleteCommand="DELETE FROM [Categories] WHERE [CategoryID] = @CategoryID" InsertCommand="INSERT INTO [Categories] ([CategoryName]) VALUES (@CategoryName)"
                SelectCommand="SELECT [CategoryID], [CategoryName] FROM [Categories] ORDER BY [CategoryID] DESC"
                UpdateCommand="UPDATE [Categories] SET [CategoryName] = @CategoryName WHERE [CategoryID] = @CategoryID">
                <DeleteParameters>
                    <asp:Parameter Name="CategoryID" Type="Int32" />
                </DeleteParameters>
                <UpdateParameters>
                    <asp:Parameter Name="CategoryName" Type="String" />
                    <asp:Parameter Name="CategoryID" Type="Int32" />
                </UpdateParameters>
                <InsertParameters>
                    <asp:Parameter Name="CategoryName" Type="String" />
                </InsertParameters>
            </asp:SqlDataSource>
        </td>
    </tr>
</table>

using System;
using System.Web.UI;

public partial class CategoryAddControl : System.Web.UI.UserControl
{
    #region Event Handlers
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            ReadData();
        }
    }
    protected void btnAddCategory_Click(object sender, EventArgs e)
    {
        CategoriesDB c = new CategoriesDB();
        c.AddCategory(this.txtCategoryName.Text);
        ReadData();
        Response.Redirect("CategoryAdd.aspx");
    }
    protected void GridView1_DataBound(object sender, EventArgs e)
    {
        ReadData();
    }
    #endregion

    #region Private Methods
    private void ReadData()
    {
        CategoriesDB c = new CategoriesDB();
        this.ctlCategoryList.DataSource = c.GetCategories();
        this.ctlCategoryList.DataBind();
    }
    #endregion
}