Working with Data in ASP.NET 2.0

http://weblogs.asp.net/scottgu/archive/2007/04/14/working-with-data-in-asp-net-2-0.aspx A ton of great articles and tutorials on working with data in ASP.NET 2.0 applications has been published recently. This post highlights a few of them: Working with Data in ASP.NET 2.0 Tutorial Series Scott Mitchell recently finished writing his multi-part Working with Data in ASP.NET 2.0 tutorial series for the www.asp.net site. This tutorial series contains more than 75 data tutorials (and over 750 pages of content!). There are VB and C# versions available for all of the tutorials, and the articles can optionally be downloaded in PDF format. If you haven't read the tutorials yet, I'd highly checking them out here. Below is the table of contents and links to the articles already published: Introduction (3 articles) Basic Reporting (3 articles) Master/Detail (4 articles) Custom Formatting (5 articles) Editing, Inserting, and Deleting Data (8 articles) Paging and Sorting (4 articles) Custom Button Actions (1 article) Displaying Data with the DataList and Repeater (4 articles) Filtering Scenarios with the DataList and Repeater (3 articles) Editing and Deleting Data Through the DataList (8 articles) Paging and Sorting with the DataList and Repeater (2 articles) Custom Button Actions with the DataList and Repeater (1 article) Accessing the Database Directly from an ASP.NET Page (4 articles) Enhancing the GridView (3 articles) Working with Binary Files (4 articles) Scott still has 18 more tutorials in the series that will be published soon covering: Caching (4 tutorials) Data and the Site Map Provider (1 tutorial) Working with Batched Data (including transactions; 4 tutorials) Advanced Data Access Layer Scenarios (9 tutorials). You can subscribe to this RSS feed to learn about updates when these tutorials are published. Using ASP.NET 2.0's DataSource Controls In addition to publishing the articles above on www.asp.net, Scott Mitchell is also writing some great data articles on using the ASP.NET 2.0 DataSource controls for the excellent www.4GuysFromRolla.com ASP.NET site. If you don't visit www.4GuysFromRolla.com, I highly recommend checking it out (it has tons of great, all free, content). You can also subscribe to an RSS feed of the published 4GuysFromRolla RSS articles here (if you are an ASP.NET developer you should absolutely do this). Here is a pointer to the current articles in the most recent 4GuysFromRolla ASP.NET 2.0 DataSource Control Series: Data Source Control Basics - explores the concepts of data source controls Accessing Database Data - shows how to use the SqlDataSource and AccessDataSource controls to query data from a relational database. Filtering Database Data with Parameters - learn how to retrieve just a subset of database data based on hard-coded values and values from the querystring, other Web controls on the page, session variables, and so on. Retrieving XML Data with XmlDataSource Control - see how to retrieve both remote and local XML data and display it in a data Web control. Creating Custom Parameter Controls - learn how to create your own custom, declarative controls for use in the data source controls' parameters collections. Examining the Data Source Control's Events - explore the events raised during a data source control's lifecycle. Declaratively Caching Data - learn how to cache data to the data cache simply by setting a couple of data source control properties. Programmatically Accessing Data using the Data Source Controls - programmatically retrieve, insert, delete, and update data using the SqlDataSource and AccessDataSource controls. SubSonic 2.0 Beta 3 SubSonic 2.0 Beta 3 is now available for download. SubSonic is a great (totally free) tool that helps you quickly build data driven web-sites. It includes a DAL builder that enables you to rapidly create strongly typed collections and an object model for your data (it builds this at compile-time based on the schema of your website), as well as rich scaffolding support for automatically creating UI against this data. Jon Galloway has a quick write-up of some of the new SubSonic 2.0 features that you can read here. If you are attending the MIX conference in two weeks, make sure to say hi to Rob Conery, who is the chief architect of SubSonic. He will also be on a great Open Source Panel at the MIX conference, together with Miguel de Icaza (of Mono) and others. NHibernate Best Practices with ASP.NET, 1.2 Ed. Billy McCafferty updated his popular "NHibernate Best Practices with ASP.NET" article earlier this month. You can read the latest version here. This article covers some of the core things to think about when building an enterprise data layer using this popular (totally free) ORM implementation for .NET. Also keep an eye out for this upcoming NHibernate in Action book scheduled to be released in July. Hope this helps,

ASP.NET 2.0 Tips, Tricks, Recipes and Gotchas

http://weblogs.asp.net/scottgu/pages/ASP.NET-2.0-Tips_2C00_-Tricks_2C00_-Recipes-and-Gotchas.aspx This page lists some of the more popular “ASP.NET 2.0 Tips, Tricks, Recipes and Gotchas” posts I’ve done over the last year. My goal is to add 1-2 new posts to the series each week going forward – so bookmark this page for updates, or subscribe to my blog via this RSS feed. To learn more about ASP.NET, also make sure to watch all of the great “ASP.NET: How Do I?” videos (each week a new video is posted). You can also browse a large listing of published ASP.NET 2.0 books here. Visual Studio · Tip/Trick: Optimizing ASP.NET 2.0 Web Project Build Performance with VS 2005 · Common Gotcha: Slow VS 2005 Web Site Build Performance Because of “Dueling Assembly References” · Resource: VS 2005 Web Application Project Tutorials · Recipe: Using VS 2005 Web Deployment Projects · Tip/Trick: Custom formatting HTML in Visual Web Developer and Visual Studio 2005 · Tip/Trick: Fast HTML Editor Navigation within VS 2005 · Tip/Trick: How to Run a Root “/” Site with the Local Web Server using VS 2005 SP1 · Tip/Trick: Changing the default browser used in VS 2005 and Visual Web Developer · Tip/Trick: Creating Re-Usable Project and Item Templates with VS 2005 · Tip/Trick: Creating Sub-Web Projects using the VS 2005 Web Application Project Option · Tip/Trick: Spell Checker Plug-in for VS 2005 for ASP.NET and HTML Pages · Tip/Trick: Using IIS7 on Vista with VS 2005 · Gotcha: Fixing Error with VS 2005 SP1 Beta and older Web Application Project Templates UI · Tip/Trick: Using Server Side Comments with ASP.NET 2.0 · Tip/Trick: Use the ASP.NET 2.0 CSS Control Adapters for CSS friendly HTML output · Tip/Trick: How to Register User Controls and Custom Controls in Web.config · Recipe: Dynamic Site Layout and Style Personalization with ASP.NET · Tip/Trick: Advanced Article on ASP.NET 2.0 Master Pages AJAX · Tip/Trick: Nikhil's WebDevHelper Utility and ASP.NET AJAX Support · Tip/Trick: Handling Errors with the UpdatePanel control using ASP.NET AJAX · Tip/Trick: Cool UI Templating Technique to use with ASP.NET AJAX for non-UpdatePanel scenarios · Gotcha: Lost HTML Intellisense within ASP.NET AJAX Controls · Gotcha: Don't use with ASP.NET AJAX · Tip/Trick: UpdateProgress Control and AJAX Activity Image Animations Data · Tip/Trick: Online Database Schema Samples Library · Recipe: Great ASP.NET 2.0 Three-Tier Data Tutorials Published · Recipe ASP.NET 2.0 RSS Tool-Kit · Resource: LINQ Demos, Slides + Samples · Recipe: Building and using a LINQ for SQL Class Library with ASP.NET 2.0 · Recipe: Tagging Data using LINQ · Recipe: Paging through lots of data efficiently (and in an Ajax way) with ASP.NET 2.0 · Recipe: Efficient Data Paging with the ASP.NET 2.0 DataList Control and ObjectDataSource · Tip/Trick: ListControl.AppendDataBoundItems Property in ASP.NET 2.0 Security · Resource: ASP.NET 2.0 Membership, Roles, Forms Authentication, and Security Resources · Recipe: Enabling Windows Authentication within an Intranet ASP.NET Web application · Recipe: Implementing Role Based Security with ASP.NET using Windows Authentication and SQL Server · Recipe: Configuring ASP.NET 2.0 Application Services to use SQL Server 2000 or SQL Server 2005 · Gotcha: Always set the "applicationName" property when configuring ASP.NET 2.0 Membership and other Providers · Common Gotcha: Don't forget to when adding providers · Tip/Trick: Source/Documentation for Simple ASP.NET 2.0 SQL Providers Published · Tip/Trick: Guard Against SQL Injection Attacks · Tip/Trick: Gathering Custom User Registration Information · Recipe: How to add a Login, Roles and Profile system to an ASP.NET 2.0 app in only 24 lines of code · Gotcha: Authorization with the built-in VS 2005 Web Server (aka Cassini) · Gotcha: Forms Authentication timeout default changed between ASP.NET 1.1 -> ASP.NET 2.0 · Tip/Trick: How To Share Authentication Cookies across ASP.NET V1.1 and ASP.NET V2.0 Applications Deployment · Gotcha: Don’t run production ASP.NET Applications with debug=”true” enabled · Tip/Trick: Patterns and Practices Guidance Explorer for .NET and ASP.NET · Tip/Trick: App_Offline.htm and working around the "IE Friendly Errors" feature · Tip/Trick: Show Detailed Error Messages to Developers (and only to Developers) · Tip/Trick: Logging ASP.NET Application Shutdown Events Performance · Tip/Trick: Implement "Donut Caching" with the ASP.NET 2.0 Output Cache Substitution Feature · Tip/Trick: Disk Based Output Caching Feature Now Available for ASP.NET 2.0 · Tip/Trick: Cache Manager Miscellaneous · Resource: Credit Card Payment Processing with ASP.NET · Tip/Trick: List Running ASP.NET Worker Processes and Kill/Restart them from the command-line