C# – Advanced Sql generations Options window has radio buttons disabled

asp.netcgridview

If I open GridView’s Smart Tasks pop up –> Configure Data Source, then after Choose you data connection window I’m presented with the Configure the Select Statement window. This window also has Advanced button, which opens Advanced Sql Generations Options window. But both radio buttons in that window are faded out and thus I’m not able to select any of the two buttons.

Any idea why the two radio buttons are disabled?

thanx

Best Answer

Apparently the most common cause is that there is no primary key for the table defined in the database that is part of your SELECT statement.

Make sure that:

  1. You have a primary key column that is selected in the list of columns
  2. Your primary key column does not have a default value.
Related Topic