C dataadapter update not updating database

When the SELECT statement used to populate the Data Set returns multiple results, such as a batch SQL statements, if one of the results contains an error, all subsequent results are skipped and not added to the Data Set.

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.Note When handling batch SQL statements that return multiple results, the implementation of Fill Schema for the OLE DB .