unit1.pas

DELPHI中SQLServer数据库存的控件挺专业呀

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    SQLServerLink1: TSQLServerLink;
    Button1: TButton;
    Button2: TButton;
    ListBox1: TListBox;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
  if SQLServerLink1.SetParam then
    listbox1.Items.Add('连接参数配置成功!')
  else
    listbox1.Items.add('放弃了参数配置或配置不成功!');

end;

procedure TForm1.Button2Click(Sender: TObject);
begin
  case SQLServerLink1.Connect of
    -1: begin
        if application.MessageBox('是否需要重新配置连接参数?', '提示', MB_YESNO + MB_ICONWARNING) = IDYES then
        begin
          Button1.OnClick(Sender);
        end;
      end;
    0: listBox1.Items.Add('数据库连接失败!');
    1: listbox1.Items.Add('数据库连接成功!');
    2: ListBox1.Items.Add('连接处于活动状态!');
  end;
  ListBox1.Selected[listbox1.Count -1];
  listbox1.SetFocus;
end;

end.