IF 1-6 RECORDS comes from page 1 means how u stored that in table,do u maintain any Id for identify these records comes from this page?

If it so update by using that id.

If it not so u should maintain a common Id for all pages. U have to store that Id when u store records in ur table.

For example,

Table1

--------

Id name value pageId

----------------------------

1   a       a       1

2   b        b       1

3   c         c       2

 4   d        d      2

U shold have this type of table then only u have update or delete group of records at once.

EX:  Update Table1 set value="somethng" where pageId=2 

The above query can update multiple records at a single execution..