Delphi for .NET Developer’s Guide

Chapter 19. Using Command and DataReader Objects

IN THIS CHAPTER

• Executing Commands

• Non-Query Commands

• Retrieving Single Values

• Executing Data Definition Language (DDL) Commands

• Specifying Parameters Using IDbParameter

• Executing Stored Procedures

• Deriving Parameters

• Querying for Resultsets Using DataReaders

• Querying a Resultset

• Querying Multiple Resultsets Using DataReaders

• Using DataReader to Retrieve BLOB Data

• Using DataReader to Retrieve Schema Information

The previous chapter covers how to get connected to a database. This chapter discusses how to query database data in a read-only, high-performance manner. Specifically, it covers the Command and DataReader classes. This chapter uses the Microsoft SQL Provider classes SqlCommand and SqlDataReader, which ...