To String() Dim str Last Name As String = Direct Cast(Grid View1. Text Dim command As Sql Command = New Sql Command("updatetest", cn) command. If you reset the Data Source at this stage, your values for updating will be lost. I actually don't know how to write the Row Updating function, I just found it from the internet, and so of course it's not working. Please give some references and/or details of how to. Ok what's happening is that you are binding the data source for the Grid View every time a postback occurs in the Page_Load method. Count ----------- The most common problem for losing new data entered while updating a Grid View or Data Grid is that you are resetting the Data Source for the Grid View or Data Grid in the Page_Load method. I actually don't know how to write the Row Updating function, I just found it from the internet, and so of course it's not working.' Assumes that connection is a valid Sql Connection object. 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. Close() End If End Sub the problem is that the event row Updating is returning the old values so how can i get the new values for the update?
It doesn't look like its possible to retrieve new values if there is a gridview without datasource. Please remember to use [code] tags when you post code. I just need the data, and I'll then run a stored procedure to update the values, THEN re-query it. The Confirm and Scrap commands all work fine, as do my refresh and display routines. -Frinny I had exactly the same problem and finally with my colleague's help we found the mistake.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. Close() End If End Sub Private Shared Sub On Row Updated( _ sender As Object, args As Sql Row Updated Event Args) If args. This is becoming so frustrating it's getting almost comical. Breakpoints were triggered for the Row Editing and Row Command. David I suggested that the Row Updating function was being blocked by the . Data Bind() in the Row Command event so that only the Edit command will activate it (take it out of Row Editing). Twice for Row Command (1 for Row Editing and 1 for Row Canceling) and once for Row Editing. I am going to try and create this not as a web application but rather as a website and see if I notice any differences. Sql Data Adapter cust Adapter = new Sql Data Adapter( "SELECT Customer ID, Company Name FROM Customers", connection); // Add handlers. Row Updating = new Sql Row Updating Event Handler(On Row Updating); cust Adapter. Row Updated -= new Sql Row Updated Event Handler(On Row Updated); protected static void On Row Updating( object sender, Sql Row Updating Event Args args) protected static void On Row Updated( object sender, Sql Row Updated Event Args args) Add Handler adapter. Overflow Exception") Then ' Code to handle precision loss. 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. So what you need to do is store the data source (maybe in Session) and only bind rebind the data when you absolutely need to (Like during the Is Not Post Back) Do you understand? Please post the code for your Page_Load method and the that handles your Update (your C# code) so we can have a better look at what's going on. Please give some references and/or details of how to. This wipes out the data provided by the user during editing (editing happens after the page load). Add With Value("@pfirstname", str Last Name) If cn. Notice that the programing is not running the event Row Updated any help?