I'm trying to update items in my SQL database from a ListView. It works, but all entries in the database update. Not just the one I'm working on. I backed up the database prior to testing, so there's not any issues there.

This is how my SqlDataSource UPDATE command is setup:

SQL Code:
  1. UPDATE entries SET duration = @duration, checkinDate = @checkinDate, receivedBy = @receivedBy, cosmeticDmgIn = @cosmeticDmgIn, status = N'closed'

I don't have any code setup to update the database, which is probably the issue.

When I load the ListView, select edit, type in my edits, and click "Update", all the rows in my database, for that column, are updated with that data.

I tried inserting the parameters manually, within the ItemUpdating event, but it never works.

Anyone have any ideas what I'm doing wrong?