Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

    Start ReadingShareBuy Print Version
    Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition

    • Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition

    • By:

    • Publisher: Microsoft Press

    • Pub. Date:

    • Print ISBN-13: 978-0-7356-2206-7

    • Pages in Print Edition: 864

    • Subscriber Rating: 0 out of 5 rating0 [0 Ratings]

    2ebooken
    Subscriber Reviews • Browse Similar Topics

    Overview

    Get a practical introduction to the Microsoft .NET Framework 2.0 libraries (ADO.NET 2.0) that communicate, access, sort, and interact with data from .NET-connected applications. Includes coverage of XML data and Microsoft SQL Server 2005.

    Subscriber Reviews

    Average Rating: 0 out of 5 rating Based on 0 Ratings

    No Subscribers have provided a review for this book.

    Table of Contents

     

    View Sample

    Programming Microsoft® ADO.NET 2.0 Core Reference

    View Sample

    A Note Regarding Supplemental Files

    View Sample

    Acknowledgments

    View Sample
    Introduction
    View Sample

    Who This Book Is For

    View Sample

    How This Book Is Organized

    View Sample

    System Requirements

    View Sample

    Configuring SQL Server 2005 Express Edition

    View Sample

    Code Samples

    View Sample

    Support for This Book

    View Sample

    I. Getting Started with Microsoft ADO.NET 2.0

    View Sample
    1. Overview of ADO.NET
    View Sample

    No New Object Model?!?

    View Sample

    The ADO.NET Object Model

    View Sample

    Questions That Should Be Asked More Frequently

    View Sample
    2. Building Your First ADO.NET Application with Microsoft Visual Studio 2005
    View Sample

    Everyone Loves a Demo

    View Sample

    Creating Your Data Access Form Without Code

    View Sample

    Questions That Should Be Asked More Frequently

    View Sample

    II. Getting Connected: Using a .NET Data Provider

    View Sample
    3. Connecting to Your Database
    View Sample

    Creating SqlConnection Objects

    View Sample

    Opening SqlConnection Objects

    View Sample

    Closing SqlConnection Objects

    View Sample

    Cleaning Up After Yourself

    View Sample

    Connection Strings

    View Sample

    Connection Pooling

    View Sample

    Using the SqlConnection as a Starting Point

    View Sample

    Visual Studio Design-Time Features

    View Sample

    SqlConnection Object Reference

    View Sample

    Questions That Should Be Asked More Frequently

    View Sample
    4. Querying Your Database
    View Sample

    Using SqlCommand Objects in Code

    View Sample

    Working with the SqlDataReader

    View Sample

    Working with Parameterized Queries

    View Sample

    Microsoft Visual Studio Design-Time Features

    View Sample

    Object Reference for SqlCommand, SqlDataReader, and SqlParameter

    View Sample

    Questions That Should Be Asked More Frequently

    View Sample
    5. Retrieving Data Using SqlDataAdapter Objects
    View Sample

    What Is a SqlDataAdapter Object?

    View Sample

    Creating and Using SqlDataAdapter Objects

    View Sample

    Visual Studio 2005 Design-Time Features

    View Sample

    SqlDataAdapter Reference

    View Sample

    Questions That Should Be Asked More Frequently

    View Sample

    III. Working with Data Offline—The ADO.NET DataSet

    View Sample
    6. Working with DataSet Objects
    View Sample

    Features of the DataSet Class

    View Sample

    Using DataSet Objects

    View Sample

    Working with DataSet Objects in Visual Studio

    View Sample

    DataSet, DataTable, DataColumn, DataRow, UniqueConstraint, and ForeignKeyConstraint Class Reference

    View Sample

    Questions That Should Be Asked More Frequently

    View Sample
    7. Working with Relational Data
    View Sample

    A Brief Overview of Relational Data Access

    View Sample

    Working with DataRelation Objects in Code

    View Sample

    Creating DataRelation Objects in Microsoft Visual Studio

    View Sample

    DataRelation Object Reference

    View Sample

    Questions That Should Be Asked More Frequently

    View Sample
    8. Sorting, Searching, and Filtering
    View Sample

    Using the DataTable Class’s Searching and Filtering Features

    View Sample

    What Is a DataView Object?

    View Sample

    Working with DataView Objects in Code

    View Sample

    Creating DataView Objects in Microsoft Visual Studio

    View Sample

    DataView Object Reference

    View Sample

    Questions That Should Be Asked More Frequently

    View Sample
    9. Working with Strongly Typed DataSet Objects and TableAdapters
    View Sample

    Strongly Typed DataSets

    View Sample

    Creating Strongly Typed DataSet Objects

    View Sample

    Using Strongly Typed DataSet Objects

    View Sample

    When to Use Strongly Typed DataSet Objects

    View Sample

    Introducing TableAdapters

    View Sample

    Choosing Your Path

    View Sample

    Questions That Should Be Asked More Frequently

    View Sample
    10. Submitting Updates to Your Database
    View Sample

    Submitting Updates Using Parameterized SqlCommands

    View Sample

    Submitting Updates Using a SqlDataAdapter

    View Sample

    Using SqlDataAdapter Objects to Submit Updates

    View Sample

    Manually Configuring Your SqlDataAdapter Objects

    View Sample

    Using a SqlCommandBuilder to Generate Updating Logic

    View Sample

    Using the Visual Studio TableAdapter Configuration Wizard to Generate Updating Logic

    View Sample

    Return of the DataAdapters!

    View Sample

    Submitting Updates in SqlTransactions

    View Sample

    SqlCommandBuilder Object Reference

    View Sample

    Questions That Should Be Asked More Frequently

    View Sample
    11. Advanced Updating Scenarios
    View Sample

    Refreshing a Row After Submitting an Update

    View Sample

    Retrieving Newly Generated Auto-Increment Values

    View Sample

    Submitting Hierarchical Changes

    View Sample

    Isolating and Reintegrating Changes

    View Sample

    Handling Failed Update Attempts

    View Sample

    Working with Distributed Transactions

    View Sample

    Batch Queries

    View Sample

    SQL Bulk Copy

    View Sample

    DataSet Objects and Transactions

    View Sample

    When Handling Advanced Updating Scenarios, Use ADO.NET

    View Sample

    Questions That Should Be Asked More Frequently

    View Sample
    12. Working with XML Data
    View Sample

    Bridging the Gap Between XML and Data Access

    View Sample

    Reading and Writing XML Data

    View Sample

    DataSet + XmlDocument = XmlDataDocument

    View Sample

    Using SQL Server 2005’s XML Features

    View Sample

    Retrieving XML Data from SQL Server 2000 via SELECT...FOR XML

    View Sample

    The SQL XML .NET Data Provider

    View Sample

    A Simple ADO.NET and XML Sample

    View Sample

    Questions That Should Be Asked More Frequently

    View Sample

    IV. Building Effective Applications with ADO.NET 2.0

    View Sample
    13. Building Effective Microsoft Windows—Based Applications
    View Sample

    Building a User Interface Quickly by Using Data Binding

    View Sample

    Application Design Considerations

    View Sample

    Questions That Should Be Asked More Frequently

    View Sample
    14. Building Effective Web Applications
    View Sample

    Brief Introduction to Web Applications

    View Sample

    Connecting to Your Database

    View Sample

    Challenges Interacting with Databases in ASP.NET 1.0

    View Sample

    Introducing Data Source Controls

    View Sample

    Caching Data Between Roundtrips

    View Sample

    Paging

    View Sample

    Questions That Should Be Asked More Frequently

    View Sample
    15. SQL Server 2005 Common Language Runtime Integration
    View Sample

    Extending SQL Server the Old Way—Extended Stored Procedures

    View Sample

    Extending SQL Server the New Way—CLR Integration

    View Sample

    Using Microsoft Visual Studio 2005 to Simplify Building SQL CLR Code

    View Sample

    SQL CLR Scenarios

    View Sample

    Creating a SQL CLR User-Defined Type

    View Sample

    Summary

    View Sample

    Questions That Should Be Asked More Frequently

    View Sample

    V. Appendixes

    View Sample
    A. Using Other .NET Data Providers
    View Sample

    The Provider Factory Model

    View Sample

    The ODBC .NET Data Provider

    View Sample

    The OLE DB .NET Data Provider

    View Sample

    The Oracle Client .NET Data Provider

    View Sample
    B. Samples and Tools
    View Sample

    Sample .NET Data Provider—DSP

    View Sample

    ADO.NET Data Explorer

    View Sample

    AdapterSet

    View Sample

    C. About the Author

    View Sample

    Index

    View Sample

    About the Author

    View Sample

    Copyright

    Extras

    The publisher has provided additional content related to this title.


    Description
    Content

    Visit the catalog page for Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition

    • Catalog Page

    Visit the errata page for Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition

    • Errata

    Download the supplemental electronic content for Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition

    • Supplemental Content