How do I refresh a TDBGrid?

Question

I have a TDBGrid called myDbGrid that I want to update after a change to the database (insert/update/delete). How can I do this without reloading my form completely?

myDbGrid uses myDataSource and it uses myQry as its data set.

I've tried the following with no success:

myDbGrid.Refresh;

and

myDbGrid.DataSource.DataSet.Close;
myQry.Close; // '' I think this is redundant
myQry.Open;
myDbGrid.DataSource.DataSet.Refresh;

What have I missed?

(I'll note that the database change is not happening in the tDBGrid - it's there for display only)

Calling just `myDbGrid.DataSource.DataSet.Refresh;` should do that. `myDbGrid.Refresh;` forces the grid to repaint. — TLama, Feb 19 '15 at 16:33
Maybe the transaction in the database is not being commited? — Guillem Vicens, Feb 19 '15 at 16:57
Bone-headed move.... I was refreshing *before* I did my database change and I couldn't see the forest for the trees. I'd close it, but since the next best Google result for my question is from E-E.com I'll leave it open for the next person. If TLama wants to post their comment as an answer, I'll mark it as accepted right away. Thanks for the help. — BIBD, Feb 19 '15 at 18:23

score 11 · Accepted Answer · answered Mar 02 '15 at 14:51

11

The only code that is needed here is:

myDbGrid.DataSource.DataSet.Refresh;

Everything else is redundant in this particular case.

answered Mar 02 '15 at 14:51

BIBD

15,107
25
85
137

What if the changes have not been committed to the database? – WeststarEric Jan 06 '21 at 17:52

score 0 · Answer 2 · edited Sep 21 '18 at 08:57

0

You can try this code:

ADOQuery.SQL.Clear;
ADOQuery.SQL.Add('select* from table_name');
ADOQuery.Open;

edited Sep 21 '18 at 08:57

Mickael Maison

25,067
7
71
68

answered Sep 21 '18 at 08:50

Eko Salvinus

1

score 0 · Answer 3 · answered Aug 11 '21 at 17:56

0

I'm using ADOQuery, so I did:

ADOQuery1.Active := False;
ADOQuery1.Active := True;

answered Aug 11 '21 at 17:56

Wellington Telles Cunha

326
2
16

How do I refresh a TDBGrid?

3 Answers3