Results 1 to 3 of 3

Thread: OleDbSchemaGuid data_type conversion

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2002
    Location
    West Australia
    Posts
    9

    OleDbSchemaGuid data_type conversion

    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

  2. #2
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,083
    Is this what you mean ?
    VB Code:
    1. Dim int As Integer = 321
    2. Dim str As String = Convert.ToString(int)
    3. MessageBox.Show(Str)

  3. #3

    Thread Starter
    New Member
    Join Date
    Jun 2002
    Location
    West Australia
    Posts
    9

    No, a little different from that

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width