Three sample projects are included with Adaptive Server ADO.NET Data Provider:
Simple – a sample program that demonstrates how to connect to a database, execute a query, and read resultsets returned.
TableViewer – a sample program that demonstrates how the AseDataAdapter object can be used to bind results to a DataGrid control.
Advanced – a sample program that demonstrates how to call stored procedures with input, output, and inout parameters; read the stored procedure return value; use two supported mechanisms to pass parameters; and use the tracing feature of the provider.
For tutorials explaining the Simple and Table Viewer samples, see Chapter 2, “Using the Sample Applications.”
The pubs2 database, which is required to run Adaptive Server ADO.NET Data Provider samples, is not installed by default with Adaptive Server. See the Adaptive Server Enterprise Installation Guide for instructions on how to install the pubs2 database.