1<%...@ Page Language="C#" MasterPageFile="~/admin/MasterPage.master" AutoEventWireup="true" CodeFile="area.aspx.cs" Inherits="admin_area" Title="Untitled Page" %>
 2<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 3    <table>
 4        <tr>
 5            <td>地区名称：
 6            </td>
 7            <td>
 8                <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
 9            </td>
10            <td>
11            </td>
12        </tr>
13        <tr>
14            <td>
15                排序：</td>
16            <td>
17                <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td>
18            <td>
19            </td>
20        </tr>
21        <tr>
22            <td>
23                &nbsp;</td>
24            <td>
25                <asp:Button ID="Button1" runat="server" Text="添加" OnClick="Button1_Click" /></td>
26            <td>
27            </td>
28        </tr>
29        <tr>
30            <td>
31            </td>
32            <td>
33            </td>
34            <td>
35            </td>
36        </tr>
37    </table>
38    <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
39        DataKeyNames="id" DataSourceID="SqlDataSource1" EmptyDataText="没有可显示的数据记录。">
40        <Columns>
41            <asp:BoundField DataField="id" HeaderText="id" ReadOnly="True" SortExpression="id" />
42            <asp:BoundField DataField="name" HeaderText="名称" SortExpression="name" />
43            <asp:BoundField DataField="Corder" HeaderText="排序" SortExpression="Corder" />
44            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
45        </Columns>
46    </asp:GridView>
47    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SperConnectionString1 %>"
48        DeleteCommand="DELETE FROM [area] WHERE [id] = @id" InsertCommand="INSERT INTO [area] ([name], [Corder]) VALUES (@name, @Corder)"
49        ProviderName="<%$ ConnectionStrings:SperConnectionString1.ProviderName %>" SelectCommand="SELECT [id], [name], [Corder] FROM [area]"
50        UpdateCommand="UPDATE [area] SET [name] = @name, [Corder] = @Corder WHERE [id] = @id">
51        <InsertParameters>
52            <asp:Parameter Name="name" Type="String" />
53            <asp:Parameter Name="Corder" Type="Int32" />
54        </InsertParameters>
55        <UpdateParameters>
56            <asp:Parameter Name="name" Type="String" />
57            <asp:Parameter Name="Corder" Type="Int32" />
58            <asp:Parameter Name="id" Type="Int32" />
59        </UpdateParameters>
60        <DeleteParameters>
61            <asp:Parameter Name="id" Type="Int32" />
62        </DeleteParameters>
63    </asp:SqlDataSource>
64</asp:Content>
65
66