You need to define a length when specifying the
SqlParameter TheFirstJob = cmd.Parameters.Add("@spParam", SqlDbType.VarChar, 50);
Note: You should use the same length as defined in your SQL Server stored procedure.
How to use and get HiddenField Value in Gridview
Drag and Drop objects from Object Explorer to the Query Window in SQL Server
ASPxGridView - Disable CheckBox based on condition in GridViewCommandColumn
Fire Combobox SelectedIndexChanged with button code-behind
How to find the first missing value in a series in MS SQL