To retrieve schema information for multiple results, use Fill with the Missing Schema Action set to Add With Key. NET Data Set is a memory-resident representation of data that provides a consistent relational programming model independent of the data source.The Data Set represents a complete set of data including tables, constraints, and relationships among the tables.In addition to reducing the load on the data server by reducing the number of active connections, the data server's load was also reduced because activities performed on disconnected data had no impact on the server.In order to transmit changes back to the data source, we used ADO's Update Batch method.Note When handling batch SQL statements that return multiple results, the implementation of Fill Schema for the OLE DB .
Interaction with existing data sources is controlled through the Data Adapter. NET Data Provider includes an Ole Db Data Adapter object and the SQL Server . The Command object is used to submit SQL statements or to execute stored procedures. NET Command object accepts parameters and supports re-executing compiled commands.This had lots of advantages, not the least of which was that we could close our application's connection to the data source and still work with the data.The Fill operation then adds the rows to destination Data Table objects in the Data Set, creating the Data Table objects if they do not already exist.When creating Data Table objects, the Fill operation normally creates only column name metadata.This would free up the connection so that it could be used by other applications, improving our application's scalability.