Change a cell value before database update

[Jonathan]

Hi, 

I have a radgrid holding customer notes with a column called UserUpdated.  The UserUpdated column is the last user to have updated the note in the row.  It is a template column like this:

<telerik:GridTemplateColumn DataField="UserEdited"    FilterControlAltText="Filter UserEdited column"   HeaderText="UserEdited" SortExpression="UserEdited" UniqueName="UserEdited">
    <EditItemTemplate>
                                    <asp:Label ID="UserEditedLabel2" runat="server" Text='<%# Bind("UserEdited") %>'></asp:Label>
    </EditItemTemplate>
    <ItemTemplate>
                                    <asp:Label ID="UserEditedLabel" runat="server" Text='<%# Eval("UserEdited") %>'></asp:Label>
    </ItemTemplate>
</telerik:GridTemplateColumn>

When the person hits the edit button on  that row, I want the row to continue continue to show that value while they are editing.  That way, if they cancel their edit, the grid will not have to be rebound and that cell value will not have changed.

But when they hit the update button to commit their changes, I want to intercept it and change the UerEditedLabel2.Text value to the current user's username before the commit.

I have tried probably 10 ways to do this with no luck.  

Any help would be appreciated.  Thanks.

[Shinu]

Hi Jonathan,

Please try the following code snippet to achieve your required scenario.

ASPX:

<telerik:GridTemplateColumn DataField="OrderName" HeaderText="OrderName" UniqueName="OrderName">
    <EditItemTemplate>
      <asp:TextBox ID="Textbox1" runat="server" Text='<%# Eval("OrderName") %>'></asp:TextBox>
    </EditItemTemplate>
    <ItemTemplate>
      <asp:Label ID="Label1" runat="server" Text='<%# Eval("OrderName") %>'></asp:Label>
    </ItemTemplate>
</telerik:GridTemplateColumn>

C#:

protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e)
   {
       if (e.Item is GridEditableItem)
       {
           GridEditableItem edit = (GridEditableItem)e.Item;
           TextBox txt = (TextBox)edit.FindControl("Textbox1"); //access the TextBox inside the TemplateColumn currently being edited
           txt.Text = "Current user's name"; //Set it to your required value
       }
   }

Thanks,
Shinu

[Jonathan]

That worked very well.  Thanks!