It is the Sql Data Adapter that manages connections with the data source and gives us disconnected behavior.
, the connection to the database was continually maintained, unless explicitly closed. A Data Set is an in-memory data store that can hold numerous tables.Data Sets only hold data and do not interact with a data source.Thus i have my datagridview as student Id , student Name , Update student Id is the primary key and auto increments. But for Update the changes were not reflected in the tables, although the value in the dataset was changing. One way to fill a Data Set with multiple tables is to send the database multiple requests. If you do try to update all the tables with the same Data Adapter, then you will get an error like the one below (this error really frustrated me for a couple hours): An unhandled exception of type 'System.