Datasset class and dataadapter class commandbulider class overview

Although dataset can run as a database, it is important that the DataSet object does not directly interact with data or other source data. It aims to enable developers to use consistent programming models without worrying about the resident location of source data. All files from databases, XML files,CodeOr the data you enter can be added to the DataSet object. dataadapter class is used to deal with the data. It includes filling data in dataset or updating the changed database in dataset to the mapped source.

Example:
Dataset DS = new dataset ();
Sqlcommand sel = new sqlcommand ("select * from Table name ');
Dataadapter1.selectcommand = sel;
Dataadapter. Fill (DS, "table alias ")

When updating data in the DataSet object to the database, you can use the commandbuilder class to reduce the encoding volume. It can automatically generate the corresponding update, insert, and delete statements based on the Select language name.