BUILDING WEB SOLUTIONS WITH ASP.NET AND ADO.NET（影印版）

Acknowledgments

Introduction

PART I DATA ACCESS AND REPORTING

1 Data Bound .NET Controls

ASP.NET Data Binding

Feasible Data-Binding Sources

Simple Data Binding

Complex Data Binding

The DropDownList Web Control

The CheckBoxList Web Control

The RadioButtonList Web Control

The ListBox Web Control

The Repeater Control

Accessing Data Bound Information

Repeater Control Events

The DataList Control

Templates Specific to DataList

Events Specific to DataList

Relating Graphical and Data Elements

The DataGrid Control

2 Pageable Data Grids

Constituent Items of DataGrid

Column Types

Binding Columns

Bound Columns

Button Columns

Link Columns

Programmatic Binding

Data Pagination

Semi-Automatic Pagination

Properties for Pagination

The Pager Bar

Pagination in Action

Customizing the Pager Bar

Custom Pagination

Sorting Columns

Setting Up Sorting

Auto-Reverse Sorting

Sorting Multiple Fields

Auto-Reverse Sorting for Multiple Columns

Showing Sorting Information

DataGrid Controls and Data Persistence

Scalability? What Was That?

Using the Session Object

Using the Cache Object

Using XML Files

Using Data Readers and Adapters

The Paradox of Pagination

3 Templated DataGrid Controls

Binding Templated Columns

Templated Columns in Action

Concatenating Data Fields

Sorting Templated Columns

Grouping Columns Under a Single Header

Adjusting Column Margins

Customizing Column Headers

Creating Templates Dynamically

Loading Templates from Files

Managing Multiple Views for a Column

Loading Templates from Strings

Implementing ITemplate

Adapting Columns to Data

Showing Boolean Values

Showing Images

Showing Arrays

4 Editing DataGrid Controls

The In-Place Editing Feature

Enabling In-Place Editing

Reading Text from Edited Fields

Updating the Data Source

A Long List of Drawbacks

Editing In Place Using Templates

Working with Template Controls

Adapting Layouts to Data

Adding New Rows

Setting Up the Add-Row Feature

Adding Blank Rows

Switching to Edit Mode

Updating the Table and the Grid

PART II SMART AND EFFECTIVE DATA ACCESS AND REPORTING

5 Code Reusability in ASP.NET

Layers of ASP.NET Pages

From Spaghetti Code to Lasagna Code

Slimmer Pages

The Code-Behind Approach

Enabling Code-Behind

Writing Code-Behind Pages

Visual Inheritance for ASP.NET Pages

Embeddable Web Forms

Writing User Controls

Creating a New DateBox Control

Firing Events

Writing Custom Controls

A Labeled TextBox Control

Using Custom Controls

An Off-the-Shelf DataGrid Control

The UpdateView Event

The SortExpression Property

6 Advanced Data Reporting

Item Selection

Enabling Item Selection

Using the SelectedIndexChanged Event

Selecting Rows Programmatically

Selection and Drill-Down

Filtered Views

Allowing the Selection of Multiple Items

Properties of the SuperGrid Control

Layout of the SuperGrid Control

Retrieving the Selected Items

Selecting by Condition

Changing the Background Color

Evaluating the Condition

Adding an Extra Column

Aggregates and Summary Rows

The Right Way to Query

Creating Relations Between Tables

7 Disconnected Web Applications

What Is the DataSet Object Really For?

Implications for Web Applications

DataSet and the DataGrid Control

Towards Disconnected Applications

Transparent Data Sources

Working with the Cache Object

Loading Data from a Generic Source

Creating Subtables

Batch Updates

Locking Rows

Applying In-Memory Changes

Auto-Increment Fields

Delete and Remove

States of a Row

An Offline Buffer for Data

Loading a DataSet from XML

The DiffGram Format

Submitting Changes

Detecting Changes

Rejecting Changes

Viewing Changes

Generating Commands

Command Builders

Data Conflicts

PART III INTEROPERABILITY

8 Interoperable Web Applications

The COM Interop Services

Using ADO in .NET Applications

The ADODB Assembly

Getting a Recordset

ADO Server Cursors

Migration Issues

Adapting Recordset Objects to DataSet Objects

Loading a Recordset Object into a DataSet Object

Loading a Recordset Object into a DataTable Object

A Common Migration Scenario

From DataSet Objects to ADO Recordset Objects

Serializing DataSet Objects to XML Recordset Objects

XML Schemas for DataSet Objects

The ADO XML Schema

Creating an ADO XML Schema

From .NET Data to XML

XML Object Serialization

Enabling Object Serialization

Serializing to XML

9 Web Services

Dynamic Link Web Libraries

Web Service Specifications

Underlying Technologies

.NET Web Services

The WebService Attribute

Changing the Default Namespace

Defining Web Methods

Under the Hood of .NET Web Services

Invoking .NET Web Services

Creating Proxy Classes

Web Service Implementation

Contract Design

Minimizing Round-Trips

Authentication and Authorization

Managing State

Publishing and Deploying Web Services

Web Service Optimization

Asynchronous Calls

SOAP Extensions

Extreme Optimization

10 Exposing Data to .NET Applications

Exposing Proprietary Data

Using Tailor-Made Classes

The DirectoryListing Class

Creating In-Memory Tables

Using the DirectoryListing Class

Using OLE DB Providers

Inside .NET Data Providers

The Architecture of .NET Data Providers

Implementing a Connection

Implementing a Command

Implementing a Data Reader

Implementing a Data Adapter

Simple vs. Complex Data Providers

Writing a Simple Data Provider

The Table Mapping Mechanism

Filling the DataSet Object

Using the Simple Data Provider

Updating the Data Source

AFTERWORD Some Final Thoughts on the Future of ADO.NET

INDEX