Essential ADO.NET

6.4. Data Binding with DataSets

You can bind DataSets and DataTables directly using the DataSource and DataMember fields. When you use DataSet and do not specify a DataMember field, the first DataTable (DataSet.Tables[0]) is used by default. DataSets are preferable to DataReaders when you're using multiple controls to bind to the same data because you need obtain only a single copy of the data. In addition, the DataSet can be retained in memory, typically in an ASP.NET Session variable if it is user-specific, or in an ASP.NET Application variable or the ASP.NET Cache class if it is application-global. If this results in overuse of memory in the ASP.NET worker process, you can persist and retrieve the DataSet from disk in XML format if that is ...