What are the benefits of datasets?

Question

I am new to VB.net. I wanted to know if there is a performance gain for connected my datagrid to datasets instead of the sql database directly. What are the benefits of using datasets?

Answer 1

A dataset allows you to return all the data that will be required by the datagrid in one call. This way you won't need to make a round trip to the database every time you need to see something. This works best with drill down datagrids or gridviews. Fewer calls you make the database will allow your application to run smoother and faster. Another way is to have the database return an XML string and use the xmlreader.

Answer 2

A database should be an inter-related set of tables that can be quickly accessed to get the required data, do simple validation checks and to generally display information.

A dataset on the other hand is just a simple form of data storage and retrieval.
If you don't know how to create a database then a dataset or a series of datasets can be a very quick way of storing and retrieving small amounts of data.
A dataset or txt file is also a standard way of getting data from one system to another. You may be required to read a dataset and load the information onto one or more database tables.

Answer 3

It is fun, and you can mark houses, and you can also look at it like a map