shop_default.aspx.cs

基于VS05和SQL05做的一个电子商务网站

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 shop_Default : System.Web.UI.Page
{
    public SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnStr"]);

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //绑定 分类列表
            String sql = "SELECT * FROM PType where parentId=0";
            SqlCommand command = new SqlCommand(sql, conn);
            conn.Open();
            SqlDataReader dr = command.ExecuteReader();
            Repeater1.DataSource = dr;
            Repeater1.DataBind();
            dr.Close();
            conn.Close();
            //绑定 新进店铺列表
            String mysql = "SELECT top 15 * FROM DianPuDetail order by DianPuTime desc";
            SqlCommand mycommand = new SqlCommand(mysql, conn);
            conn.Open();
            SqlDataReader mydr = mycommand.ExecuteReader();
            Repeater2.DataSource = mydr;
            Repeater2.DataBind();
            dr.Close();
            conn.Close();
        }
    }

}