Previous sample shows how to update the selected value of DropdownList nested inside the ASP.Net GridView control with Update command separately for each row item using VB.Net code. But this sample will show you how to edit the values of nested DropdownList controls and update the values into the database by clicking a single LinkButton placed in the HeaderTemplate of the GridView control. For updating the values of all the DropdownList controls VB.Net code for update command has been used that checks the old value and new value by matching the new value with the value stored in the DataKeys collection, if currently selectedvalue is different from the older one then it executes the SQL update command.
GridView Property Used
1. DataKeys
VB.Net Method Used
1. FindControl
