unit Unit5;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, dbcgrids, DB, ADODB, StdCtrls, ExtCtrls, DBCtrls, ComCtrls,
  Grids, DBGrids;

type
  Tweihu1_F = class(TForm)
    DataSource1: TDataSource;
    ADOTable1: TADOTable;
    ADOQuery1: TADOQuery;
    ADOConnection1: TADOConnection;
    DBGrid1: TDBGrid;
    Panel1: TPanel;
    StatusBar1: TStatusBar;
    DBNavigator1: TDBNavigator;
    RadioGroup1: TRadioGroup;
    StaticText1: TStaticText;
    Edit1: TEdit;
    Button1: TButton;
    Button2: TButton;
    procedure FormCreate(Sender: TObject);
    procedure RadioGroup1Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  weihu1_F: Tweihu1_F;

implementation

uses Weihu_unit;

{$R *.dfm}

procedure Tweihu1_F.FormCreate(Sender: TObject);
begin
  button1.Enabled:=false;
  adoquery1.Open;
end;

procedure Tweihu1_F.RadioGroup1Click(Sender: TObject);
begin
  if RadioGroup1.ItemIndex=0
     then
       begin
          button1.Enabled:=false;
          DBNavigator1.Enabled:=true;
          Datasource1.DataSet:=ADOtable1;
       end
     else
       begin
          button1.Enabled:=true;
          DBNavigator1.Enabled:=false;
          Datasource1.DataSet:=ADOquery1;
          ADOquery1.close;

       end;
end;

procedure Tweihu1_F.Button1Click(Sender: TObject);
var
   sql:string;

begin
   if trim(edit1.Text)='' then
      showmessage('編號不能為空！')
   else
      begin
        sql:='select * from weihu where 編號="'+edit1.Text+'"';
        adoquery1.SQL.Clear;
        adoquery1.SQL.add(sql);
        adoquery1.Open;
        dbgrid1.Refresh;
       end;


end;

procedure Tweihu1_F.Button2Click(Sender: TObject);
begin
  weihu_F.Close;
end;

end.