?using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class Order : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string orderID = Request["orderid"];

        Response.Write("<img src=\"banner.png\">");
        Response.Write("<BR>");
        Response.Write("<HR>");
        Response.Write("<BR>");
        Response.Write("<BR>");
        Response.Write("<CENTER>");

        //連接字符串
        string connectionString = @"Data Source=WWW-C4074C4DF06\SQLEXPRESS;Initial Catalog=Chap22;Integrated Security=True;Pooling=False";

        //建立連接
        SqlConnection myConnection = new SqlConnection(connectionString);

        //打開(kāi)連接
        myConnection.Open();

        //讀取所有的訂單信息
        SqlCommand myCommand = myConnection.CreateCommand();

        //這里是復(fù)雜的SQL語(yǔ)句，牽扯到多表查詢
        //由于當(dāng)前頁(yè)要顯示的數(shù)據(jù)分別分布在三個(gè)表中
        //因此必須采取這種聯(lián)合查詢的方法
        //有疑問(wèn)的讀者請(qǐng)參考SQL語(yǔ)言參考資料
        string sql = "SELECT T_User.idofuser id,T_Product.productname pname,T_User.username cname,T_User.Phone phone,T_User.Address address FROM T_Order,T_Product,T_User where (T_Order.idofproduct=T_Product.idofproduct and T_Order.idofuser=T_User.idofuser and T_Order.idoforder='" + orderID + "')";
        myCommand.CommandText = sql;
        SqlDataReader myDataReader = myCommand.ExecuteReader();

        //此段代碼同首頁(yè)
        if (myDataReader.HasRows)
        {
            Response.Write("<table border=\"1\" bgcolor=\"#E8E8E8\" bordercolor=\"#0000FF\" bordercolorlight=\"#7D7DFF\" bordercolordark=\"#0000A0\">");
        }
        while (myDataReader.Read())
        {
            Response.Write("<tr>");
            Response.Write("<td>");
            Response.Write(myDataReader["id"].ToString().Trim());
            Response.Write("</td>");
            Response.Write("<td>");
            Response.Write(myDataReader["pname"].ToString().Trim());
            Response.Write("</td>");
            Response.Write("<td>");
            Response.Write(myDataReader["cname"].ToString().Trim());
            Response.Write("</td>");
            Response.Write("<td>");
            Response.Write(myDataReader["phone"].ToString().Trim());
            Response.Write("</td>");
            Response.Write("<td>");
            Response.Write(myDataReader["address"].ToString().Trim());
            Response.Write("</td>");
            Response.Write("</tr>");
        }
        if (myDataReader.HasRows)
        {
            Response.Write("</table>");
        }

        Response.Write("</CENTER>");
        Response.Write("<BR>");
        Response.Write("<BR>");

        myDataReader.Close();
        myConnection.Close();

    }
}