hey guys i really can't solve this problem, hope you can help me.

the problem is, i use this codes to get the data type of a column from an access database

Form12.ListView1.Items(j).SubItems.Add(myData.Rows(i)!DATA_TYPE)

but what displays in my listview are numbers like (130 , 3 so on..).
How can i get their actual data type like (text,number and so on..)

i've already spent hours searching the web and tried different codes like casting it to string/oledbtype but it still don't work..

please help.

Recommended Answers

Those numbers are the data types. They should be defined in one of the header files you have to include in your program. Here is a complete list.

Jump to Post

All 2 Replies

Those numbers are the data types. They should be defined in one of the header files you have to include in your program. Here is a complete list.

commented: Hi! Happy New Year! Sir. :) +11

Use myData.Columns("column_name").ColumnType.ToString() or myData.Columns(column_ordinal).ColumnType.ToString()

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.