datatypes

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

get the correct datatype 4
datacolumn 1
Decimal datatypes as 'money' (currency) in ADO.NET? 3
Building parameters type conversion question. 4
Dynamically cast native datatypes without switch statement? 1
How to determine if a table has a column that is autoincrement(Identity)? 4
Fillschema does not import constraints 1
Retrieving database type via DataAdapter 3

Top