예제 #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            DataAccess    MarketBase = new DataAccess();
            SqlConnection conn       = new SqlConnection(MarketBase.SqlBase);

            conn.Open();
            DataTable GetGoods = new DataTable();

            GetGoods            = MarketBase.DisPlayList_Ds("select GName,GId,GBSD from tb_Goods where GTypeId='1' order by GSDate desc", conn);
            HotProDl.DataSource = GetGoods.DefaultView;
            HotProDl.DataBind();
        }
예제 #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            DataAccess    MarketBase = new DataAccess();
            SqlConnection conn       = new SqlConnection(MarketBase.SqlBase);

            conn.Open();
            DataTable GetGoods = new DataTable();

            GetGoods            = MarketBase.DisPlayList_Ds("select GName,GId,GBSD from tb_Goods,tb_UserInfo where tb_Goods.UId=tb_UserInfo.UId and UName='" + Session["UName"].ToString() + "'order by GSDate desc", conn);
            HotProDl.DataSource = GetGoods.DefaultView;
            HotProDl.DataBind();
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        DataAccess    MarketBase = new DataAccess();
        SqlConnection conn       = new SqlConnection(MarketBase.SqlBase);

        conn.Open();
        DataTable GetHotPro = new DataTable();

        GetHotPro           = MarketBase.DisPlayList_Ds("select  top 15 GoodsTitle,goodsid,downcount from goods order by downcount desc", conn);
        HotProDl.DataSource = GetHotPro.DefaultView;
        HotProDl.DataBind();
    }
예제 #4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            DataAccess    MarketBase = new DataAccess();
            SqlConnection conn       = new SqlConnection(MarketBase.SqlBase);

            conn.Open();
            DataTable GetGoods = new DataTable();

            GetGoods            = MarketBase.DisPlayList_Ds("select * from tb_Notice order by Ndate desc", conn);
            HotProDl.DataSource = GetGoods.DefaultView;
            HotProDl.DataBind();
        }