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
njsokalski (AT) hotmail (DOT) com
http://www.nathansokalski.com/

"Nathan Sokalski" <njsokalski (AT) hotmail (DOT) com> wrote


[cross-posting removed]

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" <njsokalski (AT) hotmail (DOT) com> wrote