The .NET TableAdapter Issues:
The TableAdapter class generates its schema from the first CommandBuilder object created when you specify your initial SELECT query. All other queries created after this initial query must include all of the schema data columns as specified in the original query. The exceptions to this rule are queries that return a SCALAR value.
The TableAdapter loads the data returned by a query into its associated data table or returns new data tables populated with data.
Dataset Adapter and TableAdapter are related in that the TableAdapter encapsulates a DataAdapter object. However, the TableAdapter is a designer created class object and not a bona fide .Net object like the DataAdapter object. TableAdapter inherits from System.Component and cannot be cast to an object of type DataAdapter. The result is an invalid cast exception.
Partial Classes
Partial classes help solve the issues programmers face when filling DataTable objects with results from TableAdapter queries.