Data Access Tutorials


Creating a Data Access Layer
Creating a Business Logic Layer
Master Pages and Site Navigation
Displaying Data With the ObjectDataSource
Declarative Parameters
Programmatically Setting the ObjectDataSource’s Parameter Values
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
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
An Overview of Inserting, Updating, and Deleting Data
Inserting, Updating, and Deleting Events
Handling BLL- and DAL-Level Exceptions in an ASP.NET Page
Adding Validation Controls to the Interfaces
Customizing the Data Modification Interface
Implementing Optimistic Concurrency
Adding Client-Side Confirmation When Deleting
Limiting Data Modification Per User
Paging and Sorting Report Data
Efficiently Paging Through Large Amounts of Data
Sorting Custom Paged Data
Creating a Customized Sorting User Interface
Adding and Responding to Buttons to a GridView
Displaying Data with the DataList and Repeater Controls
Formatting the DataList and Repeater
Showing Multiple Records per Row with the DataList
Nested Data Web Controls
Master/Detail Filtering With a DropDownList
Master/Detail Filtering Across Two Pages
Master/Detail Using a Bulleted List of Master Records
An Overview of Editing and Deleting Data in the DataList
Performing Batch Updates
Handling BLL- and DAL-Level Exceptions
Adding Validation to the DataList’s Editing Interface
Customizing the DataList’s Editing Interface
Implementing Optimistic Concurrency
Adding Client-Side Confirmation When Deleting
Limiting Data Modification Per User
Paging Report Data in a DataList or Repeater Control
Sorting Data in a DataList or Repeater Control
Custom Buttons in the DataList and Repeater
Querying Data with the SqlDataSource Control
Using Parameterized Queries with the SqlDataSource
Inserting, Updating, & Deleting with the SqlDataSource
Optimistic Concurrency with the SqlDataSource Adding a GridView Column of Radio Buttons
Adding a GridView Column of Checkboxes
Inserting a New Record from the GridView’s Footer
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 with the ObjectDataSource
Caching Data in the Architecture
Caching Data at Application Startup
Using SQL Cache Dependencies
Building a Custom Database-Driven Site Map Provider
Wrapping Database Modifications within a Transaction
Batch Updating
Batch Deleting
Batch Inserting
Creating Stored Procs for TableAdapters
Using Existing Stored Procs for the TableAdapters
Updating the TableAdapter to Use JOINs
Adding Additional DataTable Columns
Working with Computed Columns
Configuring the DAL’s Connection and Command Settings
Protect Connection Strings & Other Configuration Info
Debugging Stored Procedures
Creating Stored Procs and UDFs with Managed Code


Dynamic Data Videos


Getting Started with Dynamic Data
Begin Editing the Templates
Begin Modifying with URL Routing
Enable In-Line Editing
Enable Table Specific Routing
Use Attribute Validation
Implement Custom Field Validation with Imperative Logic
Remove Columns From DynamicData Data Grids
Create Table Specific Custom Forms
Custom Form Formatting


LINQ Videos


Get Started with LINQ
Perform Group and Aggregate Queries
Upgrade VB Projects to Enable Linq
Get Started with LINQ to XML
Enable XML Intellisense and Use XML Namespaces
Create XML Documents from SQL Data
Create Excel to Spreadsheets using LINQ to XML
LINQ to SQL Overview
LINQ to SQL Data Model
LINQ to SQL Querying the DB
LINQ to SQL Updating the DB
LINQ to SQL using LINQ Datasource
LINQ to SQL Custom Linq Datasource
LINQ to SQL using Stored Procedures
LINQ to SQL Updating with Stored Procedures
LINQ to SQL Executing Arbritrary SQL


SQL Server 2005 Express for Beginners


What is a Database?
Understanding Database Tables and Records
More about Column Data Types and Other Properties
Designing Relational Database Tables
Manipulating Database Data
More Structured Query Language
Understanding Security and Network Connectivity
Connecting your Web Application to SQL Server 2005 Express
Using SQL Server Management Studio
Getting Started with Reporting Services
Building and Customizing Reports in BI Dev Studio
Creating and Using Stored Procedures
Enabling Full-Text Search in your Text Data