First, I am using an asp:DataList, which does not allow AutoGenerateColumns=”False”

dr = cmd.ExecuteReader()
lstActivePatients.DataSource = dr
lstActivePatients.DataBind()

I am returning four values from my sproc to my web page: (0) RegistrationID, (1) Registrant, (2) RegistrationDate, and (3) ConfirmationDate

In my sproc, if the ConfirmationDate IS NULL I set it equal to ‘incomplete’, so the value returned to my aspx page is either a date or ‘incomplete’

This is the code in my DataList: if Container.DataItem(3) is not null and is a date then I want the date to show as a link; if Container.DataItem(3) is null then I simply want to show the word incomplete as text.

<td><asp:Hyperlink id="lnkConfirmation" Text='<%# Container.DataItem(3) %>' NavigateUrl='<%# "PatReg_Confirmation2.aspx?id=" & Container.DataItem(0) %>' runat="server" /></td> </tr> </ItemTemplate>

Function ShowLink(val)
  If val = ‘incomplete’ Then
    ShowLink = "Incomplete"
  Else
    ShowLink = "<a href=’RegConfirmation.aspx?id=” & QUERYSTRING & “’>DATE</a>"
  End If
End Function

I don’t know how to set the QUERYSTRING = Container.DataItem(0) and DATE = Container.DataItem(3) in the Helper Function above.

Thanks in advance for any help,

John

This should do it:

...
<%# ShowLink(Container.DataItem(0), Container.DataItem(3)) %>
</ItemTemplate>


Function ShowLink(queryString, date)
  If date = ‘incomplete’ Then
    Return "Incomplete"
  Else
    Return String.Format("<a href=’RegConfirmation.aspx?id={0}’>{1}</a>", queryString, date)
  End If
End Function

Peter
-------------------------
Work smarter, not harder