set field to dbnull?

In the following code the line: row("OrderDate") = DBNull is invalid. But,
how can I set the field to DBNull?

Thanks,

Gary

daClearOrders.Fill(DsClearOrders1)

Dim row As DataRow

For Each row In DsClearOrders1.Inventory.Rows

row("QuantityOrdered") = 0

row("OrderDate") = DBNull (this doesn't work)

Next

daClearOrders.Update(DsClearOrders1)Hi Gary,

Try assigning DBNull.Value instead of DBNull.

Harold

"Gary" <Gary@.nospam.com> wrote in message
news:etjh3kRGEHA.688@.tk2msftngp13.phx.gbl...
> In the following code the line: row("OrderDate") = DBNull is invalid.
But,
> how can I set the field to DBNull?
> Thanks,
> Gary
> daClearOrders.Fill(DsClearOrders1)
> Dim row As DataRow
> For Each row In DsClearOrders1.Inventory.Rows
> row("QuantityOrdered") = 0
> row("OrderDate") = DBNull (this doesn't work)
> Next
> daClearOrders.Update(DsClearOrders1)