What DataColumn.DataType do each of the SQL types map to?

  • Thread starter Thread starter Nathan Sokalski
  • Start date Start date
N

Nathan Sokalski

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.
 
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
 
Back
Top