Optimized Paging and Sorting in ASP.NET GridView

http://dotnetslackers.com/articles/gridview/Optimized-Paging-and-Sorting-in-ASP-NET-GridView.aspx

Parameterized IN clauses with ADO.NET and Stored Procedure

http://www.mikesdotnetting.com/Article/116/Parameterized-IN-clauses-with-ADO.NET-and-LINQ

Improve bandwidth performance of ASP Site using IIS Compression

http://www.dotnetfunda.com/articles/article589-best-practice-no-4-improve-bandwidth-performance-of-aspnet-sites-using-iis-compression.aspx

Enumerating SQL Servers from .NET 2.0

There's a cool new .net 2.0 feature I didn't know about until I needed to do this a few days ago. If your application has FullTrust, you can use the System.Data.Sql.SqlDataSourceEnumerator to get alist of available SQL servers (2000 and 2005 only). The query returns a DataTable which you can just attach to a combobox or drop down list. Dim instance As SqlDataSourceEnumerator = SqlDataSourceEnumerator.Instance Dim dt As DataTable = instance.GetDataSources()

Regular Expressions - Help!!!

If you are like me you find dealing with regular expressions both powerful and frustrating.I found a couple links that may help you on your journey to build regular expressions.

Roy Osherove has a few tools here that will be useful. The first is the Regulator that allows you to build regular expression with intellisense included. The second tool is the regulazy that allows you to typein text select it and via right click create your regular expression:

http://tools.osherove.com/Default.aspx?tabid=165

The third is not really a tool but a library that helps you find regular expressions that others have created for you:

http://regexlib.com/