VS2003 Nullable DataSet/DataTable Columns

[Goofy]

Hi,

I have a row in a dataset table which is nullable ( and also on the sql
backend ), but how can I set it to a null.

if I try Myrow.myDate = nothing

when I test the row, I get "#12:00AM" wh

?? IDEAS ??

--
Goofy

[Phill W.]

Goofy wrote:

I have a row in a dataset table which is nullable ( and also on the sql
backend ), but how can I set it to a null.

if I try Myrow.myDate = nothing

I'd use

Myrow.myDate = System.DBNull.Value

when I test the row, I get "#12:00AM" wh

That's just VB's /attempt/ to display a null Date to you in a
"meaningful" way - midnight, "Day Zero".

HTH,
Phill W.

[Goofy]

Thanks Phil
"Phill W." <p-.-a-.-w-a-r-d@o-p-e-n-.-a-c-.-u-kwrote in message
news:en**********@south.jnrs.ja.net...

Goofy wrote:

>I have a row in a dataset table which is nullable ( and also on the sql
backend ), but how can I set it to a null.

if I try Myrow.myDate = nothing

I'd use

Myrow.myDate = System.DBNull.Value

>when I test the row, I get "#12:00AM" wh

That's just VB's /attempt/ to display a null Date to you in a "meaningful"
way - midnight, "Day Zero".

HTH,
Phill W.

[Goofy]

Actually Phil, this doesent work on V1.x
I have to use a method of the datarow to set it to null

MyRow.SetMyColumnToNull


"Phill W." <p-.-a-.-w-a-r-d@o-p-e-n-.-a-c-.-u-kwrote in message
news:en**********@south.jnrs.ja.net...

Goofy wrote:

>I have a row in a dataset table which is nullable ( and also on the sql
backend ), but how can I set it to a null.

if I try Myrow.myDate = nothing

I'd use

Myrow.myDate = System.DBNull.Value

>when I test the row, I get "#12:00AM" wh

That's just VB's /attempt/ to display a null Date to you in a "meaningful"
way - midnight, "Day Zero".

HTH,
Phill W.