Summary  
This chapter explains how to use a DataAdapter to execute a query and fill a DataSet with the result, then access the data via DataTable and DataRow objects by casting column values.  

General domain of usage  
Relational database access

### Important Points:
- We can execute a query using a `MySqlDataAdapter` object;
- A `DataSet` object can be filled using the `Fill` method of a `MySqlDataAdapter` object;
- A `DataTable` object represents a table inside a `DataSet`;
- A `DataRow` object represents a row inside a `DataTable`.


What is the correct method of looping through all the rows of a DataTable called `myDataTable`?

This course will give you a solid foundation to begin making applications using .NET in C#. Covering console applications, asynchronous programming, web services, database fundamentals, and ADO.NET CRUD operations, you'll gain practical skills. From creating apps and handling exceptions to optimizing database access, this course ensures a robust understanding of essential .NET development concepts.

This module will give you a solid foundation to begin making applications using .NET in C#. Covering console applications, asynchronous programming, web services, database fundamentals, and ADO.NET CRUD operations, you'll gain practical skills. From creating apps and handling exceptions to optimizing database access, this course ensures a robust understanding of essential .NET development concepts.

DataAdapter & DataSet

Important Points: