form41.pas.~10~

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

unit form41;

interface

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

type
    TForm4_1 = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    DataSource1: TDataSource;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBMemo1: TDBMemo;
    DBMemo2: TDBMemo;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    BitBtn1: TBitBtn;
    DBEdit6: TDBEdit;
    Label10: TLabel;
    DBComboBox1: TDBComboBox;
    SimpleDataSet1: TSimpleDataSet;
    DBNavigator2: TDBNavigator;
    procedure DBEdit4Exit(Sender: TObject);
    procedure SimpleDataSet1AfterPost(DataSet: TDataSet);
    procedure SimpleDataSet1BeforeRefresh(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
  Form4_1: TForm4_1;

implementation

uses utData;

{$R *.dfm}

procedure TForm4_1.BitBtn1Click(Sender: TObject);
begin
Close;

end;

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

end;

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

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

procedure TForm4_1.SimpleDataSet1AfterPost(DataSet: TDataSet);
begin
  try
    StrToDate(DBEdit4.Text);
    SimpleDataSet1.ApplyUpdates(0);
  except
    exit;
  end;
  
end;

procedure TForm4_1.DBEdit4Exit(Sender: TObject);
begin
  try
    StrToDate(DBEdit4.Text);
  except
    DBEdit4.Text := '';
  end;
end;

end.