private void btnFilter_Click(object sender, EventArgs e)
{
var frmfilter = new FrmFilter(MhsSent);
var returnvalue = frmfilter.RunAndReturnObjectMahasiswa(frmfilter);
if (returnvalue != null)
{
string nim = returnvalue.Nim;
string nama = returnvalue.Nama;
string jnskelamin = returnvalue.JenisKelamin;
string prgmstudi = returnvalue.ProgramStudi;
string watkul = returnvalue.WaktuKuliah;
string kls = returnvalue.Kelas;
SqlCommand cmd = new SqlCommand(@"Select * from TMahasiswa where [nim] like '" + nim + "%' and [nama] like '" + nama + "%' and [jeniskelamin] like '"
+ jnskelamin + "%' and [programstudi] like '" + prgmstudi + "%' and [waktukuliah] like '" + watkul + "%' and [kelas] like '" + kls + "%' ", conn);
DataTable dt = new DataTable();
conn.Open();
SqlDataReader sdr = cmd.ExecuteReader();
dt.Load(sdr);
conn.Close();
dgvData.DataSource = dt;
lblFilter.Text = $"Nim : {nim}. Nama : {nama}. Jenis Kelamin : {jnskelamin}. Program Studi : {prgmstudi}. Waktu Kuliah : {watkul}. Kelas : {kls}";
MhsSent.Nim = nim;
MhsSent.Nama = nama;
MhsSent.JenisKelamin = jnskelamin;
MhsSent.ProgramStudi = prgmstudi;
MhsSent.WaktuKuliah = watkul;
MhsSent.Kelas = kls;
}
}
