How can I include DBNull as a value in my strongly typed dataset?

You have in MyDataTableRow class a generated method named: SetMyColNull() myRow.SetMyColNull() you can also do : myRow"MyCol" = DBNull. Value because myRow"MyCol" is of type object EDIT (added by Question OP): There is also a counterpart method generated for reading this value back out, IsMyColNull().

You have in MyDataTableRow class a generated method named: SetMyColNull(). MyRow.SetMyColNull(); you can also do : myRow"MyCol" = DBNull. Value; because myRow"MyCol" is of type object EDIT (added by Question OP): There is also a counterpart method generated for reading this value back out, IsMyColNull().

1 Egad! How did I miss/not-know this? Excellent!

Many thanks! – Beska Sep 22 '09 at 18:11.

There are two things. Allowing DBNull is a separate setting from being able to set the value to DBNull. I've only used the DataSet XSD interface to set this... but I had to not only set "AllowDBNull = true", but I also had to set "NullValue = (null)".

Originally "NullValue" was set to "(Exception)". This meant that the dataset would accept bieng .Fill()ed with null, but would not allow you to manually set the value to null. Not sure if this is your problem, but it sounds similar.

(the INullable version) does. I think you need that datatype instead.

Unfortunately, this doesn't work...I'd tried this (I should mention this in the question...I'll edit it to do so. ) When I do this, it pops up a window that complains that "Column requires a valid DataType. " – Beska Sep 22 '09 at 18:08.

Just go to designer mode in dataset and right click on field that you want to be null enabled, and select properties , in properties window , set AllowDBNull to True and NullValue to (NULL) ; it works for me right! Best regards!

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.