Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > What DataColumn.DataType do each of the SQL types map to?

Reply
Thread Tools

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

 
 
Nathan Sokalski
Guest
Posts: n/a
 
      12-24-2007
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

http://www.nathansokalski.com/


 
Reply With Quote
 
 
 
 
Guest
Posts: n/a
 
      12-26-2007
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" <> wrote in message
news:...
> 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
>
> http://www.nathansokalski.com/
>

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transform a 2D color image into 2 images of (R1,G1,B) at each pixelof image 1 and (R2,G2,B) at each pixel of image2 for STEREO visualization 88888 Dihedral C++ 10 12-23-2011 02:28 PM
ReadWriteLock rather on map's each field than whole map? easy Java 8 09-29-2007 07:45 PM
Array#each - getting each element and the index Pat Maddox Ruby 6 01-20-2006 04:04 PM
how do i? Full scan of each control in each grid row cell John Blair ASP .Net 1 08-03-2005 11:02 AM
xsl:for-each for each 3 elements problem Tjerk Wolterink XML 3 11-03-2004 05:22 PM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57