Sams Teach Yourself Ado.Net in 24 Hours

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.

Jason Lefebvre is vice president and cofounder of Intensity Software (http://www.intensitysoftware.com), a software development company specializing in Microsoft .NET development. Aside from software development, Jason is the coauthor of Pure ASP.NET (Sams Publishing), the code-intensive reference to ASP.NET. In addition, Jason has written numerous articles for nationally known magazines such as Visual C++ Developer¿s Journal, Visual Studio Magazine, and MSDN Magazine.

Paul Bertucci is managing principal and founder of Database Architechs (http://www.dbarchitechs.com), a database consulting firm based in San Francisco, California, and with European offices in Paris, France. He has more than 20 years of experience doing database design, data architecture, data replication, performance and tuning, distributed data systems, data integration, and systems integration for numerous Fortune 500 companies. He has authored numerous articles, standards, and courses such as Sybase¿s "Performance and Tuning" course and "Physical Database Design" course. Paul is a frequent conference speaker and regularly teaches database design, performance and tuning, data modeling, OLAP, Supply Chain Management, and SQL courses. He has worked heavily with .NET, MS SQL Server, Sybase, DB2, and Oracle, and has architected several commercially available tools in the database, data modeling, performance and tuning, and data integration arena. He also was one of the primary authors for Microsoft SQL Server 2000 Unleashed (Sams Publishing). Paul received his formal education in computer science from UC Berkeley. He lives in northern California with his wife, Vilay, and five children (the fifth came right in the middle of writing Chapter 19 of this book¿a boy!). Paul can be reached at pbertucci@dbarchitechs.com and by phone at 925-674-0000.

Introduction

1

(2)

Introducing ADO.NET

3

(10)

Working with DataSets and DataTables

13

(14)

Using T-SQL: A Crash Course

27

(12)

Adding Relationships and Constraints to DataSets

39

(16)

Connecting to a Data Source

55

(10)

Retrieving Data from the Data Source

65

(12)

Modifying Database Data

77

(14)

Using the DataReader and DataAdapter

91

(12)

Binding Data to List Controls

103

(20)

Working with XML

123

(10)

Filtering and Sorting Data

133

(18)

Paging Data

151

(16)

Handling ADO.NET Errors

167

(16)

Managing ADO.NET Concurrency

183

(16)

Working with Stored Procedures

199

(16)

ADO Upgrade Concerns

215

(12)

Using Connection Pooling

227

(12)

Working with Transactions

239

(16)

Using Automatically Generated Commands

255

(12)

Working with Typed Datasets

267

(20)

Optimizing Data Access Using Tiered Development

287

(16)

Modifying Data in an N-Tier Application

303

(16)

Adding Data Access to Existing Web Forms Using Visual Studio .NET

319

(12)

Automatic Data Binding to Windows Forms Using Visual Studio .NET

331

(12)

Appendix A Answers to Quizzes

343

(10)

Index

353

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself Ado.Net in 24 Hours

Summary

Author Biography

Table of Contents

Supplemental Materials