I came across two awesome blog posts by Doug Nelson.
Optional Parameters for Stored Procedures GridView Dissapointments
No Comments