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!
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...
Re: ADO.NET datatable and the column number limits
LOL! :D
It is very "useful" info for the OP who asked it more than a decade back!
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 :p