Tim Mackey's Weblog

Wow, thanks so much I had the same problem and your post saved me about an hour of searching.

glad you found it helpful.

Thanks very much, Tim - I was also having this problem.

Thank you! Same problem here. Really - really annoying.

Same here! Thanks for posting it!!

THANK YOU VERY MUCH!!

I have spent several hours trying to understand why this didn't work. I works fine with Update!

// Kristian

Thanks, that really helped me :)

Same problems.

thanks

Thanks. It is extremely usefull.

The DataKeyNames is neccesary also when the delete method take the whole object has parameters.

Thanks

Thank you. I spent hours trying to figure this out.

What a HELP!!

Thankz, I will forward you post!

My delete method requires 2 more parameters, yet they are being passed as NULL byt the objectdatasource to my delete method. I've checked the deleteparameters and they look ok. I've been pulling my hair out for a few days over this - can anyone help?

I also spent several hours trying to figure this out. So glad I found your blog.

THANK YOU!

I have exactly the same problem and it's solved

thanks

So after 4 years, people are still searching on this issue. Great post Tim - short and sweet and an apparent life saver after so long. I'd like to extend it a bit for others:

1. Microsoft's documentation on this is sorely lacking, so no, it's not you ;)

2. Although the DataSource wizard for ObjectDataSource doesn't show you the params for INSERT, UPDATE, and DELETE, you must still set them (at least in VS2008). Go to the properties window of your ObjectDataSource control and look at the data section. You'll find a property for each type (for example, for DELETE you'll see DeleteParameters) and it will be a collection. Expand the collection and it brings up a wizard to help you define your parameters. This is essential; why this isn't part of the main wizard (except for SELECT), I couldn't tell you. Establish your params here and you won't receive nulls.

3. For those programmatically creating their data: If you are using an ObjectDataSource which returns a DataSource you've constructed (ie, not from a DB), then be sure to set the PrimaryKey property of each table in the datasource. Since you may have more than one key, here's a snippet (VB.net)

'Create your table
dim dtTable as New DataTable()
'...put some data in it...

'Set primary key
Dim dcKey(1) As DataColumn
dcKey(1) = dtTable.Columns.Item(FIELD_FEATUREKEY)
dtTable.PrimaryKey = dcKey

The sneaky thing about the PrimaryKey property, is that it expects an array - not a column (in case your table has multiple keys).

Tie it all together and your DELETE and other methods should work fine.

Thank you!