Sams Teach Yourself ADO.NET in 24 Hours (Paperback)

ADO.NET is the data access model built into the .NET Framework. It replaces the old (and largely successful) ADO used in almost all Visual Basic and ASP applications built over the last few years. ADO.NET enables an application to communicate with any OLE database source (including Oracle, Sybase, Microsoft Access, and even text files). This book will present ADO.NET in a simple, easy -to-learn manner filled with many code examples and exercises. A reader with no previous knowledge of ADO.NET should be able to read this book and have a functional knowledge of new object model allowing them to retrieve and work with data from multiple data sources.

Table of Contents

Introduction.
Hour 1. Introducing the Microsoft .NET Framework and ADO.NET.
Hour 2. Working with DataSets and DataTables.
Hour 3. Using T-SQL: A Crash Course.
Hour 4. Adding Relationships to DataSets.
Hour 5. Connecting to a Data Source.
Hour 6. Retrieving Data from the Data Source.
Hour 7. Modifying Database Data.
Hour 8. Using the DataReader and DataAdapter.
Hour 9. Binding Data to List Controls.
Hour 10. Working with XML.
Hour 11. Using the Built-In ASP.NET List Controls.
Hour 12. Formatting ASP.NET List Controls.
Hour 13. Handling ADO.NET Errors.
Hour 14. Managing ADO.NET Concurrency.
Hour 15. Working with Stored Procedures.
Hour 16. ADO Upgrade Concerns.
Hour 17. Using Connection Pooling.
Hour 18. Working with Transactions.
Hour 19. Using Automatically Generated Commands.
Hour 20. Working with Typed DataSets.
Hour 21. Optimizing Data Access Using Tiered Development.
Hour 22. Modifying Data in an N-Tier Application.
Hour 23. Optimizing Data Access.
Hour 24. Transmitting DataSets Using Web Services.
Appendix A. Answers to Quizzes.