private void load_khach_dau(string id)
{
KhachThueBUS kt = new KhachThueBUS();
var sqlkt = kt.GetKhachTheoMaPhong("SELECT * FROM ThongTinKhach WHERE MaKhachTro='" + id + "'");
lbHoTen.Text = sqlkt.Rows[0][1] + " " + sqlkt.Rows[0][2];
dtNgaySinh.Text = sqlkt.Rows[0][5].ToString();
lbGioiTinh.Text = sqlkt.Rows[0][3].ToString();
lbCMND.Text = sqlkt.Rows[0][6].ToString();
lbQueQuan.Text = sqlkt.Rows[0][7].ToString();
lbNgheNghiep.Text = sqlkt.Rows[0][8].ToString();
lbMaKhach.Text = sqlkt.Rows[0][0].ToString();
ThongTinThuePhongBUS ttt = new ThongTinThuePhongBUS();
var sqlttt = ttt.GetKhach("SELECT * FROM ThongTinThuePhong WHERE MaKhachTro='" + id + "'");
lbPhong.Text = sqlttt.Rows[0][2].ToString();
dtNgayThue.Text = sqlttt.Rows[0][3].ToString();
tiendatcoc = Convert.ToInt32(sqlttt.Rows[0][4].ToString());
lbTienDatCoc.Text = string.Format("{0:#,##0}", tiendatcoc);
}
