Refresh existing DataTable / DataSet
Posted: Tue 09 Aug 2016 15:58
Hello,
when my application starts I fill a PgSqlDataTable with some information from the database.
Then i navigate throught each record.
How can I refresh a single record at a later point?
Currently i do it like this:
I add an extra DataLink control to the form so the cursor is at the correct position after refreshing.
This also refreshes the whole dataset and not only the current row.
I only need to refresh the current row with live data from the database.
I read that you implemented such a functionality here:
viewtopic.php?t=9769
I also read this thread about QuickRefresh and Refresh:
viewtopic.php?t=23541
However this relates to Delphi. Is there a similiar functionality for dotConnect?
Can you please show me an example on how to update the current row only?
Thanks.
when my application starts I fill a PgSqlDataTable with some information from the database.
Then i navigate throught each record.
How can I refresh a single record at a later point?
Currently i do it like this:
Code: Select all
private void button1_Click_1(object sender, EventArgs e)
{
var oldpos = dataLink1.Position;
ds_actors.Reset();
ds_actors.Fill();
dataLink1.Position = oldpos;
}
This also refreshes the whole dataset and not only the current row.
I only need to refresh the current row with live data from the database.
I read that you implemented such a functionality here:
viewtopic.php?t=9769
I also read this thread about QuickRefresh and Refresh:
viewtopic.php?t=23541
However this relates to Delphi. Is there a similiar functionality for dotConnect?
Can you please show me an example on how to update the current row only?
Thanks.