default.aspx

完成一个网上书店系统

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" Title="无标题页" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:DataList ID="DataList2" runat="server" DataKeyField="BookID" 
        DataSourceID="SqlDataSource1">
        <ItemTemplate>
            BookPrice:
            <asp:Label ID="BookPriceLabel" runat="server" 
                Text='<%# Eval("BookPrice", "{0:F}") %>' />
            <br />
            BookName:
            <asp:Label ID="BookNameLabel" runat="server" Text='<%# Eval("BookName") %>' />
            <br />
            BookID:
            <asp:Label ID="BookIDLabel" runat="server" Text='<%# Eval("BookID") %>' />
            <br />
            <br />
        </ItemTemplate>
    </asp:DataList>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:BookShopConnectionString %>" 
        DeleteCommand="DELETE FROM [Books] WHERE [BookID] = @BookID" 
        InsertCommand="INSERT INTO [Books] ([BookPrice], [BookName], [BookID]) VALUES (@BookPrice, @BookName, @BookID)" 
        SelectCommand="SELECT [BookPrice], [BookName], [BookID] FROM [Books]" 
        UpdateCommand="UPDATE [Books] SET [BookPrice] = @BookPrice, [BookName] = @BookName WHERE [BookID] = @BookID">
        <DeleteParameters>
            <asp:Parameter Name="BookID" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="BookPrice" Type="Decimal" />
            <asp:Parameter Name="BookName" Type="String" />
            <asp:Parameter Name="BookID" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="BookPrice" Type="Decimal" />
            <asp:Parameter Name="BookName" Type="String" />
            <asp:Parameter Name="BookID" Type="Int32" />
        </InsertParameters>
    </asp:SqlDataSource>
</asp:Content>