Advertisement
Guest User

Cara Edit dan Delete Data di Database dengan Delphi RAD Meng

a guest
Nov 20th, 2017
464
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Delphi 0.46 KB | None | 0 0
  1. with AdoQuery1 do begin
  2.   Close;
  3.   SQL.Clear;
  4.   SQL.Text:='UPDATE spp SET nama =:parNama , tanggal_lhr=:parTanggal_lhr WHERE nis=:parNIS ';
  5.   parameters.ParamByName('parNIS').Value:= Edit1.Text;
  6.   parameters.ParamByName('parNama').Value:= Edit2.Text;
  7.   parameters.ParamByName('parTanggal_lhr').Value:= FormatDateTime('yyyy/mm/dd',DateTimePicker1.Date);
  8.   ExecSQL;
  9.   end;
  10. with AdoQuery1 do begin
  11.   Close;
  12.   SQL.Clear;
  13.   SQL.Text:='SELECT*FROM spp';
  14.   Open;
  15. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement