CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    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!

  2. #2
    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...

  3. #3
    VictorN's Avatar
    VictorN is online now Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,395

    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

  4. #4
    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

Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured