public frmKH(frmQLTK frmqltk, QLKhachHang ql)
{
frm = frmqltk;
qlkh = ql;
InitializeComponent();
btnThem.Enabled = true;
}
public void GetKhachHang()
{
string sql = @"server=DESKTOP-3PAL4OL\SQL; database=QLTK ; Integrated Security=true;";
SqlConnection conection = new SqlConnection(sql);
SqlDataReader read;
SqlCommand cmd = conection.CreateCommand();
conection.Open();
cmd.CommandText = "select * from KhachHang";
read = cmd.ExecuteReader();
qlkh = new QLKhachHang();
while (read.Read())
{
KhachHang kh = new KhachHang();
kh.CMND = read.GetValue(0).ToString();
kh.TenKH = read.GetValue(1).ToString();
kh.NgaySinh = read.GetDateTime(2);
kh.DiaChi = read.GetValue(3).ToString();
qlkh.ThemDS(kh);
}
cmd.Dispose();
read.Close();
conection.Close();
}
