Scott on Writing

More Tutorials on Working with the DataList... and More Tutorials in the Pipeline!

Eight new tutorials have been added to my Working with Data in ASP.NET 2.0 series. This latest batch of tutorials examines how to edit and delete data from the DataList control. These tutorials follow, in scope, the concepts discussed in the earlier edit/insert/delete-related tutorials that focused on the GridView, DetailsView, and FormView controls. These DataList-specific tutorials, however, do include a look at performing batch updates (a topic lacking from the GridView/DetailsView/FormView-specific ones). As always, each tutorial is available in both VB and C#, includes the full working code as a downloadable ZIP, and can be downloaded as a PDF for offline access.

When I started writing these tutorials I was slated to write 46 in total, and, to date, 43 of the 46 are up at http://www.asp.net/Learn/DataAccess/. (They are also being added to MSDN's website, but at a much more glacial pace.) Anywho, the good news is that I've signed on to author another 29 tutorials over the coming months, which will continue the series and be available at http://www.asp.net/Learn/DataAccess/ as they come online.

Here is the planned outline. The content to be covered is pretty much solidified, but there may be some slight modifications, reordering of sections/tutorials, and so forth. I've actually completed the “set” of tutorials on the SqlDataSource (the first four), and will start hammering out the next set this week, time permitting.

1. Accessing Database Data Directly from an ASP.NET Page
1. Querying Data with the SqlDataSource Control
2. Using Parameterized Queries with the SqlDataSource 
3. Inserting, Updating, and Deleting Data with the SqlDataSource Control
4. Implementing Optimistic Concurrency with the SqlDataSource
   
2. Enhancing the GridView
1. Adding a GridView Column of Radio Buttons
2. Adding a GridView Column of CheckBoxes
3. Inserting a New Record from the GridView’s Footer
   
3. Working with Batched Data
1. Batch Updating
2. Batch Deleting
3. Generating Multiple Details Records Which Copy Multiple Columns of Data From a Common Master
   
4. Working With Binary Files
1. Uploading Files
2. Including a File Upload Option When Adding a New Record
3. Displaying File Information in the Data Web Controls
4. Changing the Uploaded File for an Existing Record
   
5. Caching
1. Caching Data with the ObjectDataSource
2. Caching Data at the Business Logic Layer
3. Using SQL Cache Dependencies
4. Caching Data at Application Startup
   
6. Data and the Site Map Provider
1. Building a Custom Database-Driven Site Map Provider
   
7. Advanced Data Access Layer Scenarios
1. Having the Typed DataSet Create Your Stored Procedures
2. Integrating Existing Stored Procedures with the TableAdapter
3. Techniques for Performing JOINs
4. Adding Additional DataTable Columns
5. Working with Computed Columns
6. Configuring Connection- and Command-Level Settings in the DAL
7. Wrapping Database Modifications in a Transaction
8. Debugging Stored Procedures
9. Protecting connection strings
10. Creating SQL Functions and Stored Procedures with Managed Code

posted on Tuesday, October 31, 2006 12:53 PM