form51.pas.~14~

1.大家请将SQLServer2000中的sa用户的密码设定为sa2.将DataBase目录下的数据库附加到SQLSERVER中 应用于出租车车辆管理中的

unit form51;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Mask, DBCtrls, DB, DBTables, Buttons, ExtCtrls, FMTBcd,
  SqlExpr, DBClient, SimpleDS;

type
  TForm5_1 = class(TForm)
    Label1: TLabel;
    GroupBox1: TGroupBox;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    DBEdit7: TDBEdit;
    DBMemo1: TDBMemo;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    BitBtn1: TBitBtn;
    DataSource1: TDataSource;
    SimpleDataSet1: TSimpleDataSet;
    DBNavigator2: TDBNavigator;
    procedure SimpleDataSet1BeforeRefresh(DataSet: TDataSet);
   procedure SimpleDataSet1AfterRefresh(DataSet: TDataSet);
    procedure SimpleDataSet1InternalDataSetBeforeRefresh(DataSet: TDataSet);
    procedure SimpleDataSet1AfterPost(DataSet: TDataSet);  
    procedure BitBtn1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form5_1: TForm5_1;

implementation

uses utData;

{$R *.dfm}

procedure TForm5_1.BitBtn1Click(Sender: TObject);
begin
close;
end;

procedure TForm5_1.FormClose(Sender: TObject; var Action: TCloseAction);
begin
//table1.close;
SimpleDataSet1.Close;
action:=cafree;

end;

procedure TForm5_1.FormShow(Sender: TObject);
begin
//table1.Open;
end;



procedure TForm5_1.SimpleDataSet1AfterPost(DataSet: TDataSet);
begin
   SimpleDataSet1.ApplyUpdates(0);
end;  


procedure TForm5_1.SimpleDataSet1BeforeRefresh(DataSet: TDataSet);
begin
  SimpleDataSet1.ApplyUpdates(0);
end;

end.