if ComboBox1.itemIndex =0 then
ADOQuery1.SQL.Text:='select * from hub_netsun.minfo where login ='''+Edit1.text+''''
else
ADOQuery1.SQL.Text:='select * from hub_netsun.minfo where id ='''+Edit1.text+''''; ADOQuery1.Open;
如我这样查询出来的结果要用来listview控件与表格方式显示出来。我写了老是错误。
ADOQuery1.SQL.Text:='select * from hub_netsun.minfo where login ='''+Edit1.text+''''
else
ADOQuery1.SQL.Text:='select * from hub_netsun.minfo where id ='''+Edit1.text+''''; ADOQuery1.Open;
如我这样查询出来的结果要用来listview控件与表格方式显示出来。我写了老是错误。
SubItems.Add(ADOQuery1.FieldByName('login').AsString);
with lsvData.Items.Add do
begin
SubItems.Add(login字段的值);
end;这样写的????
上点你的代码
ADOQuery1.SQL.Text:= 'set names ''gbk''';
ADOQuery1.ExecSQL; ADOQuery1.Close;
ADOQuery1.SQL.Clear;
if ComboBox1.itemIndex =0 then
ADOQuery1.SQL.Text:='select * from hub_netsun.minfo where login ='''+Edit1.text+''''
else
ADOQuery1.SQL.Text:='select * from hub_netsun.minfo where id ='''+Edit1.text+''''; ADOQuery1.Open;
Caption := ADOQuery1.FieldByName('ID').AsString;
SubItems.Add(ADOQuery1.FieldByName('login').AsString);
ADOQuery1.Open;
with lsvData.Items.Add do
begin
Caption := ADOQuery1.FieldByName('ID').AsString;
SubItems.Add(ADOQuery1.FieldByName('login').AsString);
end;这样写最好你还是看看Delphi自带的Demo