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();
}