smalldatetime Null in SQL for ASP.net Page

[Robert Willhite]

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
"Robert Willhite" <Ro************@discussions.microsoft.com> wrote in
message news:AB**********************************@microsof t.com...

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?

[Robert Willhite]

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" wrote:

Show some snippets
"Robert Willhite" <Ro************@discussions.microsoft.com> wrote in
message news:AB**********************************@microsof t.com...

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]

Good you got it working Robert
Patrick

"Robert Willhite" <Ro************@discussions.microsoft.com> wrote in
message news:21**********************************@microsof t.com...

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" wrote:

Show some snippets
"Robert Willhite" <Ro************@discussions.microsoft.com> wrote in
message news:AB**********************************@microsof t.com...

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?