?using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //連接字符串
        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();
        string sql = "SELECT * FROM T_Product";
        myCommand.CommandText = sql;
        SqlDataReader myDataReader = myCommand.ExecuteReader();

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

        //輸出表格格式以及商品信息
        if (myDataReader.HasRows)
        {
            Response.Write("<CENTER>");
            Response.Write("商品列表");
            Response.Write("<table border=\"1\" bgcolor=\"#E8E8E8\" bordercolor=\"#0000FF\" bordercolorlight=\"#7D7DFF\" bordercolordark=\"#0000A0\">");
        }
        while (myDataReader.Read())
        {
            Response.Write("<tr>");
            Response.Write("<td>");
            Response.Write("<a href=\"User.aspx?idofproduct=" + myDataReader["idofproduct"].ToString().Trim() + "\">購買</a>");
            Response.Write("</td>");
            Response.Write("<td>");
            Response.Write(myDataReader["idofproduct"].ToString().Trim());
            Response.Write("</td>");
            Response.Write("<td>");
            Response.Write(myDataReader["productname"].ToString().Trim());
            Response.Write("</td>");
            Response.Write("<td>");
            Response.Write(myDataReader["price"].ToString().Trim());
            Response.Write("</td>");
            Response.Write("<td>");
            Response.Write(myDataReader["sdesc"].ToString().Trim());
            Response.Write("</td>");
            Response.Write("<td>");
            Response.Write(myDataReader["ldesc"].ToString().Trim());
            Response.Write("</td>");
            Response.Write("</tr>");
        }
        if (myDataReader.HasRows)
        {
            Response.Write("</table>");
        }

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

        Response.Write("<HR>");
        Response.Write("我的電子商店");
        Response.Write("<BR>");
        Response.Write(DateTime.Now.ToString());
        Response.Write("</CENTER>");

    }
}