unit1.~pas

来自「列表ADO的属性值,方便程序员进行与数据库的连接时设置各项参数！」· ~PAS 代码 · 共 65 行

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, DB, ADODB,AdoConEd;

type
  TForm1 = class(TForm)
    ListBox: TListBox;
    Connection: TADOConnection;
    Button1: TButton;
    ConnectionString: TEdit;
    Button2: TButton;
    Button3: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
  Connection.Connected:=false;
  if EditConnectionString(Connection) then
  begin
    ConnectionString.Text := Connection.ConnectionString;
  end;

end;

procedure TForm1.Button2Click(Sender: TObject);
begin
    Connection.Connected:=True;
end;

procedure TForm1.Button3Click(Sender: TObject);
var
    I:integer;
    Str:String;
begin
    ListBox.Clear;
    with Connection.ConnectionObject do
    begin
        for I:=0 to Properties.Count-1 do
        begin
            Str:='Name:'+Properties.Item[I].Name+'     Value:'+varToStr(Properties.Item[I].Value);
            ListBox.Items.Add(Str);
        end;
    end;
end;

end.