smalldatetime Null in SQL for ASP.net Page

[Guest]

I have a database with a field used for an approval date set as a
smalldatetime. When the record is initially written it is intended to be
reviewd and approved. However until it is approved it has a null value,
which throws an error in the ASP page that is intended to be used to review
and update. The error is th DBNull to DateTime conversion error.

Any Suggestions?

 

[Patirck Ige]

Show some snippets

 

[Guest]

Patirck,

Thanks for the quick response. I actually found the solution and will
include it for any other searches

My old code was:

Request.ApprovedDate = drRequests.Item("ApprovedDate")

I wrote new code as follows:

If IsDBNull(drRequests.Item("ApprovedDate")) Then
Request.ApprovedDate = " "
Else
Request.ApprovedDate = Format(drRequests.Item("ApprovedDate"), "d")
End If


Thanks,

 

[Patirck Ige]

Good you got it working Robert
Patrick

Patirck,

Thanks for the quick response. I actually found the solution and will
include it for any other searches

My old code was:

Request.ApprovedDate = drRequests.Item("ApprovedDate")

I wrote new code as follows:

If IsDBNull(drRequests.Item("ApprovedDate")) Then
Request.ApprovedDate = " "
Else
Request.ApprovedDate = Format(drRequests.Item("ApprovedDate"), "d")
End If


Thanks,