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!