Checking if Date is Nothing

[rcolby]

Hi all,

I'm experiecing a problem with dates being returned from SQL 2000 Database.
I retrieve the last updated field (Date) from a sql 2000 and then compare
the returned date with another record I'm checking against, to see if they
are the same or if the returned value is nothing, checking to see if the
date are the same works if not nothing. I have tried the following:

Dim datDate As Date = Nothing

If dteSQLUpdate = datDate Then

-----

If dteSQLUpdate = nothing

Thanks
Richard

[Cor Ligthert]

RColby,

Try this sample I just made, I hope that you than you see how the dates work
in a datatable in VBNet (and therefore in a database)?

Cor

\\\Needs a new project with a datagrid on the form
Private Sub Form1_Load(ByVa l sender As _
Object, ByVal e As System.EventArg s) _
Handles MyBase.Load
'Making of the test datatable
Dim dt As New DataTable("Test ")
dt.Columns.Add( "Dat", GetType(System. DateTime))
For i As Integer = 0 To 5
Dim dr As DataRow = dt.NewRow
dr(0) = Now.AddDays(i)
dt.Rows.Add(dr)
Next
'Showing handling of the date in a datatable
dt.Rows(0)(0) = DBNull.Value
For Each dr As DataRow In dt.Rows
If dr(0) Is DBNull.Value Then
dr(0) = Now.AddDays(10)
End If
Next
DataGrid1.DataS ource = dt
End Sub
///

[Herfried K. Wagner [MVP]]

* "rcolby" <rc*******@hotm ailPLEASEREMOVE .com> scripsit:

I'm experiecing a problem with dates being returned from SQL 2000 Database.
I retrieve the last updated field (Date) from a sql 2000 and then compare
the returned date with another record I'm checking against, to see if they
are the same or if the returned value is nothing, checking to see if the
date are the same works if not nothing. I have tried the following:

'Date' is a value type and cannot be 'Nothing'. Take a look at the
'SqlDateTime' data type.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

[rcolby]

Thanks for the advise, really getting into programming again.

"rcolby" <rc*******@hotm ailPLEASEREMOVE .com> wrote in message
news:41******** *************@n ews.zen.co.uk.. .

Hi all,

I'm experiecing a problem with dates being returned from SQL 2000 Database. I retrieve the last updated field (Date) from a sql 2000 and then compare
the returned date with another record I'm checking against, to see if they
are the same or if the returned value is nothing, checking to see if the
date are the same works if not nothing. I have tried the following:

Dim datDate As Date = Nothing

If dteSQLUpdate = datDate Then

-----

If dteSQLUpdate = nothing

Thanks
Richard