udelete.pas

一个简单CUDR例子

unit UDelete;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGrids, DB, StdCtrls;

type
  TFDelete = class(TForm)
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Button1: TButton;
    Button2: TButton;
    Edit1: TEdit;
    procedure Button2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure Button1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FDelete: TFDelete;

implementation

uses UDataMDL;

{$R *.dfm}

procedure TFDelete.Button2Click(Sender: TObject);
begin
close;
end;

procedure TFDelete.FormCreate(Sender: TObject);
 var
  sql:string;
begin
   sql:='select * from users';
   DataMDL.ADOQuery.Close;
   DataMDL.ADOQuery.SQL.Clear;
   DataMDL.ADOQuery.SQL.Add(sql);
   DataMDL.ADOQuery.Open;
   DataMDL.ADOQuery.Active:=true;
end;
procedure TFDelete.DBGrid1CellClick(Column: TColumn);
begin
    edit1.Text:=dbgrid1.Fields[0].AsString;
end;

procedure TFDelete.Button1Click(Sender: TObject);
  var
  str,ssql:string;
begin
    if Application.MessageBox('确认要删除此条记录吗','提示',mb_YesNo)=ID_Yes then
      begin
       ssql:='delete from users where id='''+edit1.Text+'''';
       with DataMDL.ADOQuery do
         begin
           close;
           sql.Clear;
           sql.Add(sSQL);
           ExecSQL;
         end;
       Application.MessageBox('删除成功','提示',MB_OK);
      end
    else
       exit;
   str:='select * from users';
   DataMDL.ADOQuery.Close;
   DataMDL.ADOQuery.SQL.Clear;
   DataMDL.ADOQuery.SQL.Add(str);
   DataMDL.ADOQuery.Open;
end;

procedure TFDelete.FormClose(Sender: TObject; var Action: TCloseAction);
begin
   Action:=cafree;
end;

end.