Insert NULL value into database

[columbo2]

Hi

I have an update statement and when fields in my form are left blank I want NULL inserted into the databse rather than "".

I can't find a way to do it.

If I can't find another way my plan is to set the fields in the data base to <NULL> using c# then use a second SQL query after the update to update the row and actually make these cells proper SQL null columns.

It seems a really messy way to do it.
Is there some way of setting to Null directly?

thanks
C

 

[columbo2]

Actually I think I'll set all of the fields that could be null to null first then, write the new data over the top.
Still a bit messt but better I think

 

[AlexCuse]

how are you issuing this query?

if its' a normal string you just need to pass the string "null" ie:

string myCommandText = "insert into zeTable (Column1, Column2) values (null, 'realvalue')"

If you are using stored procedures with parameters you'd need to assign their value to DBNull.Value I believe.

Hope this helps,

Alex



[small]----signature below----[/small]
Now you can go where the people are one!
Now you can go where they get things done!

 

[columbo2]

what an idiot I am.
You're right

I was stuck on thinking about having to pass the null value through a parameteter and forgetting the odvious.

I'm building the update query any way so, as you say I'll just write it into the statement as SQL.

thanks
ta
C