Get value from gridview rowupdating ra vernon rules of dating

Every one can use it to compare the new value with old ones.

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.

Follow this link for more details --While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference.

Connection = conn2 sql = "SET DATEFORMAT dmy; SELECT * FROM XXXX " cmd. Execute Reader() Dim Temp Staff Key As Integer Dim Temp Post Key As Integer Dim Temp Shift Date As Date Time Dim Temp Start Time As Date Time Dim Temp End Time As Date Time Dim Temp SL As String Dim Temp Roster Key As Integer Dim Temp VL As String Dim Temp ML As String Dim Temp PH As String Dim Temp APH As String Dim Temp TOIL As String Dim Temp Others As String Dim Temp Shift Type As Integer Dim Temp Submitted By As Integer Dim dt As New Data Table() dt. Add(New Data Column("Staff Name", Get Type(String))) dt. Add(New Data Column("Post Code", Get Type(String))) dt. Add(New Data Column("Staff Key", Get Type(Int32))) dt. Add(New Data Column("Post Key", Get Type(Int32))) 'Monday dt. Add(New Data Column("Col1_Roster Key", Get Type(Int32))) dt. Add(New Data Column("Col1_Shift Date", Get Type(Date Time))) dt. Add(New Data Column("Col1_Start Time", Get Type(Date Time))) dt. Add(New Data Column("Col1_End Time", Get Type(Date Time))) dt. Add(New Data Column("Col1_SL", Get Type(String))) dt.

Add(New Data Column("Col1_VL", Get Type(String))) dt.

This will lead to problems like "Grid View does not show updated values", "Grid View looses values changed by user". In your Page_load, this is typically only inside a block where you check to make sure that Page_Load is not being called during a post-back call.

event is raised when a row's Edit button is clicked, but before the Grid View control enters edit mode.

To cancel the update operation, set the collections, if necessary, before the values are passed to the data source.

In my VB Gridview, I had bind several column from datatable into one single column of the gridview. The following is the VB code: Protected Sub Grid View1_Row Editing(By Val sender As Object, By Val e As Grid View Edit Event Args) 'Set the edit index. Bind Data() End Sub Protected Sub Grid View1_Row Canceling Edit(By Val sender As Object, By Val e As Grid View Cancel Edit Event Args) 'Reset the edit index. Edit Index = -1 'Bind data to the Grid View control.

But I have no idea how to get those value when doing Row Editing & Row Updating. Bind Data() End Sub Protected Sub Grid View1_Row Updating(By Val sender As Object, By Val e As Grid View Update Event Args) 'Retrieve the table from the session object.

Edit Index = -1 'Bind data to the Grid View control. Sql Command Dim sql As String Dim reader As System.

Sql Command Dim sql3 As String Dim reader3 As System.