how to know the datatype of a field in a database?

[kalaveer]

hi, in the sql we have user_tab_coloumns to know the datatype of a field in a table by properly querying but my problem is i am using an oledbconnection in C# to connect to an access database and i want to know the datatype of a field of a table in that perticular database how to do that? pls help me. thanx in advance.

[andyharman]

How about the DbConnection.GetSchema method?

[kalaveer]

how that helps?:confused:

[andyharman]

It allows you to use c# to get the details of a database table, and its columns. Isn't that what you asked for?

[ScottM1]

Check out OleDbDataReader.GetDataTypeName(index) or OleDbDataReader.GetFieldType(index) Never tried it myself but should work ;)

There are 10 types of people in the world, those who understand binary and those who dont.