private void BindToGrid() { NhomSanPham nsp = new NhomSanPham(); DataSet ds = nsp.SelectNhomSanPhamByCuaHangID(CuaHangID); grvNhomSanPham.DataSource = ds.Tables[0]; grvNhomSanPham.DataBind(); }
private void LoadDanhMuc() { try { NhomSanPham nhomsanpham = new NhomSanPham(); DataSet ds = nhomsanpham.SelectNhomSanPhamByCuaHangID(CuaHangID); ds.Tables[0].DefaultView.Sort = "SapXep ASC"; if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["NhomChaID"].ToString() == "" || dr["NhomChaID"].ToString() == "0") { TableRow tr = new TableRow(); TableCell td = new TableCell(); td.CssClass = "leftmenu"; td.Text = "<a href=\"estore.aspx?sid=" + CuaHangID + "&cid=" + dr["NhomSanPhamID"] + "\">" + dr["TenNhomSanPham"] + "</a>"; tr.Cells.Add(td); tblDanhMuc.Rows.Add(tr); ds.Tables[0].DefaultView.RowFilter = "NhomChaID=" + dr["NhomSanPhamID"]; DataView dv = ds.Tables[0].DefaultView; for (int i = 0; i < dv.Count; i++) { TableRow tr1 = new TableRow(); TableCell td1 = new TableCell(); tr1.CssClass = "subleftmenu"; td1.Style.Value = "padding-left:40px"; td1.Text = " <a href=\"estore.aspx?sid=" + CuaHangID + "&cid=" + dv[i]["NhomSanPhamID"] + "\">" + "+ " + dv[i]["TenNhomSanPham"] + "</a>"; tr1.Cells.Add(td1); tblDanhMuc.Rows.Add(tr1); } } } } } catch (Exception ex) { Response.Write(ex.ToString()); } }