Hi Jim,
In this case, I'd use a helper function to get around the complicated IIF
stuff.
The problem is that you've got to be ready for a DBNull at any time, so it's
easier to look at it as an Object.
Here's a little helper function that might do what you need. The complete
source is below.
Function fixnull(ByVal datetm As Object) _
As String
If IsDBNull(datetm ) Then
Return "No Date"
End If
Return FormatDateTime( datetm, vbShortDate)
End Function
Let us know if this helps?
Ken
Microsoft MVP [ASP.NET]
<%@ page language="VB" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
<script runat="server">
Protected Sub Page_Load _
(ByVal sender As Object, _
ByVal e As System.EventArg s)
If Not IsPostBack Then
Repeater1.DataS ource = CreateDataSourc e()
Repeater1.DataB ind()
End If
End Sub
Function fixnull(ByVal datetm As Object) _
As String
If IsDBNull(datetm ) Then
Return "No Date"
End If
Return FormatDateTime( datetm, vbShortDate)
End Function
Function CreateDataSourc e() As Data.DataTable
Dim dt As New Data.DataTable
Dim dr As Data.DataRow
dt.Columns.Add( New Data.DataColumn _
("ShippedDat e", GetType(DateTim e)))
dt.Columns.Add( New Data.DataColumn _
("StringValu e", GetType(String) ))
dt.Columns.Add( New Data.DataColumn _
("CurrencyValue ", GetType(Double) ))
dt.Columns.Add( New Data.DataColumn _
("Boolean", GetType(Boolean )))
Dim i As Integer
For i = 0 To 5
dr = dt.NewRow()
If i = 3 Then
dr(0) = System.DBNull.V alue
Else
dr(0) = Now.AddDays(i)
End If
dr(1) = "Item " + i.ToString()
dr(2) = 1.23 * (i + 1)
dr(3) = (i = 4)
dt.Rows.Add(dr)
Next i
Return dt
End Function
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Fix a DBNull problem</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:repeater id="Repeater1" runat="server">
<itemtemplate ><p>
<asp:label id="Label6" runat="server" text='<%#
fixnull(Eval("S hippedDate")) %>'></asp:label></p>
</itemtemplate>
</asp:repeater>
</div>
</form>
</body>
</html>
"Jim Florence" <fl************ @hotmail.com> wrote in message
news:2C******** *************** ***********@mic rosoft.com...
Hello,
I've just started in ASP and I'm having a few teething problems. Initially
I tried to write out dates from the database using
<asp:Label runat="server" ID="Label6" Text='<%# Eval("ShippedDa te") %>
But I got a problem with DBNull's, a kind sould told me to look at using
IIF and that sorted part of the problem. It bypassed the Nulls but didn't
actually put the text in that I'd put in the statement.This is the code
asp:Label runat="server" ID="Label10" Text='<%# IIF (Eval("ShippedD ate")is
nothing,"My Text",Container .DataItem("Ship pedDate")) %>' />
After more digging I changed the code to the floowing to check for dbnull
and the text finally appeared on the page.
<asp:Label runat="server" ID="Label6" Text='<%# IIF (typeof (
Eval("ShippedDa te") ) is DbNull ,"No Date",Eval("Shi ppedDate")) %>' />
The final piece I was trying to do was convert the date to a shortdate and
used the folowing code.
<asp:Label runat="server" ID="Label6" Text='<%# IIF (typeof (
Eval("ShippedDa te") ) is DbNull ,"No
Date",FormatDat eTime(Eval("Shi ppedDate"),vbSh ortDate)) %>' />
This now again gives me a "Conversion from type 'DBNull' to type 'Date' is
not valid." when I run the code.
I'm now officially confused, any help gratefully recieved
Regards
Jim Florence
