100 column limit in DataAdapter Configuration Wizard (321910)


The information in this article applies to:

  • Microsoft Visual Studio .NET (2003), Professional Edition
  • Microsoft Visual Studio .NET (2003), Enterprise Architect Edition
  • Microsoft Visual Studio .NET (2003), Enterprise Developer Edition
  • Microsoft Visual Studio .NET (2003), Academic Edition
  • Microsoft Visual Studio .NET (2002), Professional Edition
  • Microsoft Visual Studio .NET (2002), Enterprise Architect Edition
  • Microsoft Visual Studio .NET (2002), Enterprise Developer Edition
  • 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 "SqlDataAdapter1" , 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.

MORE INFORMATION

Steps to reproduce the behavior

  1. Start Microsoft Visual Studio .NET.
  2. On the File menu, point to New, and then click Project.
  3. Click Visual Basic Projects under Project Types, and then click Windows Application under Templates.
  4. Add a SqlDataAdapter object to the form.
  5. 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.
  6. When you are prompted for a Query Type, click Use SQL Statement, and then type the following SQL statement:
    Select * from BigTable
  7. Click Next. You receive the error message that is listed in the "Symptoms" section.
Modification Type:MajorLast Reviewed:11/16/2005
Keywords:kbDataAdapter kbpending kbprb kbSystemData KB321910
©2004 Microsoft Corporation. All rights reserved.