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.
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
KeywordsData Table Database Server Parameter Object Parameter Collection Connection Object
Unable to display preview. Download preview PDF.