procedure TForm1.Edit1Change(Sender: TObject); begin If Trim(Edit1.Text)<>'' then begin with Query1 do begin Close; SQL.Clear; SQL.Text:='Select FieldName from Table where FieldName like :Q'; Parameters.ParamByName('Q').Value:=Trim(Edit1.Text); Open; First; end; ListBox.Items.Clear; while not Query1.Eof do begin ListBox1.Items.Add(Trim(ADOQuery1.FieldByName('FieldByName').AsString)); Query.Next; end; end; end;
自己Add内容进去啦http://lysoft.7u7.net
begin
If Trim(Edit1.Text)<>'' then begin
with Query1 do begin
Close;
SQL.Clear;
SQL.Text:='Select FieldName from Table where FieldName like :Q';
Parameters.ParamByName('Q').Value:=Trim(Edit1.Text);
Open;
First;
end;
ListBox.Items.Clear;
while not Query1.Eof do begin
ListBox1.Items.Add(Trim(ADOQuery1.FieldByName('FieldByName').AsString));
Query.Next;
end;
end;
end;
SINPY问:COMBOBOX好像可以实现,怎么样让combobox的菜单一开始就打开???????????现给出源代码:
unit Unit1;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls;type
TForm1 = class(TForm)
ComboBox1: TComboBox;
procedure FormShow(Sender: TObject);
procedure dropcombobox;
procedure FormPaint(Sender: TObject);
procedure FormCreate(Sender: TObject); private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation{$R *.dfm}var aa:boolean;procedure TForm1.dropcombobox;
var handle:thandle;
begin
handle:=combobox1.Handle ;
if aa then
begin
sendmessage(handle,CB_SHOWDROPDOWN, Longint(true), 0);
aa:=false;
combobox1.Refresh
end;end;procedure TForm1.FormPaint(Sender: TObject);
begin
dropcombobox;
end;procedure TForm1.FormCreate(Sender: TObject);
begin
aa:=true;
end;end.