none
dynamic sql generation for the UpdateCommand is not supported against RRS feed

  • Question

  • My code works fine with SQL Server but it fails on MS ACCESS.

     

    adapter.Update(userTable)

     

    dynamic sql generation for the UpdateCommand is not supported against a select command.......

     

    any idea on it.

     

    All i am doing is to update record in DataGridview inside the Grid and click the Update button.

     

    thanks,

     

    Thursday, March 27, 2008 9:16 PM

All replies

  • Most likely your SELECT SQL statement is too complex or your table in Access database has no primary key and provider fails to generate appropriate INSERT/UPDATE/DELETE SQL statements based on your SELECT statement. In this case you would need explicitely specify these statemens for InsertCommand, UpdateCommand and DeleteCommand of your DataAdapter

    Monday, March 31, 2008 9:53 AM
    Moderator