ADO.NET is so powerful that entire books are dedicated to the different ways to use its capabilities and maximize its performance. This chapter does not attempt to replace those books because there is too much material to cover. This chapter is to be used as a quick reference for looking up various ADO.NET syntax requirements for SQL Server and OLE DB—compliant databases. This chapter covers standard day-to-day database development.

ADO.NET is a complex topic. No matter how much I simpllfy it here, it still takes effort to understand all the different ways to use it. To make the learning process as simple as possible, each section in this chapter is a tutorial that is organized by task. Go to the section header that describes what you want to do, and that section will walk you through each step.1 The tutorial sections in this chapter are as follows:
  • Opening a Connection

  • Calling Stored Procedures and Using SQL Statements

  • Using a Table for Forward-Only Access

  • Reading and Modifying Individual Records

  • Viewing Data with the DataGrid Control


Data Table Database Server Parameter Object Parameter Collection Connection Object 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Brian Bischof 2002

Authors and Affiliations

  • Brian Bischof

There are no affiliations available

Personalised recommendations