Member Avatar for cjoyce

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.

  • 3 Contributors
  • 2 Replies
  • 89 Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for Ancient Dragon

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.

Edited by Ancient Dragon because: n/a
commented: Hi! Happy New Year! Sir. :) +11
Member Avatar for kvprajapati

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.