Tutorial: IBM DB2 ADO.NET Data Provider Code Examples

NOTE: This page is about data providers that work with the .NET Framework 1.1, see the DataDirect Connect for ADO.NET product page for information about data providers that support .NET Framework 2.0 and higher.

Since the release of our first ADO.NET managed data providers in June, 2002, DataDirect Technologies has been fully committed to boosting operation performance in real-world environments such as DB2.

The material covered here provides code examples that can reduce application development time by providing working C# source code examples showing typical database access tasks in ADO.NET, using the DataDirect Connect for .NET DB2 data provider.

To ensure that these code examples work, you must create the sample tables. In addition, you must modify the connection strings in the examples to work in your environment. Finally, make sure your project includes the "using" directive for System.Data and DDTek.DB2:

Code examples demonstrated in this material (click to review complete example):

• Sample Tables
• Retrieving Data Using a DataReader (code sample)
• Using a Local Transaction (code sample)
• Using the CommandBuilder (code sample)
• Updating Data in a DataSet (code sample)
• Calling a Stored Procedure (code sample)
• Retrieving a Scalar Value (code sample)
• Robust ADO.NET Applications with DataDirect Connect for .NET Data Providers