Earlier this year I posted two long data access tutorial posts. My goal was to then follow up these popular posts (90,000+ views and counting!) with a whole series around them. Unfortunately work sidetracked me and I found I didn't have the time to-do them justice...
Thankfully Scott Mitchell kindly offered to help write them instead, and has put together an awesome data access tutorial series that is now online here under the "Learn" tab of the http://www.asp.net website. 15 of the data tutorial segments can now be read online, with another 25 still on their way. Each of the tutorials is available in both VB and C#, and in both HTML and PDF format. Full source code is also provided for all samples.
The data series begins by creating a DAL using the built-in data TableAdapter designer in Visual Web Developer Express and Visual Studio. Scott then create a business class layer that encapsulates the DAL and adds additional business logic and validation to it. All of the samples then use the ASP.NET 2.0 ObjectDataSource control to bind against the business class layer, and show how to perform common binding operations against it. Note that if you want you can easily substitute the table adapter DAL for your own DAL implementation with the business class layer -- all of the 39 other data tutorials will then work against it the same way.
The list of currently published data articles in the series includes:
- Creating a Data Access Layer using Typed DataSets
- Creating a Business Logic Layer
- Using Master Pages and Site Navigation for Consistent Look and Feel of the Data Samples
Basic ASP.NET Data Reporting
- Displaying Data with the ObjectDataSource
- Using ObjectDataSource Declarative Parmeters
- Programmatically Setting ObjectDataSource Parameter Values
- Master/Detail Filtering with a DropDownList Control
- Master/Detail Filtering with two DropDownList Controls
- Master/Detail Filtering across two pages
- Master/Detail Using a Selectable Master GridView with a Details DetailView
- Custom Formatting Based Upon Data
- Using TemplateFields in a Gridview Control
- Using TemplateFields in a DetailsView Control
- Using the FormView's templates
- Displaying Summary Information in a GridView's Footer
Over the next few weeks 25+ more tutorials will appear covering paging, sorting, editing, deleting, validation and much, much more.
Hope this helps,