DataAdapter number of columns limitation?

  • Thread starter Thread starter Kamil
  • Start date Start date
K

Kamil

Hi

I'm trying to write strongly typed dataset.
Ma DB has Tables with more then 100 columns each.
Creating DataAdapter, DataSet and DataAdapter Commands by
wizard fails. Doing it manually is not pleaserfull.
I've discovered that when number of columns in table
exceedes 100 Then DataAdapter fails on creating Insert,
Update, Delete, Commands.
Why is it happening? Can I avoid it somehow
I'll add that I'm using C# and Access 2002.

Thanks for help
Kamil
 
Hi Kamil,

If I remember properly, this is known limitation of designer.
If you wait for a day or two, I'll have an automated solution for you.
 
Back
Top