[DUG] MSSQL DBGrid Refresh

[John Bird]

You could try

    DBGrid.Datasource:=nil;
    DBGrid.Datasource:=ADOTable1;        //this should force a redisplay, as nilling it clears the grid.

Thats a tip I saw in the help for KBMemTable (superset of ClientDataSet) which had all sorts of tips for speeding up loading and displays.   That tip will speed up posting lots of data etc as the DBGrid will not be showing the updates (which also can cause flickering).  Turning it on afterwards shows the current state after all the updates have finished.

John Bird

From: Eric A 
Sent: Tuesday, May 15, 2012 8:51 PM
To: delphi at listserver.123.net.nz 
Subject: [DUG] MSSQL DBGrid Refresh

I am using a DBGrid with an ADOQuery component for display, with modifications to table data (edits, deletes, adds) being done using a ADOTable component.  CRUD operations are done using the table methods rather than raw SQL code.  There's a lot of fields in the database table so coding the operations in SQL would be a pain.

Despite trying to refresh the data in the DBGrid by closing then re-opening both the ADOTable and the ADOQuery component the data in the DBGrid is not updated (unless I exit the application and restart.

I've seen this problem mentioned in various postings but haven't yet seen a solution.  Can someone supply the elusive technique to get the DBGrid data to refresh after the ADOTable data is changed?   

Eric.



--------------------------------------------------------------------------------
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi at listserver.123.net.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-request at listserver.123.net.nz with Subject: unsubscribe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20120516/2c07e2a2/attachment-0001.html