Inserting DBNull with asp.net

[Jimmy Turnip]

I'm trying to replace a field with a specific value with a dbnull value with the following sql statement:

"UPDATE MyDBTable SET ID = " & DBNull.Value & " WHERE ID = " & MyDropDownList.SelectedValue & ";"

I keep receiving the error "Incorrect syntax near the word WHERE"

Anyone got any ideas what I am doing wrong?

Thanks.

[duckhunter]

Just use the word NULL inside the quotes.

"UPDATE MyDBTable SET ID = NULL WHERE ID = " & MyDropDownList.SelectedValue & ";"

[Jimmy Turnip]

thanks. now i feel stupid.