Updating multiple rows on gridview
So, we should create another column with user’s list view for checkbox input.So, while printing user table entries dynamically to the list view, the loop should contain the following items.In the Data Access Layer we wrap the multiple Update operations within a transaction to ensure that all updates succeed or all updates are rolled back.In the preceding tutorial we saw how to extend the Data Access Layer to add support for database transactions.
We can get selected checkbox values via j Query AJAX post or by accessing the form from PHP after page refresh.
The HTML tags will recursively create with dynamic values for each iteration of the loop.
Checkbox added to each user’s row will contain their id, accordingly, as its value.
For demonstration I have created a database (named Database.mdf) in which we have a table named tbl_Employee.
We are well expertise with PHP CRUD operations by accessing My SQL via PHP logic.