Extending MFC Applications with the .NET Framework

Working in Batch

There are times when it's advantageous to perform certain operations in batch. For example, multiple read operations can be performed with a single Fill method, thereby causing the generation of more than one local DataTable while incurring the cost of only one round trip between the client and the server. In addition to that, this section will also illustrate how to turn off DataTable constraints so that multiple changes can be made to a DataRow in batch and then either all accepted or canceled with a single method call. Finally, we'll also look at a way to turn index maintenance off to improve the performance associated with loading large amounts of data into a DataTable.

Creating Multiple DataTables in a DataSet

The principal ...