Showing spaces in parameter passed to stored proc

I don't understand why you are allowing names to be created with spaces at the beginning and end of your name entered. You should use .Trim() to remove the spaces at the beginning and end of value entered into your textbox.

Nathan