ADO.NET Programming in Visual Basic™ .NET

The DataTable Class

If the DataSet is the heart of ADO .NET, then the DataTable class is the heart of the DataSet. The DataSet object is essentially a collection of DataTable objects. To understand the DataSet is to understand the DataTable. The DataTable class is itself a collection of DataColumn and DataRow objects. The DataColumn class defines the metadata for the DataTable. Each DataColumn object contains properties that define each column in the table. These properties will be the name, data type, size, and other properties that define the column. The DataRow class contains the values of each column by row. The DataRow class is the element of the DataRowCollection. This is a departure from previous versions of ADO where there was a concept ...