DeleteCommand & UpdateCommand

[johncassell]

Hi There,

can someone tell me what I am doing wrong here please..

I have one table 'WS_Jobs' and I have a tableadapter.

When I view the properties of the tableadapter, I have a SelectCommand, DeleteCommand and an UpdateCommand.

The Delete and Update are both set as none and when I try to edit this, the CommandText fields are both empty (Expecting me to create the text) -I am sure VS can do this itself without me doing it??

Thanks

John

 

[cjard]

The table has no PK, VS2005 cannot work out how to uniquely ID exactly one row, ergo no DELETE or UPDATE targeting exactly one row can be formed

 

[johncassell]

Thanks Cjard, solution was exactly as described!

Thanks very much

John