Update and delete sql not generated by wizard

[John]

Hi

In my vb winform data app with sql server 2005 backend, when in dataset I
run the data adapter configuration wizard it generates insert and select sql
statements but not delete and update. As a result the data is not updated
when changed in form. What is the problem and how can I get the update and
delete statements generated?

Thanks

Regards

 

[RobinS]

I could swear I've answered this before. Isn't your data table empty? Did
you try adding data to your tables and regenerating the dataset to see if
that was the problem?

Robin S.

 

[John]

Plenty of data in there. I can insert data just not update. Any ideas?

Thanks

Regards

 

[Cor Ligthert [MVP]]

John,

I thought that it was when you was using timestamps, because in the other
situations I have tried it and it went well, however that was a while ago
that I did something with these generated statements.

Cor

 

[Earl]

You need to have a primary key defined.

 

[Earl]

It's funny how the same questions get asked and answered repeatedly on the
forums. While some may say that this is the user's fault, I would say that
it is a failure by Microsoft to make the "obvious" truly obvious and to do a
better job of explaining the "obvious". Too often, the information being put
out is too disjointed.

 

[RobinS]

And some people, not getting a response, or not getting the response they
want, post their questions more than once.

Robin S.
----------------------------------------

 

[RobinS]

Does your table have a primary key?

Robin S.
-----------------------------