how to update grid items after update command button clicked

[Robert]

I have a radgrid using the automatic operations (insert/update/delete).  I have two columns in the grid called "ModifiedBy" and "DateCreated" When in edit mode and after the update button is clicked, I need to update the values of those columns for the selected item with the current logged in user and current date.  I know how to get the logged in user and date but I'm not clear on how to  bind that data back to the database.

How can this be done in the code-behind using vb.net?  I've tried to use e.Item.OwnerTableView.PerformUpdate() but I'm not sure how to do it.  Is there a better way to accomplish this?  Any help would be greatly appreciated.

 

[Princy]

Hello Robert,

I guess you want to update the grid data item from an external button click. If that the case you can use FireCommandEvent method as described in the following documentation.

How to fire command events from code

Hope this helps,
Princy.

[Ryan Eaves]

Princy, that isn't what he asked at all. The answer is to handle the OnUpdating or OnInserting events of your datasource and manipulate the values there. Like this:

protected void dsSomeEntity_Inserting(object sender, EntityDataSourceChangingEventArgs e)
{
    SomeEntity entity;
    entity = (SomeEntity)e.Entity;

    entity.DateCreated = DateTime.Now;
    entity.ModifiedBy = Session["UserId"];

}