📄 unit1.pas
字号:
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.
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -