procedure TForm1.BitBtn1Click(Sender: TObject); var i :integer; begin i := 1; adoquery1.Close; adoquery1.SQL.Clear; adoquery1.SQL.Add('select * from syscolumns') ; adoquery1.Open; if not adoquery1.IsEmpty then begin with stringgrid1 do begin while adoquery1.Eof do begin stringgrid1.RowCount := i + 1; Cells[0, i] := FieldByName('name').AsString; Cells[1, i] := FieldByName('id').AsString; next; i:=i+1; end; end; end; end; end. 帮我看看这段程序有没有问题,我编译的时候提示是这样的:[Error] Unit1.pas(45): Undeclared identifier: 'FieldByName'
procedure TForm1.BitBtn1Click(Sender: TObject); var i :integer; begin i := 1; adoquery1.Close; adoquery1.SQL.Clear; adoquery1.SQL.Add('select * from syscolumns') ; adoquery1.Open; if not adoquery1.IsEmpty then begin with stringgrid1,adoquery1 do //这里改了 begin while adoquery1.Eof do begin stringgrid1.RowCount := i + 1; Cells[0, i] := FieldByName('name').AsString; Cells[1, i] := FieldByName('id').AsString; next; i:=i+1; end; end; end; end; end.
然后,双击该空间,激活他的连接向导,
最后测试通过后,再添加TADOQuery空间。
设置TADOQuery的Connection为TADOConection
就可以啦!
如果你要用TDbGrid先是数据的话
就要添加一个TDataSource空间连接TADOQuery和TDbGrid
就可以啦!
楼上已经说了用DBGrid显示数据的方法,只要设置正确,那么DBGrid会自动显示相关数据
var
i :integer;
begin
i := 1;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from syscolumns') ;
adoquery1.Open;
if not adoquery1.IsEmpty then
begin
with stringgrid1 do
begin
while adoquery1.Eof do
begin
stringgrid1.RowCount := i + 1;
Cells[0, i] := FieldByName('name').AsString;
Cells[1, i] := FieldByName('id').AsString;
next;
i:=i+1;
end;
end;
end;
end;
end.
帮我看看这段程序有没有问题,我编译的时候提示是这样的:[Error] Unit1.pas(45): Undeclared identifier: 'FieldByName'
Cells[0, i] := adoquery1.FieldByName('name').AsString;
Cells[1, i] := adoquery1.FieldByName('id').AsString;
var
i :integer;
begin
i := 1;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from syscolumns') ;
adoquery1.Open;
if not adoquery1.IsEmpty then
begin
with stringgrid1,adoquery1 do //这里改了
begin
while adoquery1.Eof do
begin
stringgrid1.RowCount := i + 1;
Cells[0, i] := FieldByName('name').AsString;
Cells[1, i] := FieldByName('id').AsString;
next;
i:=i+1;
end;
end;
end;
end;
end.