unit1.pas

来自「这是delphi 的入门代码是我们为了一次考试而准备的」· PAS 代码 · 共 59 行

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    ADOConnection1: TADOConnection;
    ADODataSet1: TADODataSet;
    ComboBox1: TComboBox;
    DataSource1: TDataSource;
    ADOTable1: TADOTable;
    DBGrid1: TDBGrid;
    RadioGroup1: TRadioGroup;
    procedure RadioGroup1Click(Sender: TObject);
    procedure ComboBox1Select(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.ComboBox1Select(Sender: TObject);
begin
  {self.ADODataSet1.Close;    //ADODataSet的方法
  self.ADODataSet1.CommandText:='select * from '+trim(combobox1.Text);
  self.ADODataSet1.Open; }
  self.ADOTable1.Active:=false;
  self.ADOTable1.TableName:=trim(combobox1.Text);
  self.ADOTable1.Active:=true;
end;

procedure TForm1.FormCreate(Sender: TObject);
begin
  //combobox1.Clear;
  //self.ADOConnection1.GetTableNames(combobox1.Items);
  ADOConnection1.GetTableNames(RadioGroup1.Items);
end;

procedure TForm1.RadioGroup1Click(Sender: TObject);
begin
  self.ADOTable1.Active:=false;
  self.ADOTable1.TableName:=RadioGroup1.Items.Strings[RadioGroup1.ItemIndex];
  self.ADOTable1.Active:=true;
end;

end.