文章目錄
- Introduction
- Basic Reporting
- Master/Detail
- Custom Formatting
- Editing, Inserting, and Deleting Data
- Paging and Sorting
- Custom Button Actions
- Displaying Data with the DataList and Repeater
- Filtering Scenarios with the DataList and Repeater
- Editing and Deleting Data Through the DataList
- Paging and Sorting with the DataList and Repeater
- Custom Button Actions with the DataList and Repeater
- Accessing the Database Directly from an ASP.NET Page
- Enhancing the GridView
- Working with Binary Files
- Caching Data
- Database-Driven Site Maps
- Working with Batched Data
- Advanced Data Access Scenarios
Introduction
- Creating a Data Access Layer
- Creating a Business Logic Layer
- Master Pages and Site Navigation
Basic Reporting
- Displaying Data With the ObjectDataSource
- Declarative Parameters
- Programmatically Setting the ObjectDataSource's Parameter Values
Master/Detail
- Master/Detail Filtering With a DropDownList
- Master/Detail Filtering With Two DropDownLists
- Master/Detail Filtering Across Two Pages
- Master/Detail Using a Selectable Master GridView with a Details DetailView
Custom Formatting
- Custom Formatting Based Upon Data
- Using TemplateFields in the GridView Control
- Using TemplateFields in the DetailsView Control
- Using the FormView's Templates
- Displaying Summary Information in the GridView's Footer
Editing, Inserting, and Deleting Data
- An Overview of Inserting, Updating, and Deleting Data
- Examining the Events Associated with Inserting, Updating, and Deleting
- Handling BLL- and DAL-Level Exceptions in an ASP.NET Page
- Adding Validation Controls to the Editing and Inserting Interfaces
- Customizing the Data Modification Interface
- Implementing Optimistic Concurrency
- Adding Client-Side Confirmation When Deleting
- Limiting Data Modification Functionality Based on the User
Paging and Sorting
- Paging and Sorting Report Data
- Efficiently Paging Through Large Amounts of Data
- Sorting Custom Paged Data
- Creating a Customized Sorting User Interface
Custom Button Actions
- Adding and Responding to Buttons to a GridView
Displaying Data with the DataList and Repeater
- Displaying Data with the DataList and Repeater Controls
- Formatting the DataList and Repeater Based Upon Data
- Showing Multiple Records per Row with the DataList Control
- Nested Data Web Controls
Filtering Scenarios with the DataList and Repeater
- Master/Detail Filtering With a DropDownList
- Master/Detail Filtering Across Two Pages
- Master/Detail Using a Bulleted List of Master Records with a Details DataList
Editing and Deleting Data Through the DataList
- An Overview of Editing and Deleting Data in the DataList
- Performing Batch Updates
- Handling BLL- and DAL-Level Exceptions
- Adding Validation Controls to the DataList’s Editing Interface
- Customizing the DataList’s Editing Interface
- Implementing Optimistic Concurrency
- Adding Client-Side Confirmation When Deleting
- Limiting Data Modification Functionality Based on the User
Paging and Sorting with the DataList and Repeater
- Paging Report Data in a DataList or Repeater Control
- Sorting Data in a DataList or Repeater Control
Custom Button Actions with the DataList and Repeater
- Custom Buttons in the DataList and Repeater
Accessing the Database Directly from an ASP.NET Page
- Querying Data with the SqlDataSource Control
- Using Parameterized Queries with the SqlDataSource
- Inserting, Updating, and Deleting Data with the SqlDataSource
- Implementing Optimistic Concurrency with the SqlDataSource
Enhancing the GridView
- Adding a GridView Column of Radio Buttons
- Adding a GridView Column of Checkboxes
- Inserting a New Record from the GridView’s Footer
Working with Binary Files
- Uploading Files
- Displaying Binary Data in the Data Web Controls
- Including a File Upload Option When Adding a New Record
- Updating and Deleting Existing Binary Data
Caching Data
- Caching Data with the ObjectDataSource
- Caching Data in the Architecture
- Caching Data at Application Startup
- Using SQL Cache Dependencies
Database-Driven Site Maps
- Building a Custom Database-Driven Site Map Provider
Working with Batched Data
- Wrapping Database Modifications within a Transaction
- Batch Updating
- Batch Deleting
- Batch Inserting
Advanced Data Access Scenarios
- Creating New Stored Procedures for the Typed DataSet’s TableAdapters
- Using Existing Stored Procedures for the Typed DataSet’s TableAdapters
- Updating the TableAdapter to Use JOINs
- Adding Additional DataTable Columns
- Working with Computed Columns
- Configuring the Data Access Layer’s Connection- and Command-Level Settings
- Protecting Connection Strings and Other Configuration Information
- Debugging Stored Procedures
- Creating Stored Procedures and User-Defined Functions with Managed Code
