finding the datatype of a column in a datatable

[wapsiii]

How do I query the datatype of a column in a datatable (Ineed to find
the smalldatetime datatypes in a ms sql produced datatable).

I'm trying this, but is isn't quite right:

For i As Byte = 0 To dt.Columns.Count
If TypeOf dt.Columns(i) Is DateTime Then
' can't find it
End If
Next

 

[wapsiii]

Is this the way?

'For i As Byte = 0 To dt.Columns.Count
' If dt.Columns(i).DataType Is GetType(DateTime) Then

' End If
'Next

 

[Shimon Sim]

Check Columns(i).DataType