http://www.asp.net/learn/data-access/tutorial-25-cs.aspx
http://static.asp.net/asp.net/files/DataTutorials/datatutorial25cs.pdf
Introduction
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
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
Custom Button Actions with 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
Working with Batched Data
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
SELECT DEPTNO, ROW# FROM DEDBADM.DEPT TB1, TABLE (SELECT COUNT(*) + 1 AS ROW# FROM DEDBADM.DEPT TB2 WHERE TB2.DEPTNO < TB1.DEPTNO) AS TDEPT_TAB
WHERE ROW# BETWEEN 2 AND 4;
