private void btnFilter_Click(object sender, EventArgs e)
{
var conn = new Connection().OpenConnection();
var formFilter = new FrmFilter(mhsValue);
var filterValue = formFilter.passFilterValue(formFilter);
if (filterValue != null)
{
string nim = filterValue.Nim;
string nama = filterValue.Nama;
string jk = filterValue.JenisKelamin;
string prodi = filterValue.ProgramStudi;
string wk = filterValue.WaktuKuliah;
string kls = filterValue.Kelas;
SqlCommand cmd = new SqlCommand
(
@"SELECT * FROM TMahasiswa WHERE [Nim] LIKE '" + nim
+ "%' AND [Nama] LIKE '" + nama
+ "%' AND [JenisKelamin] LIKE '" + jk
+ "%' AND [ProgramStudi] LIKE '" + prodi
+ "%' AND [WaktuKuliah] LIKE '" + wk
+ "%' AND [Kelas] LIKE '" + kls + "%' ", conn
);
DataTable dt = new DataTable();
SqlDataReader reader = cmd.ExecuteReader();
dt.Load(reader);
dgvData1.DataSource = dt;
mhsValue.Nim = nim;
mhsValue.Nama = nama;
mhsValue.JenisKelamin = jk;
mhsValue.ProgramStudi = prodi;
mhsValue.WaktuKuliah = wk;
mhsValue.Kelas = kls;
this.lblBanyakRecordData.Text = dgvData1.Rows.Count.ToString() + " Record Data.";
this.lblFilter.Text = $"Nim : {nim} " +
$"Nama : {nama} " +
$"Jenis Kelamin : {jk} " +
$"Program Studi : {prodi} " +
$"Waktu Kuliah : {wk} " +
$"Kelas : {kls}";
}
}
