Ceriwis

Ceriwis (https://forum.ceriwis.com/forum.php)
-   Programming (https://forum.ceriwis.com/forumdisplay.php?f=63)
-   -   [ask]menampilkan hasil pencarian di dbgrid delpi gimana ya gan (https://forum.ceriwis.com/showthread.php?t=574572)

Guesuper 20th November 2011 09:36 AM

[ask]menampilkan hasil pencarian di dbgrid delpi gimana ya gan
 
with dm.querygaji do

with dm.datagaji do

begin

sql.Clear;

if rbnip.Checked then

query := 'select * from gaji where nip=: pencarian'

else

if rbnama.Checked then

query := 'select *i from gaji where nama_pegawai =: pencarian'

else

if rbjbtn.Checked then

query := 'select * from gaji where jabatan =: pencarian';

sql.Add(query);

if rbnip.Checked or rbnama.Checked then

parameters.ParamByName('pencarian').Value:=ecari.T ext

else

if rbjbtn.Checked then

parameters.ParamByName('pencarian').Value:=ecari.T ext;

open;

if dm.querygaji.RecordCount = 0 then

messagedlg('Data tidak ada',mtinformation,[MBOK],0);



end;



ada yang bisa benerin script ini gak ya...

agar hasil pencarian nampil di dbgrid dan activrowselect gimana ya gan...

</div>


All times are GMT +7. The time now is 06:44 AM.