protected void Page_Load(object sender, EventArgs e)
{
ketnoi = new KetNoiDuLieu(Server.MapPath("App_Data\\"));
if (!IsPostBack)
{
loadDrlMaDoUong();
}
}
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)
{
string path = Server.MapPath("App_Data\\");
ketnoi = new KetNoiDuLieu(path);
if (!IsPostBack)
{
string sql = "select * from danhmuc";
DataTable tbDanhMuc = ketnoi.getBang(sql);
this.Repeater1.DataSource = tbDanhMuc;
this.Repeater1.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();
}
protected void Page_Load(object sender, EventArgs e)
{
string path = Server.MapPath("App_Data\\");
ketnoi = new KetNoiDuLieu(path);
string madouong = Request.QueryString.Get("madouong");
string sql = "select * from douong ";
if (madouong != null)
{
sql += "where madouong = " + madouong;
}
DataTable tbDoUong = ketnoi.getBang(sql);
Repeater2.DataSource = tbDoUong;
Repeater2.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string path = Server.MapPath("App_Data\\");
ketnoi = new KetNoiDuLieu(path);
string sql = "select * from douong ";
string condition = Request.QueryString.Get("madanhmuc");
if (condition != null)
{
sql += "where madanhmuc = " + condition;
}
DataTable tbDoUong = ketnoi.getBang(sql);
DataList1.DataSource = tbDoUong;
DataList1.DataBind();
}
