Insert null value

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I´m working with SQLCE 3.0, WM5, CF 2.0 and with resultSet. In my table 'Table_1' i have a column int that accept null values.
My question is how to update that column with a null value, i didn´t find a way to do it with the resultset...

Can anybody help me ?

Thanks in advance.
Chris
 
I´m working with SQLCE 3.0, WM5, CF 2.0 and with resultSet. In my table 'Table_1' i have a column int that accept null values.
My question is how to update that column with a null value, i didn´t find a way to do it with the resultset...

Can anybody help me ?

Thanks in advance.
Chris
Click to expand...

You can assign it the DBNull.Value.

- Jin
 
Hi Jin, thanks for your reply, i write this:

myresultSet.SetInt32(2, DBNull.Value);

but i get this error: Error 6 Argument '2': cannot convert from
'System.DBNull' to 'int'

My column is int, and accept null values.... Can you help me ?

Thanks a lot Jin







"Jin Chang" <[email protected]> escribió en el mensaje
I´m working with SQLCE 3.0, WM5, CF 2.0 and with resultSet. In my table
'Table_1' i have a column int that accept null values.
My question is how to update that column with a null value, i didn´t find
a way to do it with the resultset...

Can anybody help me ?

Thanks in advance.
Chris
Click to expand...

You can assign it the DBNull.Value.

- Jin
 
Sorry, i found the correct syntax:
myresultSet.SetValue(2, DBNull.Value);

Thanks for your help Jin!!, it´s works!
 
Back
Top