gridview update table without identity field

[vcllvc]

I have a table which does not have an identity field.

When I need to update a row, I will pass in both old values and new values in the query to make sure I am updating the correct row.

If I have a gridview bind to the table, is there a way to update a row? Or I must add an identity field to get it work.

Thanks in advance.

 

[jbutton]

I don't know if I understand correct, but I think you can accomplish what you want with a WHERE clause on the update statement since you are also passing the old values.

UPDATE blah blah blah WHERE sqlField=oldValue AND sqlField2=oldValue2

sqlField and sqlField2 are the columns in the database and oldValue and oldValue2 are the old values you are passing.
don't know if that's what you're looking for but HTH.

 

[jbenson001]

you don't need an identity per se, but you should have a key column(s) on the table.