Table refresh

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
belidzs
Posts: 32
Joined: Wed 30 Sep 2009 12:07

Table refresh

Post by belidzs » Wed 11 Nov 2009 12:56

hi,

is there any built-in function to refresh a datatable? I am currently using close/open sequence, but it changes the position of the current record and also costs a lot of time to load.
I would also need a method which refreshes only one record of a table. RefreshRow is nice to have, but unfortunately it cannot refresh the table if there is another related to it. Now I have to make a change in the table, update the dataset, and use RETURNING values to get the changes from a row. If there is any other viable solution, please let me know!

thanks,
Balazs

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 12 Nov 2009 11:55

Take a look at the PgSqlDataTable.RefreshMode property. It makes refresh of the row
after the insert and/or update is performed.
As for the refreshing of the whole DataTable, Open/Close is an acceptable way.

Post Reply