unit1.pas

delphi 自动生成 vb 数据窗体

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    Panel1: TPanel;
    Splitter1: TSplitter;
    Panel2: TPanel;
    Memo1: TMemo;
    Label1: TLabel;
    Edit1: TEdit;
    Button1: TButton;
    Od: TOpenDialog;
    Label2: TLabel;
    ComboBox1: TComboBox;
    Edit2: TEdit;
    Button2: TButton;
    ComboBox2: TComboBox;
    ac: TADOConnection;
    ListBox1: TListBox;
    Button3: TButton;
    ListBox2: TListBox;
    Button4: TButton;
    Table1: TTable;
    Button5: TButton;
    ComboBox3: TComboBox;
    Se: TSession;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;



    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure ComboBox2Change(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);

  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;
   
implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
var SQLServer:Variant;
ServerList:Variant;
i,nServers:integer;

begin
case combobox1.ItemIndex   of
0:od.Filter :='*.mdb|*.mdb';
1:od.Filter:='*.db|*.db';
2:od.Filter:='*.dbf|*.DBF';
else

begin
SQLServer := CreateOleObject('SQLDMO.Application');
ServerList:= SQLServer.ListAvailableSQLServers;
nServers:=ServerList.Count;
for i := 1 to nservers do
comboBox3.Items.Add(ServerList.Item(i));
SQLServer:=NULL;
serverList:=NULL;
end;




end;
od.Execute ;
edit1.Text :=od.FileName ;

end;

procedure TForm1.Button2Click(Sender: TObject);
begin
ac.GetTableNames(combobox2.Items,false );


end;

procedure TForm1.ComboBox2Change(Sender: TObject);
begin
ac.GetFieldNames(combobox2.Text,listbox1.Items );
end;

procedure TForm1.Button3Click(Sender: TObject);
begin

listbox2.Items.Add (listbox1.Items[listbox1.ItemIndex])  ;
listbox1.DeleteSelected ;
end;

procedure TForm1.Button4Click(Sender: TObject);
begin
listbox1.Items.Add(listbox2.Items[listbox2.itemindex]  );
listbox2.DeleteSelected;
end;

procedure TForm1.Button5Click(Sender: TObject);
begin
combobox3.Items.Add(table1.FieldDefs.Items[0].DisplayName );
ac.GetTableNames(listbox2.Items,false);
 
end;

end.