Last post Jul 14, 2016 02:58 AM by Chris Zhao
Jul 13, 2016 05:35 AM|Raj4MS|LINK
I have a requirement, where I need to read 100 records at a time and update those 100 records and batch update to database. After 100 records got updated, then read next 100 records, update the records and do batch update into database, all this using ADO.net.
Please let me know how to achieve this.
Jul 14, 2016 02:58 AM|Chris Zhao|LINK
You could use ROW_NUMBER to read records, it returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each
partition. In ADO.NET, you could use DataAdapter to perform a batch update.
Performing Batch Operations Using DataAdapters