order.aspx.cs

website, 关于网页的, 电子商务方面的一个简单例子....

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);

        //打开连接
        myConnection.Open();

        //读取所有的订单信息
        SqlCommand myCommand = myConnection.CreateCommand();

        //这里是复杂的SQL语句，牵扯到多表查询
        //由于当前页要显示的数据分别分布在三个表中
        //因此必须采取这种联合查询的方法
        //有疑问的读者请参考SQL语言参考资料
        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();

        //此段代码同首页
        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();

    }
}