Edited value in datagrid not available

[John Spiegel]

Hi all,

As usual, I have found a way to make the straightforward , textbook example
fail. I have a datagrid that supports editing. When I edit a row then fire
the update, the value that gets pulled from the textbox is the original
value it had before editing. It "feels" like I'm just missing some setting,
but am newbie enough to not be able to find what that might be. I'm not
requering/rebinding the grid data between beginning the edit and attempting
to access the value in the textbox. Any ideas?

TIA,

John

The grid:

<asp:datagrid
AllowCustomPagi ng="True"
AllowPaging="Tr ue"
AllowSorting="T rue"
CellPadding="2"
id="grdClientAc counts"
runat="server"
AutoGenerateCol umns="False"
OnEditCommand=" grdClientAccoun ts_Edit"
OnCancelCommand ="grdClientAcco unts_Cancel"
OnUpdateCommand ="grdClientAcco unts_Update">

<AlternatingIte mStyle ForeColor="#336 699"
BackColor="#FFF FCC"></AlternatingItem Style>
<ItemStyle ForeColor="#336 699" BackColor="#CCF FFF"></ItemStyle>
<Columns>
<asp:EditComman dColumn EditText="Edit" CancelText="Can cel"
UpdateText="Upd ate"
ItemStyle-Wrap="False" />
<asp:BoundColum n DataField="ANI"
HeaderText="Pho ne"></asp:BoundColumn >
<asp:BoundColum n DataField="ANIA ccount" HeaderText="Acc ount
Number"></asp:BoundColumn >
<asp:BoundColum n DataField="Clie ntAccount" HeaderText="Cli ent
PIN"></asp:BoundColumn >
<asp:BoundColum n DataField="Assi gned" HeaderText="Ass igned"
DataFormatStrin g="{0:MM/dd/yyyy}"></asp:BoundColumn >
<asp:BoundColum n DataField="Unas signed" HeaderText="Una ssigned"
DataFormatStrin g="{0:MM/dd/yyyy}"></asp:BoundColumn >
</Columns>
</asp:datagrid>
Abbreviated code:
public void grdClientAccoun ts_Edit(object Sender, DataGridCommand EventArgs
e)
{
grdClientAccoun ts.EditItemInde x = e.Item.ItemInde x;
BindGrid(); //Helper function that queries and binds current info.
}

public void grdClientAccoun ts_Update(objec t Sender, DataGridCommand EventArgs
e)
{
//build an update command
string ANIUpdateComman d = "UPDATE ANI SET " +
"ANI = '" + ((TextBox)e.Ite m.Cells[1].Controls[0]).Text +
"' WHERE ANI = '" + Session["ANI"] + "'";

// *snip* - the connection and related SQL handled. The value in
cmdUpdate.Comma ndText indicates
// that the value from the textbox, pulled with
"((TextBox)e.It em.Cells[1].Controls[0]).Text", is the original.

lblDebugMessage .Text = cmdUpdate.Comma ndText;
}