datatypes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all

i am getting my db schema using GetOleDbSchemaTable method ... the question is
when i try to get the column information for a particular table (ie)

DataTable schemaTable = myConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns
new object[] {null, null, DBTable})

it returns datatypes for the columns as an integer value ... i have figured out that these value
are part of the ado.net datatypes (ie) 202 = nvarchar in a SQL Server D

my question is there a method to figure out the datatype name (such as varchar, nchar) from the
datatype enum value (202, 130)

thanks in advanc
joe
 
Try this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;30968

----- joe wrote: ----

Hello all

i am getting my db schema using GetOleDbSchemaTable method ... the question is
when i try to get the column information for a particular table (ie)

DataTable schemaTable = myConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns
new object[] {null, null, DBTable})

it returns datatypes for the columns as an integer value ... i have figured out that these value
are part of the ado.net datatypes (ie) 202 = nvarchar in a SQL Server D

my question is there a method to figure out the datatype name (such as varchar, nchar) from the
datatype enum value (202, 130)

thanks in advanc
joe
 
Back
Top