ObjectDataSource and sorting

I struck this error today - “Automatic sorting is only supported with DataView, DataTable, and DataSet”. It was caused by binding a custom collection through a DataSourceObject control.

Scott Guthrie suggests in a comment to this post to either implement a custom comparer, or make use of the SortParameterName property of the ObjectDataSource control.

I ended up doing the latter, as I need to be able to sort the collection on more than one property. My middle-tier expects this as an extra parameter, and then uses a DataView to sort the DataTable before it creates the custom collection.

Cumulative Hotfix for SQL Server 2000 Service Pack 4 - Build 2187 for x86 and x64 Based Systems

This package contains all hotfixes that are available for SQL Server 2000 Service Pack 4 prior to build 2187.

This build contains hotfixes that were available for SQL Server 2000 Service Pack 3 build 1031 but were not included in SQL Server 2000 Service Pack 4.

Microsoft Visual Studio 2005 - Update to Support Web Application Projects

This update enables migration wizard support and an improved designer experience when using Web Application Projects.

You can get the Web Application Projects add-in from here