Q: Type of Column

[Geoff Jones]

Hi

How can I check the DataType of a column in a DataTable?

Could you give some example code?

Ta

Geoff

 

[Jay B. Harlow [MVP - Outlook]]

Geoff,
You can check the DataColumn.DataType property.

http://msdn.microsoft.com/library/d...lrfSystemDataDataColumnClassDataTypeTopic.asp

Dim table As DataTable

For Each column As DataColumn in table.Columns

If column.DataType Is GetType(DateTime) Then
' do something interesting with a DateTime column
End If

Next

Hope this helps
Jay

 

[One Handed Man \( OHM - Terry Burns \)]

Tables(0).Column(0).DataType


--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing