Message End If End Sub // Assumes that connection is a valid Sql Connection object. Row Updating -= new Sql Row Updating Event Handler(On Row Updating); cust Adapter. Add(New Object() _ ) ' Set the Row Error containing the value for the third column.
Text; returns the the value of the "decription" which existed prior to typing in the new value. Thus every time I would click on Update, the data would get bound to the grid again after fetching the same data from the data base. I have a webpage that has a grid that allows select as well as edit. When I attempt to get to values in the rowupdating event I get the old values (which makes sense from your post). My question is that when I add the binding code inside If Not Page. 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.Dim cust Adapter As Sql Data Adapter = New Sql Data Adapter( _ "SELECT Customer ID, Company Name FROM Customers", connection) ' Add handlers. Row Updating, New Sql Row Updating Event Handler( _ Address Of On Row Updating) Add Handler cust Adapter. Row Updating, _ New Sql Row Updating Event Handler(Address Of On Row Updating) Remove Handler cust Adapter. Row Updated, New Sql Row Updated Event Handler( Address Of On Row Updated) ' Set Data Adapter command properties, fill Data Set, and modify Data Set. Update(cust DS, "Customers") ' Remove handlers. Row Updated, _ New Sql Row Updated Event Handler(Address Of On Row Updated) Private Shared Sub On Row Updating(sender As Object, _ args As Sql Row Updating Event Args) If args.