SqlCeCommand nullable values

Question

My code:

SqlCeConnection sql = new SqlCeConnection(@"Data Source=C:\DB.sdf");
sql.Open();
cmd = new SqlCeCommand("INSERT INTO xxx(aaa) VALUES(@aaa)", sql);
String param = null;  //doesn't work
//String param = "blah" //works
cmd.Parameters.AddWithValue("@aaa", param);
cmd.ExecuteNonQuery(); //(1)
sql.Close();

(1) throws an exception when param is null. Database allows value in collumn aaa to be null. How can I insert null into table xxx ?

Exception:
Parameterized query 'INSERT INTO xxx(aaa) VALUES(@aaa)' expects a parameter value which was not supplied.

BFree · Accepted Answer · 2011-05-11 00:50:29Z

4

Try using DBNull.Value instead:

var param = DBNull.Value;

answered May 11, 2011 at 0:50

BFree

104k21 gold badges164 silver badges205 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joshua · Accepted Answer · 2011-05-11 03:21:23Z

3

Use

var param = DBNull.Value;

null isn't the same thing as DBNull

edited May 11, 2011 at 3:21

answered May 11, 2011 at 0:49

Joshua

5521 gold badge4 silver badges17 bronze badges

1 Comment

Ichibann Over a year ago

Can DBNull.Value be cast to String?

Collectives™ on Stack Overflow

SqlCeCommand nullable values

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related