Differences between DataTable and DataSet in C #

You can think of a DataTable and a dataset as a data container, such as when you query a database and get some results that you can put in this container,
Then you may ask: I do not use this kind of container, I read the variables or arrays can also be stored up Ah, why the container?


The reason is that this kind of container is more powerful and can be used in addition to saving data.
Example: In a C/s structure of the desktop database system, you can store the query results in front of the container data display to your client interface,
Users in the interface to add, delete, modify the data, you can update the user's operation to the container, and so on, the user has finished, request updates,
And then you update the container's entire data changes to the central database, what are the benefits? is to reduce the database operation, the client speed increased,
The database pressure is reduced.


A dataset can be likened to an in-memory database, a DataTable is an in-memory data table, and a dataset can store multiple DataTable

Differences between DataTable and DataSet in C #