Previous sample shows how to update the selected value of DropdownList nested inside the GridView control using Update command separately for each row item. But this sample shows how to edit the values of nested DropdownList controls and update the values in the database by clicking a single LinkButton placed in the HeaderTemplate of GridView control. For updating the values of all the DropdownList controls C# code for update command checks its old value and current value, if currently selectedvalue is different from the older one then it executes the SQL update command.
GridView Property Used
1. DataKeys
C# Method Used
1. FindControl