default.aspx.cs

shop sales computer, write asp.net code c#

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 _Default : System.Web.UI.Page
{
    DataSet dataset = new DataSet(); 
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            LoadLapTop();
        }
    }
    void LoadLapTop()
    {
        KetNoiClass kn = new KetNoiClass();
        kn.MoKetNoi();
        dataset = kn.TruyVan("select id_sp,ten_sp,gia,url_hinh,mota_soluoc from sanpham where gia >= 15000000","sanphamcaocap");
        dataset = kn.TruyVan("select id_sp,ten_sp,gia,url_hinh,mota_soluoc  from sanpham where gia <= 15000000 and gia >10000000", "sanphamtrungcap");
        dataset = kn.TruyVan("select id_sp,ten_sp,gia,url_hinh,mota_soluoc  from sanpham where gia <=10000000", "sanphamphothong");
        kn.DongKetNoi();
        DataList1.DataSource = dataset.Tables["sanphamcaocap"];
        DataList1.DataMember = "id_sp";
        DataList1.DataMember = "ten_sp";
        DataList1.DataMember = "gia";
        DataList1.DataMember = "url_hinh";
        DataList1.DataMember = "mota_soluoc";
        DataList1.DataBind();
        DataList2.DataSource=dataset.Tables["sanphamtrungcap"];
        DataList2.DataMember = "id_sp";
        DataList2.DataMember = "ten_sp";
        DataList2.DataMember = "gia";
        DataList2.DataMember = "url_hinh";
        DataList1.DataMember = "mota_soluoc";
        DataList2.DataBind();
        DataList3.DataSource = dataset.Tables["sanphamphothong"];
        DataList3.DataMember = "id_sp";
        DataList3.DataMember = "ten_sp";
        DataList3.DataMember = "gia";
        DataList3.DataMember = "url_hinh";
        DataList1.DataMember = "mota_soluoc";
        DataList3.DataBind();
    }
}