In retrieving the columns data type from a table by using 'OleDbSchemaGuid', the data_type returned is an integer. Could someone please explain the method of converting the integer data_type to its 'string name' eg 'Int16'.
Thankyou
Printable View
In retrieving the columns data type from a table by using 'OleDbSchemaGuid', the data_type returned is an integer. Could someone please explain the method of converting the integer data_type to its 'string name' eg 'Int16'.
Thankyou
Is this what you mean ?
VB Code:
Dim int As Integer = 321 Dim str As String = Convert.ToString(int) MessageBox.Show(Str)
Using 'OleDbSchemaGuid' and retrieving the Data_type for the columns, returns an integer value representing the data type eg integer = 2; Double = 5; date/time = 7 etc. My problem is trying to convert the returned value ie the integer into a string = 'Integer' and not just a conversion of data type from integer = 1 to string = 1.