Log in

View Full Version : [ask]menampilkan hasil pencarian di dbgrid delpi gimana ya gan


Guesuper
20th November 2011, 09:36 AM
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>