VS2003 Nullable DataSet/DataTable Columns

  • Thread starter Thread starter Goofy
  • Start date Start date
G

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 said:
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
Click to expand...

I'd use

Myrow.myDate = System.DBNull.Value
when I test the row, I get "#12:00AM" wh
Click to expand...

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

HTH,
Phill W.
 
Thanks Phil


Phill W. said:
I'd use

Myrow.myDate = System.DBNull.Value


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

HTH,
Phill W.
Click to expand...
 
Actually Phil, this doesent work on V1.x


I have to use a method of the datarow to set it to null

MyRow.SetMyColumnToNull
 
Back
Top