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

Discussion in 'ASP .Net' started by Nathan Sokalski, Dec 24, 2007.

  1. 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/
    Nathan Sokalski, Dec 24, 2007
    #1
    1. Advertising

  2. Nathan Sokalski

    Guest Guest

    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/
    >
    Guest, Dec 26, 2007
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. dna
    Replies:
    1
    Views:
    1,264
  2. =?Utf-8?B?QWxlc3NhbmRybyBSb3NzaQ==?=

    UserControl in Template DataColumn

    =?Utf-8?B?QWxlc3NhbmRybyBSb3NzaQ==?=, Feb 26, 2004, in forum: ASP .Net
    Replies:
    3
    Views:
    458
    Martin Dechev
    Feb 26, 2004
  3. Jay Balapa
    Replies:
    1
    Views:
    7,963
    Bjorn Abelli
    May 4, 2006
  4. Jeff
    Replies:
    2
    Views:
    1,127
    Steve C. Orr [MCSD, MVP, CSM, ASP Insider]
    Apr 16, 2007
  5. easy
    Replies:
    8
    Views:
    390
Loading...

Share This Page