protected void Page_Load(object sender, EventArgs e)
    {
        ketnoi = new KetNoiDuLieu();
        DataTable tb  = new DataTable();
        string    sql = "select * from danhmuc";

        tb = ketnoi.getTable(sql);
        rpt_DanhMuc.DataSource = tb;
        rpt_DanhMuc.DataBind();
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        ketnoi = new KetNoiDuLieu();
        string sql       = "select top(10) * from douong ";
        string madanhmuc = Request.QueryString.Get("madanhmuc");

        if (madanhmuc != null)
        {
            sql += " where madanhmuc = " + madanhmuc;
        }
        DataTable tb = ketnoi.getTable(sql);

        dataList.DataSource = tb;
        dataList.DataBind();
    }