Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with AdoQuery1 do begin
- Close;
- SQL.Clear;
- SQL.Text:= 'INSERT INTO spp (nis,nama,tanggal_lhr) '+' VALUES (:parNIS, :parNama, :parTanggal_lhr)';
- parameters.ParamByName('parNIS').Value:= Edit1.Text;
- parameters.ParamByName('parNama').Value:= Edit2.Text;
- parameters.ParamByName('parTanggal_lhr').Value:= FormatDateTime('yyyy/mm/dd',DateTimePicker1.Date);
- ExecSQL;
- end;
- with AdoQuery1 do begin
- Close;
- SQL.Clear;
- SQL.Text:='SELECT*FROM spp';
- Open;
- end;
Advertisement
Add Comment
Please, Sign In to add comment