Assigning a null value in a dataset

[John]

Hi,

I'm writing a database programme with C# using a dataset. I want to set a DateTime for a particular
field of a row to null (nulls are allowed for that column). When I use:

newRow.Date_Pub =null;

I get a compile error: "Cannot convert null to 'System.DateTim e' because it is a value type".

How do I set the field to null?

[Sericinus hunter]

John wrote:

Hi,

I'm writing a database programme with C# using a dataset. I want to set a DateTime for a particular
field of a row to null (nulls are allowed for that column). When I use:

newRow.Date_Pub =null;

I get a compile error: "Cannot convert null to 'System.DateTim e' because it is a value type".

How do I set the field to null?

There should be newRow.SetDate_ PubNull() method generated for the typed dataset.

[John]

Thanks, that works.

IIs there a way to set a SetDate variable to a special value that could represent null? This would
make it easier for me since I'm returning a DateTime from a function, and sometimes need to return
something that represents null.

Best wishes,

John
"Sericinus hunter" <se*****@flash. netwrote in message
news:OG******** ******@TK2MSFTN GP04.phx.gbl...
John wrote:

Hi,

I'm writing a database programme with C# using a dataset. I want to set a DateTime for a
particular
field of a row to null (nulls are allowed for that column). When I use:

newRow.Date_Pub =null;

I get a compile error: "Cannot convert null to 'System.DateTim e' because it is a value type".

How do I set the field to null?

There should be newRow.SetDate_ PubNull() method generated for the typed dataset.

[Alan Pretre]

"John" <-wrote in message news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..

IIs there a way to set a SetDate variable to a special value that could
represent null? This would
make it easier for me since I'm returning a DateTime from a function, and
sometimes need to return
something that represents null.

You could use a DateTime as a nullable type:

private System.DateTime ? GetDate(bool Condition) {
return Condition ? (System.DateTim e.Now as System.DateTime ?) :
null;
}
-- Alan

[Sericinus hunter]

John wrote:

Thanks, that works.

IIs there a way to set a SetDate variable to a special value that could represent null? This would
make it easier for me since I'm returning a DateTime from a function, and sometimes need to return
something that represents null.

If you use .Net 2.0 then you can probably use nullable type.
I work with 1.1 and use DateTime.MinVal ue for this purpose.