Datasets

The dataset is the area in memory that is used to store returned results from database queries. One dataset may contain many sets of results. For this reason, each set of query results must be stored with a unique name.

The data adapter is in charge of placing the returned results into the dataset.

MyDataAdapter.Fill(DataSetName, “QueryResultsName”)

You will notice that when the Fill method of the data adapter is called, two parameters are passed to the method:

1. The name of the dataset to fill.

2. The name that the results will be stored under.