DBNull issue

[DG]

I have my object containing datarow and exposing properties:
e.g.:

public int Price
{
get{
return _myRow.Price;
}
set{
_myRow.Price = value;
}
}

what if i want to set this value to null?

Do i have to expose .SetPriceNull() and .IsPriceNull()
for each numeric/date property?
Is there more elegant way?

[Marc Gravell]

Have you looked at Nullable<T> in 2.0?

just use "int?" instead of "int"

This allows it to act as "null" - not quite the same as DBNull, but many
controls will know what you mean...

Marc

[DG]

Thanx this is what i need.
How to set 'int?' variable to DBnull?
will dataAdapter understand that and update database field to null?
"Marc Gravell" <ma**********@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

Have you looked at Nullable<T> in 2.0?

just use "int?" instead of "int"

This allows it to act as "null" - not quite the same as DBNull, but many
controls will know what you mean...

Marc

[Marc Gravell]

int? can accept null or an integer. Since you are using getters and setters
to an object with DBNull, one approach here would be to change between null
and DBNull in the getter / setters, presumably with the "a ? b : c" tertiary
syntax.

I don't use typed data-sets much, so I'm inferring the following from your
e-mail; it might actually need "is DBNull" or something similar instead...
but give it a whirl...

Marc

public int? Price
{
get{
return _myRow.IsPriceNull() ? null : _myRow.Price;
}
set{
if(value==null)
_myRow.SetPriceNull();
else
_myRow.Price = value;
}
}