我想动态刷新dbgrid数据,代码如下:
try
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('insert into yymc(yymc) values('''+trim(yymc.Text)+''')');
adoquery1.ExecSQL;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from yymc');
adoquery1.Open;
adoquery1.ExecSQL;
DBGRID1.datasource.dataset.close;
DBGRID1.datasource.dataset.open;
//DBGRID1.datasource.dataset.Refresh;
dbgrid1.Refresh;
showmessage('添加成功');
except
showmessage('添加失败');
end;
可是dbgrid没有刷新,请高手解决,谢谢!在线等!!!
try
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('insert into yymc(yymc) values('''+trim(yymc.Text)+''')');
adoquery1.ExecSQL;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from yymc');
adoquery1.Open;
adoquery1.ExecSQL;
DBGRID1.datasource.dataset.close;
DBGRID1.datasource.dataset.open;
//DBGRID1.datasource.dataset.Refresh;
dbgrid1.Refresh;
showmessage('添加成功');
except
showmessage('添加失败');
end;
可是dbgrid没有刷新,请高手解决,谢谢!在线等!!!
adoquery1.clear;
adoquery1.add('select * from yymc where 1<>1');
adoquery1.open;
adoconnection.active:=true;
adoquery1.clear;
adoquery1.add('select * from yymc where 1<>1');
adoquery1.open;