can't fetch updated value in edit mode

i have a datagrid on a web page which is bound to an OLEDB datasource.  It queries data fine but when i try to retrive the value of a cell when Edit mode, it simply returns the previous data.  I have tried to fetch the data in the RowUpdating event, but it is the old data.  The RowUpdated event doesn't even fire.  How do i retrieve the updated values?  I'm trying to "intercept" the update and apply an update statement of my own.
Protected Sub GV1_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GV1.RowUpdating
        Dim txtActive As TextBox = DirectCast(GV1.Rows(e.RowIndex).Cells(2).Controls(0), TextBox)
        Dim strActive As String = txtActive.Text  'This always returns the old value
 
        Dim txtID As TextBox = DirectCast(GV1.Rows(e.RowIndex).Cells(1).Controls(0), TextBox)
        Dim strID As String = txtID.Text   'This always returns the old value
 
        Dim txtPerson As TextBox = DirectCast(GV1.Rows(e.RowIndex).Cells(3).Controls(0), TextBox)
        Dim strPerson As String = txtPerson.Text    'This always returns the old value
 
        Dim txtZip As TextBox = DirectCast(GV1.Rows(e.RowIndex).Cells(4).Controls(0), TextBox)
        Dim strZip As String = txtZip.Text
        Dim strCmd As String
 
        strCmd = "Update PurchaseList SET Available = " & strActive & ",  UserName =  '" & strPerson & "', PurchaseZip = " & strZip & " WHERE ID = " & strID
 
        Dim strConnection As String = System.Configuration.ConfigurationManager.AppSettings("ConnectionStr")  'Get Connection string from Web.Config file
        Dim myCon As New OleDbConnection(strConnection)
        myCon.Open()
 
        Dim myCmd As New OleDbCommand(strCmd, myCon)
        myCmd.ExecuteNonQuery()
        Me.GV1.EditIndex = -1
        myCon.Close()
        Me.ProcessGridView()
 
    End Sub

Open in new window

lanier3532Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Obadiah ChristopherCommented:
Try the rowCommand event, any event of grid will first fire the rowcommand event
lanier3532Author Commented:
That doesn't seem to give me access to the new grid values entered during edit mode, only the command arguments.  I must be missing something.  I've attached a screen shot of the edit session.

As you can see from the screen shot, i've changed the value of Active from 1 to a 0.  After pressing the Update link, when i try to access the cell data using the code previously in this thread, it returns a value of 1 instead of 0.

Grid-Pic.gif
CodeCruiserCommented:
How do you bind the grid? Are you sure you do not rebind it on postback? I mean are you using the
If Not page.IsPostBack Then
   Grid.datasource = ..
   Grid.DataBind()
End If

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lanier3532Author Commented:
that was it!  Sometimes its the obvious that we don't see.
Thanks again!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.