Data Update

Question: Are modifications to a DataSet or DataTable object automatically updated in the database? If yes, which mechanism is used? If not, how could the user accomplish this task?

Answer: No, updates are not propagated to the data source automatically. An application explicitly has to synchronize the modified data with a database. For this purpose ADO.NET offers the class DataAdapter. The data provider implementations contain specialized subclasses of DataAdapter.