colum limitation

  • Thread starter Thread starter Fei
  • Start date Start date
F

Fei

hi,

I got a problem. I just want to know why. I use Data adapter configuration
wizard to build a strongly typed data adapter. But it always fails to
generate data adapter. Since the table has more than one hundred columns, is
this reason ? Because when I select less than 100 columns, it will be ok to
generate the data adapter. So my guess is that 100 is the upper bound.
Please confirm my guess if you know answer.

Thanks in advance !

Fei
 
Strongly typed dataadapter? What fails in the generate portion, everything
or just Update, Delete, Insert? If it's the latter, then the most likely
culprit is lack of a key on the table.

Are you using a Strongly Typed DataSet? 100 isn't not the upper bound, so
that's not the problem ;-).

Can you post the code and the schema of the table, that would really help.

Bill
 
Is the table normalized? I expect you're repeating columns that could be
stored in other related tables.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
William Ryan said:
Strongly typed dataadapter? What fails in the generate portion, everything
or just Update, Delete, Insert? If it's the latter, then the most likely
culprit is lack of a key on the table.
Click to expand...

It fails at generating Select statment.
Message is
'There were errors configuring the data adapter.'
Are you using a Strongly Typed DataSet? 100 isn't not the upper bound, so
that's not the problem ;-).
Click to expand...
Yes. I use a strongly typed dataset. But when I manually config data adapter
as long as less than 100 columns, it will be ok.
Can you post the code and the schema of the table, that would really help.
Click to expand...
I simply drag a table from my server explorer, and drop it in my application
.. I will get that message. So no code .
 
Thanks for your information. It helps a lot. I am not sure 'add others by
hand'. Do you mean add others as expression columns ? Can I put others into
the data set at the design time ?

Thanks ! Please help me out.

Fei

Miha Markic said:
Hi,

Yes, this is a known problem of DataAdapter wizard.
See http://tinyurl.com/26zll.
A workaround is to configure adapter manually (select less then 100 columns
and add others by hand).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Fei said:
hi,

I got a problem. I just want to know why. I use Data adapter configuration
wizard to build a strongly typed data adapter. But it always fails to
generate data adapter. Since the table has more than one hundred
Click to expand...
columns,
is
this reason ? Because when I select less than 100 columns, it will be ok to
generate the data adapter. So my guess is that 100 is the upper bound.
Please confirm my guess if you know answer.

Thanks in advance !

Fei
Click to expand...
Click to expand...
 
Back
Top