Populating a Dataset

Datasets are disconnected from data sources, and to populate them with data, you must use a data adapter. As shown in the EasyAccess example discussed in the In Depth section of this chapter, you can use a data adapter's Fill method to fill a dataset:

DataSet11.Clear()
SqlDataAdapter1.Fill(DataSet11)