Older Versions - Data Access

How to perform a variety of data-related tasks using ASP.NET Web Forms data controls.

• Introduction

  • Creating a Data Access Layer (C#)
  • Creating a Business Logic Layer (C#)
  • Master Pages and Site Navigation (C#)
  • Creating a Data Access Layer (VB)
  • Creating a Business Logic Layer (VB)
  • Master Pages and Site Navigation (VB)

• Basic Reporting

  • Displaying Data With the ObjectDataSource (C#)
  • Declarative Parameters (C#)
  • Programmatically Setting the ObjectDataSource's Parameter Values (C#)
  • Displaying Data With the ObjectDataSource (VB)
  • Declarative Parameters (VB)
  • Programmatically Setting the ObjectDataSource's Parameter Values (VB)

• Master/Detail

  • Master/Detail Filtering With a DropDownList (C#)
  • Master/Detail Filtering With Two DropDownLists (C#)
  • Master/Detail Filtering Across Two Pages (C#)
  • Master/Detail Using a Selectable Master GridView with a Details DetailView (C#)
  • Master/Detail Filtering With a DropDownList (VB)
  • Master/Detail Filtering With Two DropDownLists (VB)
  • Master/Detail Filtering Across Two Pages (VB)
  • Master/Detail Using a Selectable Master GridView with a Details DetailView (VB)

• Custom Formatting

  • Custom Formatting Based Upon Data (C#)
  • Using TemplateFields in the GridView Control (C#)
  • Using TemplateFields in the DetailsView Control (C#)
  • FormView's Templates (C#)
  • Displaying Summary Information in the GridView's Footer (C#)
  • Custom Formatting Based Upon Data (VB)
  • Using TemplateFields in the GridView Control (VB)
  • Using TemplateFields in the DetailsView Control (VB)
  • FormView's Templates (VB)
  • Displaying Summary Information in the GridView's Footer (VB)

• Editing, Inserting, and Deleting Data

  • Overview of Inserting, Updating, and Deleting Data (C#)
  • Examining the Events Associated with Inserting, Updating, and Deleting (C#)
  • Handling BLL- and DAL-Level Exceptions in an ASP.NET Page (C#)
  • Adding Validation Controls to the Editing and Inserting Interfaces (C#)
  • Customizing the Data Modification Interface (C#)
  • Implementing Optimistic Concurrency (C#)
  • Adding Client-Side Confirmation When Deleting (C#)
  • Limiting Data Modification Functionality Based on the User (C#)
  • Overview of Inserting, Updating, and Deleting Data (VB)
  • Examining the Events Associated with Inserting, Updating, and Deleting (VB)
  • Handling BLL- and DAL-Level Exceptions in an ASP.NET Page (VB)
  • Adding Validation Controls to the Editing and Inserting Interfaces (VB)
  • Customizing the Data Modification Interface (VB)
  • Implementing Optimistic Concurrency (VB)
  • Adding Client-Side Confirmation When Deleting (VB)
  • Limiting Data Modification Functionality Based on the User (VB)

• Paging and Sorting

  • Paging and Sorting Report Data (C#)
  • Efficiently Paging Through Large Amounts of Data (C#)
  • Sorting Custom Paged Data (C#)
  • Creating a Customized Sorting User Interface (C#)
  • Paging and Sorting Report Data (VB)
  • Efficiently Paging Through Large Amounts of Data (VB)
  • Sorting Custom Paged Data (VB)
  • Creating a Customized Sorting User Interface (VB)

• Custom Button Actions

  • Adding and Responding to Buttons to a GridView (C#)
  • Adding and Responding to Buttons to a GridView (VB)

• Displaying Data with the DataList and Repeater

  • Displaying Data with the DataList and Repeater Controls (C#)
  • Formatting the DataList and Repeater Based Upon Data (C#)
  • Showing Multiple Records per Row with the DataList Control (C#)
  • Nested Data Web Controls (C#)
  • Displaying Data with the DataList and Repeater Controls (VB)
  • Formatting the DataList and Repeater Based Upon Data (VB)
  • Showing Multiple Records per Row with the DataList Control (VB)
  • Nested Data Web Controls (VB)

• Filtering Scenarios with the DataList and Repeater

  • Master/Detail Filtering With a DropDownList (C#)
  • Master/Detail Filtering Across Two Pages (C#)
  • Master/Detail Using a Bulleted List of Master Records with a Details DataList (C#)
  • Master/Detail Filtering With a DropDownList (VB)
  • Master/Detail Filtering Across Two Pages (VB)
  • Master/Detail Using a Bulleted List of Master Records with a Details DataList (VB)

• Editing and Deleting Data Through the DataList

  • Overview of Editing and Deleting Data in the DataList (C#)
  • Performing Batch Updates (C#)
  • Handling BLL- and DAL-Level Exceptions (C#)
  • Adding Validation Controls to the DataList's Editing Interface (C#)
  • Customizing the DataList's Editing Interface (C#)
  • Overview of Editing and Deleting Data in the DataList (VB)
  • Performing Batch Updates (VB)
  • Handling BLL- and DAL-Level Exceptions (VB)
  • Adding Validation Controls to the DataList's Editing Interface (VB)
  • Customizing the DataList's Editing Interface (VB)

• Paging and Sorting with the DataList and Repeater

  • Paging Report Data in a DataList or Repeater Control (C#)
  • Sorting Data in a DataList or Repeater Control (C#)
  • Paging Report Data in a DataList or Repeater Control (VB)
  • Sorting Data in a DataList or Repeater Control (VB)

• Custom Button Actions with the DataList and Repeater

  • Custom Buttons in the DataList and Repeater (C#)
  • Custom Buttons in the DataList and Repeater (VB)

• Accessing the Database Directly from an ASP.NET Page

  • Querying Data with the SqlDataSource Control (C#)
  • Using Parameterized Queries with the SqlDataSource (C#)
  • Inserting, Updating, and Deleting Data with the SqlDataSource (C#)
  • Implementing Optimistic Concurrency with the SqlDataSource (C#)
  • Querying Data with the SqlDataSource Control (VB)
  • Using Parameterized Queries with the SqlDataSource (VB)
  • Inserting, Updating, and Deleting Data with the SqlDataSource (VB)
  • Implementing Optimistic Concurrency with the SqlDataSource (VB)

• Enhancing the GridView

  • Adding a GridView Column of Radio Buttons (C#)
  • Adding a GridView Column of Checkboxes (C#)
  • Inserting a New Record from the GridView's Footer (C#)
  • Adding a GridView Column of Radio Buttons (VB)
  • Adding a GridView Column of Checkboxes (VB)
  • Inserting a New Record from the GridView's Footer (VB)

• Working with Binary Files

  • Uploading Files (C#)
  • Displaying Binary Data in the Data Web Controls (C#)
  • Including a File Upload Option When Adding a New Record (C#)
  • Updating and Deleting Existing Binary Data (C#)
  • Uploading Files (VB)
  • Displaying Binary Data in the Data Web Controls (VB)
  • Including a File Upload Option When Adding a New Record (VB)
  • Updating and Deleting Existing Binary Data (VB)

• Caching Data

  • Caching Data with the ObjectDataSource (C#)
  • Caching Data in the Architecture (C#)
  • Caching Data at Application Startup (C#)
  • Using SQL Cache Dependencies (C#)
  • Caching Data with the ObjectDataSource (VB)
  • Caching Data in the Architecture (VB)
  • Caching Data at Application Startup (VB)
  • Using SQL Cache Dependencies (VB)

• Database-Driven Site Maps

  • Building a Custom Database-Driven Site Map Provider (C#)
  • Building a Custom Database-Driven Site Map Provider (VB)

• Working with Batched Data

  • Wrapping Database Modifications within a Transaction (C#)
  • Batch Updating (C#)
  • Batch Deleting (C#)
  • Batch Inserting (C#)
  • Wrapping Database Modifications within a Transaction (VB)
  • Batch Updating (VB)
  • Batch Deleting (VB)
  • Batch Inserting (VB)

• Advanced Data Access Scenarios

  • Creating New Stored Procedures for the Typed DataSet's TableAdapters (C#)
  • Using Existing Stored Procedures for the Typed DataSet's TableAdapters (C#)
  • Updating the TableAdapter to Use JOINs (C#)
  • Adding Additional DataTable Columns (C#)
  • Working with Computed Columns (C#)
  • Configuring the Data Access Layer's Connection- and Command-Level Settings (C#)
  • Protecting Connection Strings and Other Configuration Information (C#)
  • Debugging Stored Procedures (C#)
  • Creating Stored Procedures and User-Defined Functions with Managed Code (C#)
  • Creating New Stored Procedures for the Typed DataSet's TableAdapters (VB)
  • Using Existing Stored Procedures for the Typed DataSet's TableAdapters (VB)
  • Updating the TableAdapter to Use JOINs (VB)
  • Adding Additional DataTable Columns (VB)
  • Working with Computed Columns (VB)
  • Configuring the Data Access Layer's Connection- and Command-Level Settings (VB)
  • Protecting Connection Strings and Other Configuration Information (VB)
  • Debugging Stored Procedures (VB)
  • Creating Stored Procedures and User-Defined Functions with Managed Code (VB)