TableAdapter does not have an UpdateCommand? RRS feed

  • Question

  • I have a Dataset created from an SQL DataSource.

    Recently, I added one extra Table to the underlying Database. When I updated the DataSource, I selected the new Table. But, for some reason, the DataAdapter created for that Table only has a SELECT Command; no UPDATE Command of any kind.

    I tried to create the missing UPDATE Command text, as best as I could, but I invariably get syntax error.

    I tried a number of things, like trashing and recreating the whole dataset, fresh, from the data source to no avail, that newly added table refuses to come up with an UPDATE Command. 

    Friday, June 5, 2020 6:24 PM


  • Found the answer: the table did not have a PrimaryKey!!!!!!!
    • Marked as answer by roger.breton Friday, June 5, 2020 6:40 PM
    Friday, June 5, 2020 6:40 PM