1<%...@ Page Language="C#" MasterPageFile="~/admin/MasterPage.master" AutoEventWireup="true" CodeFile="member_group_edit.aspx.cs" Inherits="admin_member_group_edit" Title="Untitled Page" %>
 2<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 3    <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
 4        DataKeyNames="id" DataSourceID="SqlDataSource1" EmptyDataText="没有可显示的数据记录。">
 5        <Columns>
 6            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
 7            <asp:BoundField DataField="id" HeaderText="id" ReadOnly="True" SortExpression="id" />
 8            <asp:BoundField DataField="name" HeaderText="名称" SortExpression="name" />
 9            <asp:BoundField DataField="moneynum" HeaderText="收取资金" SortExpression="moneynum" />
10            <asp:BoundField DataField="gremark" HeaderText="备注" SortExpression="gremark" />
11        </Columns>
12    </asp:GridView>
13    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SperConnectionString1 %>"
14        DeleteCommand="DELETE FROM [member_group] WHERE [id] = @id" InsertCommand="INSERT INTO [member_group] ([name], [moneynum], [gremark]) VALUES (@name, @moneynum, @gremark)"
15        ProviderName="<%$ ConnectionStrings:SperConnectionString1.ProviderName %>" SelectCommand="SELECT [id], [name], [moneynum], [gremark] FROM [member_group]"
16        UpdateCommand="UPDATE [member_group] SET [name] = @name, [moneynum] = @moneynum, [gremark] = @gremark WHERE [id] = @id">
17        <InsertParameters>
18            <asp:Parameter Name="name" Type="String" />
19            <asp:Parameter Name="moneynum" Type="Int32" />
20            <asp:Parameter Name="gremark" Type="String" />
21        </InsertParameters>
22        <UpdateParameters>
23            <asp:Parameter Name="name" Type="String" />
24            <asp:Parameter Name="moneynum" Type="Int32" />
25            <asp:Parameter Name="gremark" Type="String" />
26            <asp:Parameter Name="id" Type="Int32" />
27        </UpdateParameters>
28        <DeleteParameters>
29            <asp:Parameter Name="id" Type="Int32" />
30        </DeleteParameters>
31    </asp:SqlDataSource>
32</asp:Content>
33
34