with adoquery1 do
begin
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.text := 'select * from vlist order by vtime';
adoquery1.open;
end;
用的是dbgrid控件!!
begin
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.text := 'select * from vlist order by vtime';
adoquery1.open;
end;
用的是dbgrid控件!!
begin
with adoquery1 do
begin
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.text := 'select * from vlist order by vtime';
adoquery1.open;
end;end;源码是这样的。。
我是通过adotable,adoquery,datasource,绑定dbgird!是通过控件来让数据显示在dbgird,原因是不是出在这里?然后才在form加载时写排序代码。
还要adotable做什么?
估计你的datasource绑定的是adotable而不是adoquery。
看下datasource的DataSet属性连的是哪个。
datasource1.dataset:=adoquery1;
dbgrid1.datasource:=datasource1;procedure TForm1.FormShow(Sender: TObject);
begin
with adoquery1 do
begin
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.text := 'select * from vlist order by vtime';
adoquery1.open;
end; end;
试试
with adoquery1 do
begin
close;
sql.clear;
sql.add('select * from vlist order by vtime');
open;
end;