Microsoft KB Archive/321910

= 100 column limit in DataAdapter Configuration Wizard =

Article ID: 321910

Article Last Modified on 11/16/2005

-

APPLIES TO


 * Microsoft Visual Studio .NET 2003 Professional Edition
 * Microsoft Visual Studio .NET 2003 Enterprise Architect
 * Microsoft Visual Studio .NET 2003 Enterprise Developer
 * Microsoft Visual Studio .NET 2003 Academic Edition
 * Microsoft Visual Studio .NET 2002 Professional Edition
 * Microsoft Visual Studio .NET 2002 Enterprise Architect
 * Microsoft Visual Studio .NET 2002 Enterprise Developer
 * Microsoft Visual Studio .NET 2002 Academic Edition

-



This article was previously published under Q321910



SYMPTOMS
When you try to use the DataAdapter Configuration Wizard on a table that has more than 100 columns, you receive the following error message:

The wizard detetected the following problems when configuring the data adapter &quot;SqlDataAdapter1&quot;, Generated SELECT statement. The data adapter cannot be configured for tables that have more than 100 columns.



RESOLUTION
To resolve this problem, manually configure the DataAdapter object, or select fewer columns.



STATUS
This behavior is by design.



Steps to reproduce the behavior
 Start Microsoft Visual Studio .NET. On the File menu, point to New, and then click Project. Click Visual Basic Projects under Project Types, and then click Windows Application under Templates. Add a SqlDataAdapter object to the form. When the DataAdapter Configuration Wizard appears, select an existing data connection, or create a new data connection for a table that has more than 100 columns.  When you are prompted for a Query Type, click Use SQL Statement, and then type the following SQL statement: Select * from BigTable </li> Click Next. You receive the error message that is listed in the &quot;Symptoms&quot; section.</li></ol>

Keywords: kbsystemdata kbdataadapter kbprb kbpending KB321910

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.