simple INSERT question

[hkl]

When I try: INSERT INTO Product (ID, name, date) VALUES (123, NULL, NULL) It works fine when I use NULL to 'name' and 'date' in the INSERT statement. However, when I use a variable: INSERT INTO Product (ID, name, date) VALUES (123, @myName, NULL) And assign @myName.Value = null to the variable, I get an error message when I execute this statement. (For example: myInsert.Parameters["@myName"].Value = null;) My question is: If I use @myName in the INSERT statement, how I can assign NULL to it?? Thank you!!:)

[Edbert P]

You have to use DBNull.Value instead of null, e.g. myInsert.Parameters["@myName"].Value = DBNull.Value