private void lsvHoaDon_SelectedIndexChanged(object sender, EventArgs e) { if (lsvHoaDon.SelectedItems.Count > 0) { txtMaHoaDon.Text = lsvHoaDon.SelectedItems[0].SubItems[0].Text; cbbTenNhanVien.SelectedIndex = cbbTenNhanVien.FindString(lsvHoaDon.SelectedItems[0].SubItems[1].Text); txtMaNV.Text = cbbTenNhanVien.SelectedValue.ToString(); cbbTenKhachHang.SelectedIndex = cbbTenKhachHang.FindString(lsvHoaDon.SelectedItems[0].SubItems[2].Text); txtMaKH.Text = cbbTenKhachHang.SelectedValue.ToString(); txtDiaChi.Text = db.LayGiaTriCuaBang("select diachi from KHACHHANG where makh = '" + txtMaKH.Text + "'"); txtDienThoai.Text = db.LayGiaTriCuaBang("select sodienthoai from KHACHHANG where makh = '" + txtMaKH.Text + "'"); dtpNgayBan.Value = DateTime.Parse(lsvHoaDon.SelectedItems[0].SubItems[3].Text); } }
private void cbbTenSanPham_TextChanged(object sender, EventArgs e) { txtMaSanPham.Text = db.LayGiaTriCuaBang("select masanpham from sanpham where masanpham = '" + cbbTenSanPham.SelectedValue + "'"); txtDonGia.Text = db.LayGiaTriCuaBang("select giaban from sanpham where masanpham = '" + cbbTenSanPham.SelectedValue + "'"); }