How to put NULL into database column

  • Thread starter Thread starter Lubomir
  • Start date Start date
L

Lubomir

Hi,

I have a stored procedures that takes few parameters( lets say 2).
Parameters are value for particular columns.

A column of type "binary' can contain "null".

I want to update a row, so that first column will have some value and second
should contain null. How can I do it?

MyParam.Value = null;
cmd.Parameters.Add(MyParam); // obviously doesn't work

Thanks,
Lubomir
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Output parameter 2
DEFAULT value in SqlParameter 3
Simple problem passing nulls with ADO.net 2.0 4
Error sql parameter SqlDbType.Float won't accept null value, AND/OR variable as DOUBLE won't accept 4
how force ds.WriteXml to add column even for column with null? 4
SqlDataSource optional parameter problem 1
TextBox bound to a numeric value does not allow nulls 2
insert null into the database 4

Back
Top