Sams Teach Yourself ADO.NET in 24 Hours

Paperback
from $0.00

Author: Jason Lefebvre

ISBN-10: 0672323834

ISBN-13: 9780672323836

Category: Applications & Languages - Databases

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...

Search in google:

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.

Introduction1Hour 1Introducing the Microsoft .NET Framework and ADO.NET3Hour 2Working with DataSets and DataTables13Hour 3Using T-SQL: A Crash Course27Hour 4Adding Relationships to DataSets39Hour 5Connecting to a Data Source55Hour 6Retrieving Data from the Data Source65Hour 7Modifying Database Data77Hour 8Using the DataReader and DataAdapter91Hour 9Binding Data to List Controls103Hour 10Working with XML123Hour 11Using the Build-In ASP.NET List Controls133Hour 12Formatting ASP.NET List Controls151Hour 13Handling ADO.NET Errors167Hour 14Managing ADO.NET Concurrency183Hour 15Working with Stored Procedures199Hour 16ADO Upgrade Concerns215Hour 17Using Connection Pooling227Hour 18Working with Transactions239Hour 19Using Automatically Generated Commands255Hour 20Working with Typed DataSets267Hour 21Optimizing Data Access Using Tiered Development287Hour 22Modifying Data in an N-Tier Application303Hour 23Optimizing Data Access319Hour 24Transmitting DataSets Using Web Services331Appendix343