Three sample projects are included with ASE 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; utilize 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 is required to run ASE ADO.NET Data Provider samples. However, the pubs2 database is not installed by default with ASE. See the Adaptive Server Enterprise Installation Guide for instructions on how to install the pubs2 database.