If the incoming data contains unnamed columns, they are placed in the Data Set according to the pattern "Column1", "Column2", and so on.
When multiple result sets are added to the Data Set each result set is placed in a separate table.
However, if the Missing Schema Action property is set to Add With Key, appropriate primary keys, and constraints are also created.
If the data adapter encounters duplicate columns while populating a Data Table, it generates names for the subsequent columns, using the pattern "columnname1", "columnname2", "columnname3", and so on.
In ADO, if we used a client-side Recordset, our data was disconnected from the data source.
To do that, the Data Adapter lets us specify the commands that should be carried out to retrieve and update data.
The connection object associated with the SELECT statement must be valid, but it does not need to be open.Because the Data Set is independent of the data source, a Data Set can include data local to the application, as well as data from multiple data sources. NET Framework has a Data Adapter object: 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 .This would free up the connection so that it could be used by other applications, improving our application's scalability.Disconnected Recordsets also made applications more scalable in other ways.