When a DataTable is filled using something such as a DataAdapter, what
values are assigned to each of the DataColumns' DataType property for the
different SQL types? Thanks.
--
Nathan Sokalski
(E-Mail Removed)
http://www.nathansokalski.com/

"Nathan Sokalski" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

[cross-posting removed]

> When a DataTable is filled using something such as a DataAdapter, what
> values are assigned to each of the DataColumns' DataType property for the
> different SQL types? Thanks.

http://www.google.co.uk/search?sourc...T+datatype+SQL


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Hi,

the .NET data types are asigned, because if you load data by adapter,
it's all loaded to an ordinary DataTable, so int is converted to
System.Int32, char, varchar and text are converted to string, bit to bool
and so on.

Regards,

Lukas Holota

"Nathan Sokalski" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When a DataTable is filled using something such as a DataAdapter, what
> values are assigned to each of the DataColumns' DataType property for the
> different SQL types? Thanks.
> --
> Nathan Sokalski
> (E-Mail Removed)
> http://www.nathansokalski.com/
>