English German Spanish French Chinese
Home › Learn › Data Access Tutorials  

Data Access Tutorials

Welcome to a series of tutorials that will explore techniques for implementing these common data access patterns in ASP.NET 2.0. These tutorials are geared to be concise and provide step-by-step instructions with plenty of screen shots to walk you through the process visually. Each tutorial is available in Visual Basic and Visual C# versions and includes a download of the complete code used.

By default, the Visual Basic tutorials will be shown.  (Switch to the Visual C# tutorials)

Introduction

#1 | Creating a Data Access LayerView in VB or C#

#2 | Creating a Business Logic LayerView in VB or C#

#3 | Master Pages and Site NavigationView in VB or C#

Basic Reporting

#4 | Displaying Data With the ObjectDataSourceView in VB or C#

#5 | Declarative ParametersView in VB or C#

#6 | Programmatically Setting the ObjectDataSource's Parameter ValuesView in VB or C#

Master/Detail

#7 | Master/Detail Filtering With a DropDownListView in VB or C#

#8 | Master/Detail Filtering With Two DropDownListsView in VB or C#

#9 | Master/Detail Filtering Across Two PagesView in VB or C#

#10 | Master/Detail Using a Selectable Master GridView with a Details DetailViewView in VB or C#

Custom Formatting

#11 | Custom Formatting Based Upon DataView in VB or C#

#12 | Using TemplateFields in the GridView ControlView in VB or C#

#13 | Using TemplateFields in the DetailsView ControlView in VB or C#

#14 | Using the FormView's TemplatesView in VB or C#

#15 | Displaying Summary Information in the GridView's FooterView in VB or C#

Editing, Inserting, and Deleting Data

#16 | An Overview of Inserting, Updating, and Deleting DataView in VB or C#

#17 | Examining the Events Associated with Inserting, Updating, and DeletingView in VB or C#

#18 | Handling BLL- and DAL-Level Exceptions in an ASP.NET PageView in VB or C#

#19 | Adding Validation Controls to the Editing and Inserting InterfacesView in VB or C#

#20 | Customizing the Data Modification InterfaceView in VB or C#

#21 | Implementing Optimistic ConcurrencyView in VB or C#

#22 | Adding Client-Side Confirmation When DeletingView in VB or C#

#23 | Limiting Data Modification Functionality Based on the UserView in VB or C#

Paging and Sorting

#24 | Paging and Sorting Report DataView in VB or C#

#25 | Efficiently Paging Through Large Amounts of DataView in VB or C#

#26 | Sorting Custom Paged DataView in VB or C#

#27 | Creating a Customized Sorting User InterfaceView in VB or C#

Custom Button Actions

#28 | Adding and Responding to Buttons to a GridViewView in VB or C#

Displaying Data with the DataList and Repeater

#29 | Displaying Data with the DataList and Repeater ControlsView in VB or C#

#30 | Formatting the DataList and Repeater Based Upon DataView in VB or C#

#31 | Showing Multiple Records per Row with the DataList ControlView in VB or C#

#32 | Nested Data Web ControlsView in VB or C#

Filtering Scenarios with the DataList and Repeater

#33 | Master/Detail Filtering With a DropDownListView in VB or C#

#34 | Master/Detail Filtering Across Two PagesView in VB or C#

#35 | Master/Detail Using a Bulleted List of Master Records with a Details DataListView in VB or C#

Editing and Deleting Data Through the DataList

#36 | An Overview of Editing and Deleting Data in the DataListView in VB or C#

#37 | Performing Batch UpdatesView in VB or C#

#38 | Handling BLL- and DAL-Level ExceptionsView in VB or C#

#39 | Adding Validation Controls to the DataList’s Editing InterfaceView in VB or C#

#40 | Customizing the DataList’s Editing InterfaceView in VB or C#

#41 | Implementing Optimistic ConcurrencyView in VB or C#

#42 | Adding Client-Side Confirmation When DeletingView in VB or C#

#43 | Limiting Data Modification Functionality Based on the UserView in VB or C#

Paging and Sorting with the DataList and Repeater

#44 | Paging Report Data in a DataList or Repeater ControlView in VB or C#

#45 | Sorting Data in a DataList or Repeater ControlView in VB or C#

Custom Button Actions with the DataList and Repeater

#46 | Custom Buttons in the DataList and RepeaterView in VB or C#

Accessing the Database Directly from an ASP.NET Page

#47 | Querying Data with the SqlDataSource ControlView in VB or C#

#48 | Using Parameterized Queries with the SqlDataSourceView in VB or C#

#49 | Inserting, Updating, and Deleting Data with the SqlDataSourceView in VB or C#

#50 | Implementing Optimistic Concurrency with the SqlDataSourceView in VB or C#

Enhancing the GridView

#51 | Adding a GridView Column of Radio ButtonsView in VB or C#

#52 | Adding a GridView Column of CheckboxesView in VB or C#

#53 | Inserting a New Record from the GridView’s FooterView in VB or C#

Working with Binary Files

#54 | Uploading FilesView in VB or C#

#55 | Displaying Binary Data in the Data Web ControlsView in VB or C#

#56 | Including a File Upload Option When Adding a New RecordView in VB or C#

#57 | Updating and Deleting Existing Binary DataView in VB or C#

Caching Data

#58 | Caching Data with the ObjectDataSourceView in VB or C#

#59 | Caching Data in the ArchitectureView in VB or C#

#60 | Caching Data at Application StartupView in VB or C#

#61 | Using SQL Cache DependenciesView in VB or C#

Database-Driven Site Maps

#62 | Building a Custom Database-Driven Site Map ProviderView in VB or C#

Working with Batched Data

#63 | Wrapping Database Modifications within a TransactionView in VB or C#

#64 | Batch UpdatingView in VB or C#

#65 | Batch DeletingView in VB or C#

#66 | Batch InsertingView in VB or C#

Advanced Data Access Scenarios

#67 | Creating New Stored Procedures for the Typed DataSet’s TableAdaptersView in VB or C#

#68 | Using Existing Stored Procedures for the Typed DataSet’s TableAdaptersView in VB or C#

#69 | Updating the TableAdapter to Use JOINsView in VB or C#

#70 | Adding Additional DataTable ColumnsView in VB or C#

#71 | Working with Computed ColumnsView in VB or C#

#72 | Configuring the Data Access Layer’s Connection- and Command-Level SettingsView in VB or C#

#73 | Protecting Connection Strings and Other Configuration InformationView in VB or C#

#74 | Debugging Stored ProceduresView in VB or C#

#75 | Creating Stored Procedures and User-Defined Functions with Managed CodeView in VB or C#

Visual Basic Tutorials

(Switch to Visual C# tutorials)

  • Data Tutorials Start Page

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

Scott’s Book

The Data Access tutorials were written by Scott Mitchell who has also written the following book on learning ASP.NET.

Teach Yourself ASP.NET 3.5 in 24 Hours
by Scott Mitchell
View on Amazon

»  More Books

Contact | Advertise | Ads by BanManPro | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.

Microsoft Communities