CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
+ Reply to Thread
Results 1 to 4 of 4
  1. October 16th, 2002 05:58 AM #1
    Royster
    Royster is offline Junior Member Royster is an unknown quantity at this point (<10)
    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 softnsolv is an unknown quantity at this point (<10)
    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 VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+) VictorN has a reputation beyond repute (3000+)
    Join Date
    Jan 2003
    Location
    Wallisellen (Zürich), Switzerland
    Posts
    16,177

    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 softnsolv is an unknown quantity at this point (<10)
    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
+ Reply to Thread
« 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