Use AseDataAdapter to Access and Manipulate Data

Get Data Using the AseDataAdapter Object
The AseDataAdapter allows you to view the entire result set by using the Fill method to fill a DataSet with the results from a query by binding the DataSet to the display grid.
Insert, Update, and Delete Rows Using the AseDataAdapter Object
The AseDataAdapter object retrieves the result set into a DataSet, which is a collection of tables and the relationships and constraints between those tables.
Obtaining AseDataAdapter Schema Information
Get schema information about the result set in the DataSet using the FillSchema method along with the AseDataAdapter.
Bulk-Load Support in Adaptive Server ADO.NET Data Provider
Adaptive Server ADO.NET Data Provider supports bulk-load interface for fast insertions of large sets of rows to Adaptive Server.

Parent topic: Ways to Access and Manipulate Data