当前文件路径：XiaoFanWeb/admin/product_admin.aspx

		            
 1<%...@ Page Language="C#" MasterPageFile="~/admin/admin.master" AutoEventWireup="true" CodeFile="product_admin.aspx.cs" Inherits="admin_product_admin" Title="Untitled Page" %>
 2<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
 3</asp:Content>
 4<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 5    <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/dbs.mdb"
 6        DeleteCommand="DELETE FROM [FZ_Product] WHERE [Id] = ?" InsertCommand="INSERT INTO [FZ_Product] ([Id], [Name], [Tid], [Info], [Hit], [Img], [addtime]) VALUES (?, ?, ?, ?, ?, ?, ?)"
 7        SelectCommand="SELECT * FROM [FZ_Product] ORDER BY [addtime] DESC, [Id] DESC"
 8        UpdateCommand="UPDATE [FZ_Product] SET [Name] = ?, [Tid] = ?, [Info] = ?, [Hit] = ?, [Img] = ?, [addtime] = ? WHERE [Id] = ?">
 9        <DeleteParameters>
10            <asp:Parameter Name="Id" Type="Int32" />
11        </DeleteParameters>
12        <UpdateParameters>
13            <asp:Parameter Name="Name" Type="String" />
14            <asp:Parameter Name="Tid" Type="Int32" />
15            <asp:Parameter Name="Info" Type="String" />
16            <asp:Parameter Name="Hit" Type="Int32" />
17            <asp:Parameter Name="Img" Type="String" />
18            <asp:Parameter Name="addtime" Type="DateTime" />
19            <asp:Parameter Name="Id" Type="Int32" />
20        </UpdateParameters>
21        <InsertParameters>
22            <asp:Parameter Name="Id" Type="Int32" />
23            <asp:Parameter Name="Name" Type="String" />
24            <asp:Parameter Name="Tid" Type="Int32" />
25            <asp:Parameter Name="Info" Type="String" />
26            <asp:Parameter Name="Hit" Type="Int32" />
27            <asp:Parameter Name="Img" Type="String" />
28            <asp:Parameter Name="addtime" Type="DateTime" />
29        </InsertParameters>
30    </asp:AccessDataSource>
31    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
32        AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="AccessDataSource1"
33        Width="650px">
34        <Columns>
35            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
36            <asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True"
37                SortExpression="Id" />
38            <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
39            <asp:TemplateField HeaderText="Tid" SortExpression="Tid">
40                <EditItemTemplate>
41                    <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Tid") %>' Width="20px"></asp:TextBox>
42                </EditItemTemplate>
43                <ItemTemplate>
44                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("Tid") %>'></asp:Label>
45                </ItemTemplate>
46            </asp:TemplateField>
47            <asp:TemplateField HeaderText="Hit" SortExpression="Hit">
48                <EditItemTemplate>
49                    <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("Hit") %>' Width="40px"></asp:TextBox>
50                </EditItemTemplate>
51                <ItemTemplate>
52                    <asp:Label ID="Label3" runat="server" Text='<%# Bind("Hit") %>'></asp:Label>
53                </ItemTemplate>
54            </asp:TemplateField>
55            <asp:BoundField DataField="Img" HeaderText="Img" SortExpression="Img" />
56            <asp:TemplateField HeaderText="addtime" SortExpression="addtime">
57                <EditItemTemplate>
58                    <asp:TextBox ID="TextBox1" runat="server" Enabled="False" Text='<%# Bind("addtime") %>'
59                        Width="130px"></asp:TextBox>
60                </EditItemTemplate>
61                <ItemTemplate>
62                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("addtime") %>'></asp:Label>
63                </ItemTemplate>
64            </asp:TemplateField>
65        </Columns>
66    </asp:GridView>
67</asp:Content>
68
69