How to get SqlDBType using ADO.NET

[Greg]

Hi
I am retrieving some records from SQLCE database and storing them in DataSet
I am trying to get database columns DataTypes

Using my_dataset.Mytable.My_column.DataType gives me System.Type, not SqlDbType

How I could get SqlDbType….

Any suggestions would be really appreciated

Thank you

Gre

[Miha Markic [MVP C#]]

Hi Greg,

You can't. DataSet (DataTable, DataColumn, ..) is database neutral.
You might check the default mapping, though, reading SqlDbType Enumeration
..net help topic.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Greg" <an*******@discussions.microsoft.com> wrote in message
news:82**********************************@microsof t.com...

Hi,
I am retrieving some records from SQLCE database and storing them in DataSet. I am trying to get database columns DataTypes .

Using my_dataset.Mytable.My_column.DataType gives me System.Type, not SqlDbType.
How I could get SqlDbType..?

Any suggestions would be really appreciated,

Thank you,

Greg