private bool Loaddb()
{
A.SetSelect("SELECT `kode_siswa`, `nis`, `namasiswa`, `jeniskelamin`, CONCAT(IF(`tempatlahir`='','-', `tempatlahir`),', ', `tgllahir`) `tll`, `kontak`, `email`, " +
"`alamat`, `ayah`, `ibu`, DATE_FORMAT(`masuk`,'%d-%m-%Y') `masuk`,`angkatan`, `status`, `keterangan` ");
A.SetFrom("FROM `m_siswa` ");
A.SetWhere("WHERE `hapus`='N' ");
Dtp1.GenerateQueriDate(Dtp2, "masuk");
CbAngkatan.GenerateQueriValue("angkatan");
TbCari.GenerateQueriCari(new List <string>()
{
"nis", "namasiswa", "tempatlahir", "kontak", "email", "ayah", "ibu"
});
A.SetQueri(A.GetSelect() + A.GetFrom() + A.GetWhere() + tbhalaman.LimitQ(ldarihalaman, A.GetFrom(), A.GetWhere()) + ";");
Dg.QueriToDg();
return(true);
}
