Question

delphi dbgrid只显示空白 我检查过ado datasoure 等连接都对的， dbgrid能显示行数，就是不能显示数据

procedure TForm4.RadioButton2Click(Sender: TObject);
var sql:string;

begin
sql:='select admin as 用户, password as 密码, rules as 权限 from a';
if adoquery1.Active then adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add(sql);
try adoquery1.Active:=true;
except on e:Exception do
showmessage(e.Message);
end;
adotable1.Clone(adoquery1,ltunspecified);

dbgrid1.Columns[0].Width:=60;
dbgrid1.Columns[1].Width:=60;
dbgrid1.Columns[2].Width:=60;

end;

Answer 1

双击DBGrid,看下是不是有添加到Columns,有的话全部删除后再试下
或者在Columns的FieldName中填入正确的字段名,你的查询中三个分别是用户,密码和权限

Answer 2

首先确定'select admin as 用户, password as 密码, rules as 权限 from a‘是否返回结果、
再确定DBGrid的datasource是否指向adotable1。

Answer 3

dbgrid1没跟数据源连上，属低级小错误

Answer 4

DBGrid1中属性：datasource是否指向adoquery1；