ADO.NET Programming
Arlen Feldman
  • July 2002
  • ISBN 9781930110298
  • 592 pages

ADO.NET Programming covers database programming in .NET and illustrates important steps with nice examples. It shows you how you can achieve effortless separation of data presentation from data access; how to easily go from relational data to XML, and back; how to bind data directly to the Web and Windows Controls; how to write generic access code that talks to multiple databases without change; and much more. Along the way, it illuminates with well-focused examples, points out the "gotchas," and teaches best practices.

Table of Contents show full

Introduction

Acknowledgements

What the Reader Should Know

Part 1 - ADO.NET Overview

1. Microsoft Database Technologies Past and Present

2. ADO.NET From Above

3. XML Aand ADO.NET

4. Setup for Examples

Part 2 - ADO.NET Basics

5. ADO.NET Data Providers

6. Basic Operations with the SQL Server Data Provider

7. Basic Operations with the OLE DB Data Provider

8. Writing Database Independent Code

9. Connection Objects

10. Command Objects

11. DataReader Objects

12. Binding Data

13. Working with Stored Procedures

14. Transactions

15. ADO.NET From the Web (ASP.NET)

Part 3 - The Dataset Class

16. What Are Datasets?

17. Using Datasets

18. The DATATABLE and DATAROW

19. Datarelations and Constraints

20. Custom Dataadapters

21. Querying the Dataset

22. Remoting Datasets

Part 4 - Datasets and Data Bound Controls

23. Data Bound Controls

24. The Datagrid Winform Control

25. The Datagrid Web Control

26. The Datalist Web Control

27. The Repeater Web Control

28. Dataviews

Part 5 - XML in ADO.NET

29. XML and ADO.NET

30. Relational Data as XML

31. XML as Relational Data

32. XPath Queries

33. SQL Server XML Features

Part 6 - Useful Extras

34. Connection Pooling

35. Reading Database Information

36. Prompting for Data Sources

37. Distributed Transactions

About the Technology

ADO.NET, Microsoft's new data access technology, provides all the standard data access capabilities you would expect. It also solves the unique problems associated with disconnected database access needed for robust n-tier and web applications.

What's inside

  • Examples in SQL Server, Oracle and MS Access
  • Disconnected data with the DataSet
  • Moving between relational data and XML
  • Binding data to Window and web controls
  • Benefits of connection pooling
  • Building scalable, multi-tier applications
  • Distributed transactions with COM+
  • Handy references to core classes

About the author

Arlen Feldman, the chief architect for FrontRange Solutions, collaborates with Microsoft on one of the largest .NET applications to date. He lives in Colorado Springs.


eBook $35.99 PDF only

FREE domestic shipping on three or more pBooks