Just a quick note - the Add method for the SqlParameterCollection object has been deprecated. The replacement is AddWithValue. I received this nice little compiler warning today:
System.Data.SqlClient.SqlParameterCollection.Add(string, object)' is obsolete: 'Add(String parameterName, Object value) has been deprecated. Use AddWithValue(String parameterName, Object value).
It wasn't readily apparent why this was changed because the signature still takes a parameter name and object value, so I did a google search and found this link in case you are interested. http://weblogs.asp.net/JackieG/archive/2005/03/22/395517.aspx
AddWithValue"
trackback:ping="http://unboxedsolutions.com/sean/services/trackbacks/788.aspx" />
-->