Microsoft® ADO.NET (Core Reference) (PRO-Developer)

Microsoft ActiveX® Data Objects .NET (ADO.NET) is a set of libraries included with the Microsoft .NET Framework that helps you communicate with data from .NET-based applications—including XML data. Discover how to access, sort, and manipulate data in Web-enabled enterprise applications with this book. You’ll get expert guidance and insider tips from a leading database and ADO authority about how to write, test, and debug database code with the tools and wizards in Visual Studio .NET. You’ll also learn about the improved ADO.NET object model, its XML features for Web extensibility, its enhanced integration with Microsoft SQL ServerTM 2000, and more. Topics covered in this guide include: Overview of ADO.NET Building applications with the Data Form Wizard Connecting to your database Querying your database Working with DataAdapters Storing data in DataSets Filtering and searching data in DataSets Working with relational data Submitting updates to your database Advanced updating scenarios Using strongly typed DataSets Interacting with XML data Building effective Windows® database applications Building effective Web database applications INCLUDED ON CD-ROM: A fully searchable electronic copy of the book Sample code in C# and Microsoft Visual Basic® .NET (also available from the link on this page) A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com. Благодарности Введение ЧАСТЬ 1. ОСНОВЫ РАБОТЫ С MICROSOFT ADO.NET Глава 1. Обзор ADO.NET Глава 2. Создание ADO.NET-приложений с помощью мастера DataForm Wizard ЧАСТЬ 2. ПОДКЛЮЧАЕМСЯ: ИСПОЛЬЗОВАНИЕ ПОСТАВЩИКА ДАННЫХ .NET Глава 3. Подключение к базе данных Глава 4. Выполнение запросов к базе данных Глава 5. Получение данных с помощью объектов DataAdapter ЧАСТЬ 3. АВТОНОМНАЯ РАБОТА С ДАННЫМИ: ОБЪЕКТ DATASET МОДЕЛИ ADO.NET Глава 6. Работа с объектами DataSet Глава 7. Работа с реляционными данными Глава 8. Сортировка, поиск, фильтрация Глава 9. Работа с объектами DataSet со строгим контролем типов Глава 10. Передача обновлений в базу данных Глава 11. Сложные случаи обновления данных Глава 12. Работа с XML-данными ЧАСТЬ 4. СОЗДАНИЕ ЭФФЕКТИВНЫХ ПРИЛОЖЕНИЙ С ИСПОЛЬЗОВАНИЕМ ADO.NET Глава 13. Создание эффективных Windows-приложений Глава 14. Создание эффективных Web-приложений ПРИЛОЖЕНИЯ Приложение A. Прочие поставщики данных .NET Приложение Б. Утилиты Предметный указатель Об авторе For every developer who's uttered, "I wish I knew that before I started writing all this code!, " this guide demonstrates how to save time, write less code, and build more powerful, data-driver solutions using Microsoft ActiveX Data Objects. CD contains code samples in VB, along with examples in Visual C++, and Visual J++. Developers who have experience with Microsoft's previous data access technology, ActiveX Data Objects (ADO), might ask, Isn't that what ADO is for?