public void loadData(string SQL)
{
DataSet ds = XulyDuLieu.getData(SQL);
dataviewKhachHang.DataSource = ds.Tables[0];
dataviewKhachHang.Columns[0].Visible = false;
dataviewKhachHang.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataviewKhachHang.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataviewKhachHang.Columns[3].Visible = false;
dataviewKhachHang.Columns[4].Visible = false;
dataviewKhachHang.Columns[5].Visible = false;
dataviewKhachHang.Columns[6].Visible = false;
dataviewKhachHang.Columns[7].Visible = false;
dataviewKhachHang.Columns[8].Visible = false;
dataviewKhachHang.Columns[9].Visible = false;
}
