orderlist.aspx

天织在线购物网站完整源码及文档 本网站是一套基于Web2.0思想设计、采用asp.net2.0开发的社区门户产品。它同时也是一套Web2.0全面解决方案

<%@ Page Language="C#" MasterPageFile="~/AppMaster.master" AutoEventWireup="true" CodeFile="OrderList.aspx.cs" Inherits="OrderList" Title="订单列表" %>
<asp:Content ID="Content2" ContentPlaceHolderID="phMain" Runat="Server">
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"
        Style="position: static">
        <Columns>
            <asp:BoundField DataField="OID" HeaderText="订单号" InsertVisible="False" SortExpression="OID" />
            <asp:BoundField DataField="OTotalPrice" HeaderText="总价格" SortExpression="OTotalPrice" />
            <asp:BoundField DataField="OTotalNumber" HeaderText="总数量" SortExpression="OTotalNumber" />
            <asp:BoundField DataField="OData" HeaderText="日期" SortExpression="OData" />
            <asp:HyperLinkField DataNavigateUrlFields="OID" DataNavigateUrlFormatString="sucess.aspx?OID={0}"
                Text="查看" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TZroomConnectionString %>"
        SelectCommand="SELECT [OID], [OTotalPrice], [OTotalNumber], [OData] FROM [OrderUser] WHERE [CID] = (select UID from U_Info where UserName=@CID)">
        <SelectParameters>
            <asp:SessionParameter Name="CID" SessionField="name" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
</asp:Content>