Sams Teach Yourself Ado.Net in 24 Hours

by Lefebvre, Jason; Bertucci, Paul

• ISBN13: 9780672323836
• ISBN10: 0672323834
• Edition: 1st
• Format: Paperback
• Copyright: 2002-05-10
• Publisher: Sams Publishing

Summary

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.

Author Biography

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 [e-mail] and by phone at 925-674-0000.

Table of Contents

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