How do I refresh a TDBGrid?

delphi delphi-xe7 tdbgrid
BIBD picture BIBD · Feb 19, 2015 · Viewed 11.8k times · Source

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)

Answer

BIBD picture BIBD · Mar 2, 2015

The only code that is needed here is:

myDbGrid.DataSource.DataSet.Refresh;

Everything else is redundant in this particular case.

Related questions

What could cause "No mapping for the Unicode character exists in the target multi-byte code page"?

I have a bug report showing an EEncodingError. The log points to TFile.AppendAllText. I call TFile.AppendAllText is this procedure of mine: procedure WriteToFile(CONST FileName: string; CONST uString: string; CONST WriteOp: WriteOpperation; ForceFolder: Boolean= FALSE); // Works with UNC …

Read More
How to hide (and again show) soft keyboard while TEdit is in focus DELPHI XE7

Can you help me how to hide (and again show) soft keyboard while TEdit is in focus?

Read More
Which is the best way to load a string (HTML code) in TWebBrowser?

I have a string var 'HTMLCode' that contains HTML code. I want to load this code into the browser. This is Embarcadero's code: procedure THTMLEdit.EditText(CONST HTMLCode: string); {VAR Doc: IHTMLDocument2; TempFile: string; } begin TempFile := GetTempFile('.html'); StringToFile(…

Read More