Problem with datarow

[MrNorth]

Ok, Im iterating through a datatable, and I have a problem:

For Each dr In dt.Rows
Try
litShipNo.Text = CStr(dr("SHIPMENT_ID"))

etc etc...

as you can see Im casting every value to string because I want to show them as literate text. But I ahve a problem with when the column is of value DBNull, then I get an exception, and I am not sure how to handle it... can anyone give a suggestion?


kind regards
Henrik

[si_the_geek]

I havent used VB.Net, but this works in VB6:

litShipNo.Text = CStr(dr("SHIPMENT_ID") & "")

or:

If IsNull(dr("SHIPMENT_ID")) Then
  litShipNo.Text = "Null"
Else  
  litShipNo.Text = CStr(dr("SHIPMENT_ID"))
End If