Code Examples - Microsoft SQL Server
Overview
Since the release of our first ADO.NET data providers in June, 2002, DataDirect Technologies has been fully committed to boosting operational performance in real-world environments such as Microsoft SQL Server.
The material provided here includes code samples that can reduce application development time by providing working C# source code showing typical database access tasks in ADO.NET, using the DataDirect Connect for ADO.NET SQL Server data provider.
To ensure that 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 you include the "using" directive for System.Data and DDTek.SQLServer in your project:
using System.Data; using DDTek.SQLServer;
Code examples demonstrated in this material (click to review complete example):
- Sample Tables
- Creating the Sample Tables Using an ISQL script (code samples and values)
- Creating the Sample Tables using the data provider (code samples and values)
- Retrieving Data Using a DataReader (code sample)
- Using a Local Transaction (code sample)
- Using the Distributed Transaction (code sample)
- Using the CommandBuilder (code sample)
- Updating Data in a DataSet (code sample)
- Calling a Stored Procedure (code sample)
- Creating a Stored Procedure (code sample)
- Executing the stored procedure (code sample)
- Retrieving a Scalar Value (code sample)
- Retrieving Warning Information (code sample)
- Robust ADO.NET Applications with DataDirect Connect for ADO.NET Data Providers
