Cant get value of cell on gridview nested in formview

I have a formview and a nested gridview where i would like to be able to select th开发者_开发问答e value of a specific cell when the row has been updated. I took the example code from the msdn site as it's close to what i want:

protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
    {

       GridView SprayGrid = (GridView)FormView1.FindControl("GridView1");

       int Index = SprayGrid.EditIndex;
       GridViewRow row = SprayGrid.Rows[Index];


       TextBox message = (TextBox)FormView1.FindControl("TextBox1");
         message.Text = row.Cells[4].Text;
    }

However, for some reason this will only pick up the index of the cell, i.e. if i change the row.cells[0] i can see in my message box the index number if i want to see any other cell then the message is blank? Any ideas would be great.

---

Use DataKeys on the GridView, and instead of trying to set the TextBox value from the cell, set it from the DataKey.

In the ASPX:

<asp:GridView Id="GridView1" runat="server" DataKeyNames="SomeColumnName">

And in your row updating event:

TextBox message = (TextBox)FormView1.FindControl("TextBox1");
message.Text = SprayGrid.DataKeys[row.RowIndex]["SomeColumnName"].ToString();