Difference between rowediting and rowupdating in gridview
After searching long and hard I found a great article that solved my issue.
Take a look at the page load if you are binding on post back then the values get updated before you are able to access them.
The values are retrieved using a Sql Data Source control.
I have previously posted an article on how to insert new rows in database using a Grid View.We have selected four columns from Employee Details table.To provide flexibility, the Grid View offers the Template Field, which renders using a template. Control Value Property("Selected Value")] public class Grid View : System. When this property is set, the data rows are displayed alternating between the Row Style settings and the Alternating Row Style settings.
The Columns collection stores all the column fields in the control and enables you to programmatically manage the column fields in the Grid View control. For more information, see Introduction to the Validation Controls.