products.aspx

这是在visual studio环境下用C sharp语言编写的网上购物系统

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Products.aspx.cs" Inherits="Default3" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
    DataSourceID="SqlDataSource1">
    <Columns>
        <asp:ButtonField CommandName="select" HeaderText="选择" Text="选购" />
        <asp:BoundField DataField="产品ID" HeaderText="产品ID" SortExpression="产品ID" />
        <asp:BoundField DataField="产品名称" HeaderText="产品名称" SortExpression="产品名称" />
        <asp:BoundField DataField="类型ID" HeaderText="类型ID" SortExpression="类型ID" />
        <asp:BoundField DataField="单位数量" HeaderText="单位数量" SortExpression="单位数量" />
        <asp:BoundField DataField="单价" HeaderText="单价" SortExpression="单价" />
    </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:shopConnectionString %>" 
    SelectCommand="SELECT * FROM [products] WHERE ([类型ID] = @类型ID)">
    <SelectParameters>
        <asp:QueryStringParameter Name="类型ID" QueryStringField="类型ID" Type="Int32" />
    </SelectParameters>
</asp:SqlDataSource>
</asp:Content>