unit Unit1;
interface
uses
Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
Db, DBTables, ExtCtrls, DBCtrls, Grids, DBGrids, StdCtrls, Mask, Buttons;
type
TForm1 = class(TForm)
DataSource1: TDataSource;
Table1: TTable;
DBGrid1: TDBGrid;
DBNavigator1: TDBNavigator;
Table1NUMARA: TStringField;
Table1ADI: TStringField;
Table1SOYADI: TStringField;
Table1TEL: TStringField;
Table1CEP: TFloatField;
Table1ADRES: TStringField;
BitBtn1: TBitBtn;
DBEdit1: TDBEdit;
DBEdit2: TDBEdit;
DBEdit3: TDBEdit;
DBEdit4: TDBEdit;
DBEdit5: TDBEdit;
DBMemo1: TDBMemo;
Label1: TLabel;
Label2: TLabel;
BitBtn2: TBitBtn;
Edit1: TEdit;
BitBtn3: TBitBtn;
BitBtn4: TBitBtn;
Label3: TLabel;
Label4: TLabel;
Label5: TLabel;
Label6: TLabel;
BitBtn5: TBitBtn;
BitBtn6: TBitBtn;
BitBtn7: TBitBtn;
BitBtn8: TBitBtn;
BitBtn9: TBitBtn;
BitBtn10: TBitBtn;
BitBtn11: TBitBtn;
BitBtn12: TBitBtn;
procedure BitBtn1Click(******: TObject);
procedure BitBtn2Click(******: TObject);
procedure FormCreate(******: TObject);
procedure BitBtn3Click(******: TObject);
procedure BitBtn4Click(******: TObject);
procedure BitBtn5Click(******: TObject);
procedure BitBtn6Click(******: TObject);
procedure BitBtn7Click(******: TObject);
procedure BitBtn8Click(******: TObject);
procedure BitBtn9Click(******: TObject);
procedure BitBtn10Click(******: TObject);
procedure BitBtn11Click(******: TObject);
procedure BitBtn12Click(******: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
Form1: TForm1;
implementation
{$R *.DFM}
procedure TForm1.BitBtn1Click(******: TObject);
begin
Table1NUMARA.Value:=DBEdit1.text;
Table1ADI.Value:= DBEdit2.Text;
Table1SOYADI.Value:=DBEdit3.Text;
Table1TEL.Value:=DBEdit4.text;
Table1CEP.Value:=strtoint(DBEdit5.Text);
Table1ADRES.Value:=DBMemo1.Text;
table1.Post;
BitBtn1.Enabled:=false;
end;
procedure TForm1.BitBtn2Click(******: TObject);
begin
table1.Insert;
BitBtn1.Enabled:=true;
end;
procedure TForm1.FormCreate(******: TObject);
begin
BitBtn1.Enabled:=false;
end;
procedure TForm1.BitBtn3Click(******: TObject);
begin
table1.IndexName:='NUMARA';
table1.FindNearest([edit1.text]);
end;
procedure TForm1.BitBtn4Click(******: TObject);
var
mesaj:integer;
begin
mesaj:=Application.MessageBox('silmek istediginizden emin misiniz?','sil',
MB_YesNo);
if mesaj=mrYes then
begin
Table1.Delete;
showMessage ('kayıt silindi' );
end
else
showMessage('kayit silme islemi iptal edildi');
end;
procedure TForm1.BitBtn5Click(******: TObject);
begin
table1.Refresh;
end;
procedure TForm1.BitBtn6Click(******: TObject);
begin
table1.First;
end;
procedure TForm1.BitBtn7Click(******: TObject);
begin
if not table1.Bof then
table1.Prior
else
showMessage('Zaten ilk kayittasiniz');
end;
procedure TForm1.BitBtn8Click(******: TObject);
begin
if not table1.Eof then
table1.Next
else
showMessage('Zaten sonraki kayittasiniz');
end;
procedure TForm1.BitBtn9Click(******: TObject);
begin
table1.last;
end;
procedure TForm1.BitBtn10Click(******: TObject);
begin
table1.Edit;
end;
procedure TForm1.BitBtn11Click(******: TObject);
begin
table1.cancel;
end;
procedure TForm1.BitBtn12Click(******: TObject);
begin
table1.IndexName:='ADI';
table1.FindNearest([edit1.text]);
end;
end.