I have a table with two columns in SQL server.
There is an application to update the entries in the table.
The application displays the entries in the table and the user can change any entry at any time.
What is the best method to refresh the backend table?
Since it is an internet application Updating the table on each change is not feasible.
Whether to send the entire data as string to SQL and issue batch update or use Ado Bathupdate?
I havnt tried with Batch updates? If anyone has a good Idea
I would appreciate sharing it.

Thanks
Ramdas