.netvb.nettableadapter

TableAdapter wizard not generating INSERT method - UPDATE and DELETE fine

I have inherited a project with an Access backend, using TableAdapters which I've not used before.

Most of the tables in the schema work fine, but a single one is not generating the INSERT statement and insert method.

I have checked everything mentioned here: http://msdn.microsoft.com/en-us/library/ms233812(vs.80).aspx

The adapter is using a simple query on a single table, the checkboxes for generating statements and methods are ticked and the table has a primary key. UPDATE and DELETE work fine.

Is there anything else that could be affecting this?

Solution

  • Go into the xsd file and look at the properties of the TableAdaptor, you should have an entry for InsertCommand. If this is missing you can add it manually.

    This assumes you are using an xsd file obviously.

    Edit:

    Have you tried adding a new TableAdaptor using the wizard attached to the same table to see if it generates without the insert command?