1<%...@ Page Language="C#"   MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="ad_manage.aspx.cs" Inherits="admin" Title="后台管理"%>
 2
 3<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1"  Runat="Server">
 4 <div style="text-align: center">
 5    <div>
 6     <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
 7         AutoGenerateColumns="False" CellPadding="4" DataKeyNames="编号" DataSourceID="db_manage"
 8         ForeColor="#333333" GridLines="None" Width="760px">
 9         <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
10         <Columns>
11             <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowSelectButton="True" />
12             <asp:BoundField DataField="编号" HeaderText="编号" InsertVisible="False" ReadOnly="True"
13                 SortExpression="编号" >
14                 <ControlStyle Width="100px" />
15             </asp:BoundField>
16             <asp:BoundField DataField="aihao" HeaderText="申报部门" SortExpression="aihao" >
17                 <ControlStyle Width="50px" />
18             </asp:BoundField>
19             <asp:BoundField DataField="youxiang" HeaderText="学校邮箱" SortExpression="youxiang" >
20                 <ControlStyle Width="120px" />
21             </asp:BoundField>
22             <asp:BoundField DataField="mima" HeaderText="密码" SortExpression="mima" >
23                 <ControlStyle Width="50px" />
24             </asp:BoundField>
25             <asp:BoundField DataField="xingming" HeaderText="姓　　名" SortExpression="xingming" >
26                 <ControlStyle Width="50px" />
27             </asp:BoundField>
28             <asp:BoundField DataField="xingbie" HeaderText="性　　别" SortExpression="xingbie" >
29                 <ControlStyle Width="20px" />
30             </asp:BoundField>
31             <asp:BoundField DataField="nianling" HeaderText="专业班级" SortExpression="nianling" >
32                 <ControlStyle Width="70px" />
33             </asp:BoundField>
34             <asp:BoundField DataField="dianhua" HeaderText="联系电话" SortExpression="dianhua" >
35                 <ControlStyle Width="60px" />
36             </asp:BoundField>
37         </Columns>
38         <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
39         <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
40         <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
41         <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
42         <AlternatingRowStyle BackColor="White" />
43     </asp:GridView>
44        &nbsp;</div>
45     <asp:AccessDataSource ID="db_manage" runat="server" ConflictDetection="CompareAllValues"
46         DataFile="~/App_Data/itbm.mdb" DeleteCommand="DELETE FROM [myliuyan] WHERE [编号] = ? "
47         InsertCommand="INSERT INTO [myliuyan] ([编号], [aihao], [youxiang], [mima], [xingming], [xingbie], [nianling], [dianhua], [liuyan]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
48         OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [编号], [aihao], [youxiang], [mima], [xingming], [xingbie], [nianling], [dianhua], [liuyan] FROM [myliuyan]"
49         UpdateCommand="UPDATE [myliuyan] SET [aihao] = ?, [youxiang] = ?, [mima] = ?, [xingming] = ?, [xingbie] = ?, [nianling] = ?, [dianhua] = ?, [liuyan] = ? WHERE [编号] = ? ">
50         <DeleteParameters>
51             <asp:Parameter Name="original_编号" Type="Int32" />
52             <asp:Parameter Name="original_aihao" Type="String" />
53             <asp:Parameter Name="original_youxiang" Type="String" />
54             <asp:Parameter Name="original_mima" Type="String" />
55             <asp:Parameter Name="original_xingming" Type="String" />
56             <asp:Parameter Name="original_xingbie" Type="String" />
57             <asp:Parameter Name="original_nianling" Type="String" />
58             <asp:Parameter Name="original_dianhua" Type="String" />
59             <asp:Parameter Name="original_liuyan" Type="String" />
60         </DeleteParameters>
61         <UpdateParameters>
62             <asp:Parameter Name="aihao" Type="String" />
63             <asp:Parameter Name="youxiang" Type="String" />
64             <asp:Parameter Name="mima" Type="String" />
65             <asp:Parameter Name="xingming" Type="String" />
66             <asp:Parameter Name="xingbie" Type="String" />
67             <asp:Parameter Name="nianling" Type="String" />
68             <asp:Parameter Name="dianhua" Type="String" />
69             <asp:Parameter Name="liuyan" Type="String" />
70             <asp:Parameter Name="original_编号" Type="Int32" />
71             <asp:Parameter Name="original_aihao" Type="String" />
72             <asp:Parameter Name="original_youxiang" Type="String" />
73             <asp:Parameter Name="original_mima" Type="String" />
74             <asp:Parameter Name="original_xingming" Type="String" />
75             <asp:Parameter Name="original_xingbie" Type="String" />
76             <asp:Parameter Name="original_nianling" Type="String" />
77             <asp:Parameter Name="original_dianhua" Type="String" />
78             <asp:Parameter Name="original_liuyan" Type="String" />
79         </UpdateParameters>
80         <InsertParameters>
81             <asp:Parameter Name="编号" Type="Int32" />
82             <asp:Parameter Name="aihao" Type="String" />
83             <asp:Parameter Name="youxiang" Type="String" />
84             <asp:Parameter Name="mima" Type="String" />
85             <asp:Parameter Name="xingming" Type="String" />
86             <asp:Parameter Name="xingbie" Type="String" />
87             <asp:Parameter Name="nianling" Type="String" />
88             <asp:Parameter Name="dianhua" Type="String" />
89             <asp:Parameter Name="liuyan" Type="String" />
90         </InsertParameters>
91     </asp:AccessDataSource>
92     &nbsp;
93            </div>
94</asp:Content>
95  
96