Gray Wolf Blog

When you have a gridview bound to an ObjectDataSource, you have to be sure to pass the fields defined in the gridview’s DataKeyNames section to your Delete and Update methods.

Otherwise, you will get an error similar to:

ObjectDataSource 'objDSStatus' could not find a non-generic method 'DeleteContactStatus' that has parameters: ContactStatusId, ContactStatusTypeId.


In this instance I had DataKeyNames=”ContactStatusId, ContactStatusTypeId”, but the DeleteContactStatus method only contained ContactStatusId – the actual primary key.

Also be sure OldValuesParameterFormatString=”{0}”

You don’t need to configure the DeleteParameters in the ObjectDataSource properties as the defined DataKeyNames are passed automatically.

Here is the update code that worked:

1. Public Sub DeleteContactStatus(_
2. ByVal ContactStatusId As Integer, _
3. ByVal ContactStatusTypeId As Integer)
4.  
5. Dim arrParams(0) As SqlParameter
6.  
7. arrParams(0) = New SqlParameter("@iContactStatusId", ContactStatusId)
8.  
9. strSql = "Delete From ContactStatus " & _
10. "Where ContactStatusId = @iContactStatusId"
11.  
12. SqlHelper.ExecuteNonQuery(cn, CommandType.Text, strSql, arrParams)
13. End Sub
14. Download this code: DeleteContactStatus.txt