Limit on number of columns in dataadapter?

[Guest]

Is there a limit on the number of columns in a dataadapter?

 

[Sahil Malik]

Do you mean DataReader?

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
http://blogs.apress.com/authors.php?author=Sahil Malik

 

[Guest]

no dataadapter. trying to add about 50 columns to a dataadapter but it's not
taking them. If i knock it down to 30 it works.

 

[Sahil Malik]

Hmm .. I think I am missing your point, the class SqlDataAdapter doesn't
have a columns collection on it; only commands and a fill method (to fill a
dataset/datatable) and a few other things. Tell me what exactly are you
doing, and if possible paste some code.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
http://blogs.apress.com/authors.php?author=Sahil Malik

 

[Guest]

I have the same problem. It makes the Visual Studio solution no more than a
toy and not suitable for industrial strength development.