Bonnie, you will love this as an answer

How about:-

row.IsNull((col))

or put in context

Dim row As DataRow
For Each row In dt.Rows
For Each col In dt.Columns
If row.IsNull((col)) Then
Console.WriteLine(col.ColumnName & " - " & col.DataType.ToString & " : null")
Else
Console.WriteLine(col.ColumnName & " - " & col.DataType.ToString & " : " & _
CType(row(col), String))
End If
Next
Next

but it still doesn't answer the question about byte,
hence my actual code looks like this


'test code
Dim col As DataColumn
For Each col In dtTscope.Columns
Console.WriteLine(vbTab & col.ColumnName & " - " & col.DataType.ToString)
Next col


Dim row As DataRow
For Each row In dtTscope.Rows
For Each col In dtTscope.Columns
Try
If row.IsNull((col)) Then
Console.WriteLine(col.ColumnName & " - " & col.DataType.ToString & " : null")
Else
Console.WriteLine(col.ColumnName & " - " & col.DataType.ToString & " : " & _
CType(row(col), String))
End If
Catch ex As Exception
MsgBox(ex.ToString & vbCrLf & vbCrLf & ex.Message & vbCrLf & vbCrLf & col.DataType.ToString)

End Try
Next
Next


PS How do you mark code as not formatted, explain to some one who has never seen html, its not my thing (yet??)