CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4

Hybrid View

  1. October 16th, 2002, 05:58 AM #1
    Royster
    Royster is offline Junior Member
    Join Date
    Feb 1999
    Posts
    16

    ADO.NET datatable and the column number limits

    Why is it that a datatable is limited to only 100 columns? This seems like a very unusual number to choose as a limit in any case.

    The annoying thing is that the only way I can see to get round this, is to create multiple data tables, with the primary key on each table, with a set of datarelations joining each primary key.

    This is very awkward!
    Reply With Quote Reply With Quote
  2. January 17th, 2013, 08:22 AM #2
    softnsolv
    softnsolv is offline Junior Member
    Join Date
    Jan 2013
    Posts
    2

    Resolved Re: ADO.NET datatable and the column number limits

    I am new to .net.. I have tested datatable with 1000 columns.. I did not get any issues.
    I believe there is no limit of columns.

    If you have to hit that limit, you've got bigger issues with your application...
    Reply With Quote Reply With Quote
  3. January 17th, 2013, 02:01 PM #3
    VictorN's Avatar
    VictorN
    VictorN is offline Elite Member Power Poster
    Join Date
    Jan 2003
    Location
    Wallisellen (Zürich), Switzerland
    Posts
    16,236

    Re: ADO.NET datatable and the column number limits

    LOL!
    It is very "useful" info for the OP who asked it more than a decade back!
    Victor Nijegorodov
    Reply With Quote Reply With Quote
  4. January 17th, 2013, 08:39 PM #4
    softnsolv
    softnsolv is offline Junior Member
    Join Date
    Jan 2013
    Posts
    2

    Re: ADO.NET datatable and the column number limits

    I know it's was asked very long back.. but you guys never think why still someone is posting the answer so late and just start making laughing
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


HTML5 Development Center

Click Here to Expand Forum to Full Width