-
Sep 16th, 2011, 01:27 PM
#1
[RESOLVED] ListView Edit - SqlDataSource - All Items Update
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:
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?
CodeBank contributions: Process Manager, Temp File Cleaner
Originally Posted by SJWhiteley
"game trainer" is the same as calling the act of robbing a bank "wealth redistribution"....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|