unit2.pas

delphi 自动生成 vb 数据窗体

unit Unit2;

interface

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

type
  TForm2 = class(TForm)



    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
  Form2: TForm2;
   type
    Kj_add =record
       caption:string;
       height:integer;
       left:integer;
       tableindex:integer;
       top:integer;
       width:integer;
    end;
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.