ADO.NET

Tutorial to guide readers through ADO.NET from the top down, showing readers the hows and whys of using ADO.NET with lots of examples they can mold into their own projects right away. Softcover.

Most Web applications follow a simple "3F" pattern: fetch, format, and forward data to the browser. With this in-depth guide, developers can take their Web design and programming skills to the next level to build more complex Web pages, applications, and services. The book demonstrates the advanced data-access capabilities of ADO.NET and the powerful page-creation capabilities of ASP.NET, plus how to employ code reusability, pagelets, code-behind, server-side controls, and other time-saving techniques.

Applied ADO.NET: Building Data-Driven Solutions provides extensive coverage of ADO.NET technology, including ADO.NET internals, namespaces, classes, and interfaces. Whereas most books cover only the SQL and OLE DB data providers, authors Mahesh Chand and David Talbot detail the SQL, OLE DB, and ODBC data providers, as well as the latest additions to ADO.NET, the Oracle, MySQL, and XML .NET data providers. Chand and Talbot also cover the internals of data binding and provide detailed coverage of both Windows Forms and Web Forms data binding and data-bound controls. Because XML plays a major role in .NET development, the authors take a comprehensive look at XML namespaces and classes, and how to integrate both with ADO.NET.

The book begins with the basics of ASP.NET and data-bound controls. It then delves into the internals of data binding and shows how to use DataGrid, DataList, and other data-bound controls in real-world applications. Chand and Talbot also discuss the ASP.NET guest book, database XML Web services, and even an online bookstore site development and design process.

Advanced developers will learn from the coverage of ADO.NET architecture, related design issues, and how ADO.NET data providers are designed. The authors also show how to create a custom data provider. Event handling, server-side programming, data relations and constraints, Active Directory, messaging, exception and error handling, and the object relational model are other topics covered in detail.

ADO.NET is Microsoft's latest data access technology and, as an integral part of the .NET Framework, is far more than simply an upgrade of previous incarnations of ADO. ADO.NET provides an extensive set of .NET classes that facilitate efficient access to data from a large variety of sources, enable sophisticated manipulation and sorting of data, and forms an important framework within which to implement inter-application communication and XML Web Services.

This book provides a comprehensive guide to using ADO.NET, with plenty of practical code examples, extensive technical information, and a detailed case study. Whether you are developing Web Applications using ASP.NET, Windows Forms applications, or XML Web Services, this book will show you how to utilize .NET's data access technology to maximum effect.

This book covers:

ADO.NET and the .NET Framework
Using the .NET Data Providers to create connections and execute commands
Using the DataSet to manipulate data
ADO.NET and XML
Using COM Interoperability
Performance and security issues

Purchase this book and you'll get the free, fully searchable eBook&emdash;a $25 value! (Details are printed inside the book. (Sahil Malik) covers stuff that real developers are confronted with over and over everday. He intentionally focuses on problem areas and how to address them. (And) the absolute best thing about this book is it's readability.

— Bill Ryan, Bill's House O Insomnia

Pro ADO.NET 2.0 is a guide and reference for.NET developers who are looking to further their understanding of ADO.NET 2.0.

This book takes a new approach, focusing on the practical tasks like connecting to the database, retrieving data, and working with transactions, rather than rehashing much of the MSDN documentation. Pro ADO.NET 2.0 offers the deep and much needed practical understanding, viewpoint, and knowledge developers are looking for.

This book explains what is available in ADO.NET by associating it with the need to solve a practical problem and better architect an application, rather than mugging up the hundreds of classes and properties available in the framework.

ADO.NET refers to a set of classes that ship with Visual Studio .NET that allow developers to access data typically stored in relational databases. The purpose of this book is to explain the important features of ADO.NET to corporate developers who use VS .NET. Dan Fox also provides architectural guidance and Best Practices for using ADO.NET in corporate applications. Reference Tables sho how members of ADO.NET classes fit into the bigger picture by denoting why or where the method or property is used. This book is filled with code snippets and code listings in both VB .NET and VC# .NET, sidebars, and mini Case Studies that briefly explore peripheral issues, tips, cautions, and additional resources.

ADO.NET Programming in Visual Basic .NET teaches all you'll need to know to make the most of ADO.NET - whether you're an experienced VB database programmer or not. Its realistic code examples and practical insights illuminate ADO.NET from its foundations to advanced data binding and application optimization. Coverage includes: VB.NET database programming tools, ADO.NET class libraries, data providers, DataSets, DataGrids, and more. Includes detailed Web services coverage, plus a complete case study application.

Comprehensive guide for developers of data ware applications who want to transition to Microsoft's new .NET data access architecture. Presents a thorough explanation of ADO.NET, exploring in depth the capabilities of classes, interfaces, properties, and methods. Softcover.

Current with the .NET Framework 1.1, ADO.NET in a Nutshell offers one place to look when you need help with anything related to this essential technology, including a reference to the ADO.NET namespaces and object model. In addition to being a valuable reference, this book provides a concise foundation for programming with ADO.NET and covers a variety of issues that programmers face when developing web applications or Web Services that rely on database access. Using C#, this book presents real world, practical examples that will help you put ADO.NET to work immediately. Included with the book is a Visual Studio .NET add-in that integrates the entire reference directly into your help files. When combining ADO.NET in a Nutshell with other books from O'Reilly's .NET In a Nutshell library, you'll have a comprehensive, detailed and independent reference collection that will help you become more productive.

ADO.NET revolutionized the way data was accessed through SQL Server, Oracle, and MySQL. With Microsoft's release of ADO.NET 2, ADO and the .NET Framework are integrated with SQL Server for the first time-enabling you to program .NET applications directly within the SQL Server database.

Packed with sample code and recommended best practices for using ADO.NET 2, this code-intensive book explores the new data types that are available in the 2.0 Framework and discusses the appropriate time and way to use them. You'll learn how to make repetitive, mundane tasks much simpler and you'll walk away with a solid foundation for developing database-driven applications.

What you will learn from this book

• The basics of creating a connection, executing a query, and returning a result
• Best uses for Oracle in the ADO.NET Framework
• The many new features that are available for XML
• How to use the full text search capabilities of Microsoft(r) SQL Server 2005
• Methods for retrieving data and presenting it in various ways
• Why MySQL is a viable option for data storage

Who this book is for

This book is for experienced database developers who want to learn the latest release of ADO.NET 2.0. Knowledge of ADO.NET 1.0, general .NET development, and Microsoft SQL Server is necessary.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.