Best Practice Updating Database Entries

Question

Say you get 100 entries and display them on a page. User updates only 2 records per page. Now you want to update only two records, not the other 98.

Is it best that a single message is sent on the page, then somehow find out which 2 updates, and then send only these two in db for the update?

What does it look like?

Or do you have an update-submit button for each row, and only it will update the record bound to it?

Answer 1

, . , , Javascript POST , . , :

1) ajax live -editing. , , . , , Javascript html- . - (, ), POST, ( ajax). , Javascript .

2) - , , . , javascript POST, , . , .

Answer 2

Ajax jQuery - JavaScript put update .

Answer 3

, - "" .

Ajax- , , Ajax .

, , , ADO.net .

, , : " !"

Answer 4

JavaScript, , . , , . ( is_dirty_ $id) JavaScript onChange, . - .

. . , , .

, last_modified . , , , , " ​​ " .

Answer 5

. , , . ( , - , .)

, :

JavaScript: onChange() , . , . JS , , .

: , . , , ( ). , - .

Sessions. You can put the original values ​​in session variables, and then perform a comparison when the values ​​return. This would be a little more elegant than a lot of hidden fields, and less open to people playing with data published back (since you should never trust anything that comes back, even in hidden fields). Requires browser cookies and server technology sessions.