Code Examples

See Code Examples for code examples that illustrate common data access tasks.

A set of compilable code examples is supplied with the Pervasive.SQL data provider. The Visual Basic code examples include sample data and supporting tables.

Using a DataReader on a Select statement

Using a DataAdapter with a DataSet

Using a DataAdapter with a grid

Using the CommandBuilder

Executing a stored procedure with escape sequences to return multiple resultsets

Using a stored procedure with output parameters and without escape sequences

Using local transactions

Using escape sequences such as outer joins