void LoadGridView() { DataTable dt = new DataTable(); dt = kn.ExecuteQuery("GetHangMyPhamAdmin", null, null); if (dt != null) { grvHangMyPham.DataSource = dt; grvHangMyPham.DataBind(); } }
void LoadGridView() { DataTable dt = new DataTable(); dt = kn.ExecuteQuery("GetKhachHangAdmin", null, null); if (dt != null) { grvUser.DataSource = dt; grvUser.DataBind(); } }
void LoadGridView() { DataTable dt = new DataTable(); dt = kn.ExecuteQuery("GetGiongLoaiAdmin", null, null); if (dt != null) { grvGiongLoai.DataSource = dt; grvGiongLoai.DataBind(); } }
protected void btnDangNhap_Click(object sender, EventArgs e) { string username = txtUsername.Text.ToString(); string password = txtPassword.Text.ToString(); if (username == "" || password == "") { Response.Write("<script>alert('lỗi đường truyền');</script>"); } else { ketnoi kn = new ketnoi(); DataTable dt = kn.ExecuteQuery("XacThucAdmin", new object[] { username, password }, new List <string> { "@sUserName", "@sPassword" }); if (dt != null && dt.Rows.Count > 0) { Session["admin"] = username; HttpCookie admin = new HttpCookie("AdminInf"); admin.Value = Session["admin"].ToString(); admin.Expires = DateTime.Now.AddDays(1); Response.Cookies.Add(admin); Response.Redirect("QuanLyThuCung.aspx"); } else { Response.Write("<script>alert('Sai tên đăng nhập hoặc mật khẩu');</script>"); txtPassword.Text = ""; } } }
void LoadGridView() { BoundField ID = new BoundField(); ID.HeaderText = "ID"; ID.DataField = "iID"; BoundField TenSP = new BoundField(); TenSP.HeaderText = "Tên sản phẩm"; TenSP.DataField = "sTenMyPham"; BoundField Gia = new BoundField(); Gia.HeaderText = "Giá"; Gia.DataField = "fGia"; BoundField LoaiMyPham = new BoundField(); LoaiMyPham.HeaderText = "Loại Mỹ Phẩm"; LoaiMyPham.DataField = "sTenLoaiMyPham"; BoundField HangMyPham = new BoundField(); HangMyPham.HeaderText = "Hãng mỹ phẩm"; HangMyPham.DataField = "sTenHang"; BoundField GioiTinh = new BoundField(); GioiTinh.HeaderText = "Giới tính"; GioiTinh.DataField = "bGioiTinh"; //BoundField sMoTa = new BoundField(); //ID.HeaderText = "Mô tả"; //ID.DataField = "sMoTa"; ImageField Img = new ImageField(); Img.HeaderText = "Ảnh SP"; Img.DataImageUrlField = "sLinkImg"; Img.DataImageUrlFormatString = "../../img/SanPham/{0}"; CommandField Sua = new CommandField(); Sua.ButtonType = ButtonType.Button; Sua.SelectText = "Sửa"; Sua.ShowSelectButton = true; grv1.Columns.Add(ID); grv1.Columns.Add(TenSP); grv1.Columns.Add(Gia); grv1.Columns.Add(LoaiMyPham); grv1.Columns.Add(HangMyPham); grv1.Columns.Add(GioiTinh); grv1.Columns.Add(Img); grv1.Columns.Add(Sua); grv1.DataKeyNames = new string[] { "iID" }; grv1.DataSource = kn.ExecuteQuery("GetSanPhamAdmin", null, null); grv1.DataBind(); }
void LoadGridView() { BoundField ID = new BoundField(); ID.HeaderText = "ID"; ID.DataField = "iID"; BoundField TenTC = new BoundField(); TenTC.HeaderText = "Tên thú cưng"; TenTC.DataField = "sTenThuCung"; BoundField Gia = new BoundField(); Gia.HeaderText = "Giá"; Gia.DataField = "fGia"; BoundField GiongLoai = new BoundField(); GiongLoai.HeaderText = "Giống loài"; GiongLoai.DataField = "sTenLoai"; BoundField CuaHang = new BoundField(); CuaHang.HeaderText = "Cửa hàng"; CuaHang.DataField = "sTenCuaHang"; BoundField GioiTinh = new BoundField(); GioiTinh.HeaderText = "Giới tính"; GioiTinh.DataField = "bGioiTinh"; //BoundField sMoTa = new BoundField(); //ID.HeaderText = "Mô tả"; //ID.DataField = "sMoTa"; ImageField Img = new ImageField(); Img.HeaderText = "Ảnh SP"; Img.DataImageUrlField = "sLinkImg"; Img.DataImageUrlFormatString = "../../img/ThuCung/{0}"; CommandField Sua = new CommandField(); Sua.ButtonType = ButtonType.Button; Sua.SelectText = "Sửa"; Sua.ShowSelectButton = true; grv1.Columns.Add(ID); grv1.Columns.Add(TenTC); grv1.Columns.Add(Gia); grv1.Columns.Add(GiongLoai); grv1.Columns.Add(CuaHang); grv1.Columns.Add(GioiTinh); grv1.Columns.Add(Img); grv1.Columns.Add(Sua); grv1.DataKeyNames = new string[] { "iID" }; grv1.DataSource = kn.ExecuteQuery("GetThuCungAdmin", null, null); grv1.DataBind(); }