Manipulating Data

The easiest way to manipulate data using ADO.NET is to create a DataTable object containing the result set of a table, query, or stored procedure. Using a DataTable object, you can add, edit, delete, find, and navigate records. The following sections explain how to use DataTable s.

Chapter 14.2.1: Understanding DataTable

The DataTable is populated using the Fill() method of a DataAdapter object. Read more...

Chapter 14.2.2: Creating a DataAdapter

The DataAdapter you'll create will use the connection you've already defined to connect to the data source. Read more...

Chapter 14.2.3: Creating DataTable

You'll create a module-level DataTable in your project. Read more...

Chapter 14.2.4: Referencing Fields in a DataRow

To access a row within the DataTable, you specify the ordinal (index) of that DataRow. Read more...

Chapter 14.2.5: Navigating Records

The ADO.NET DataTable object supports a number of methods that can be used to access its DataRow s. Read more...

Chapter 14.2.6: Editing Records

To edit records in a DataTable, you change the value of a particular column in the desired DataRow. Read more...

Chapter 14.2.7: Creating New Records

To create a new row in the DataTable, you must first call the NewRow() method. Read more...

Chapter 14.2.8: Deleting Records

To delete a record from a DataTable , you call the Delete() method on the DataRow to be deleted. Read more...

Chapter 14.2.9: Running the Database Example

Running the Database Example, press F5 to run the project. Read more...