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