save information into another table when update button is pressed

[Syed]

Hi,

i displayed rows in the RadGrid and i am performing Edit and update to the particular row.

i am tracking the details of the users whoever updating the rows. i have a table tracking_users and i want to store the details into this tracking table.

Basically what i need is that whenever update button is press some information to be stored into another table.

Thanks.

Regards
Arshad

[Shinu]

Hi Arshad,

I guess you are trying to access the user information from the updated Grid row. If so you can set the required DataField as the DataKeyName. Access its value in the Update command event and hence insert the data into the tracking_users table.

CS:

  protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e)
    {
        GridEditableItem edititem = (GridEditableItem)e.Item;

        //access the DataKeyValue for the updated row here
        int userID = Convert.ToInt16(edititem.GetDataKeyValue("UserID "));
    }

Shinu.

[Syed]

Thanks.

Here i am inserting a new record into another table when an update command performs on the RadGrid. I get an idea from you updatecommand event.

Anyhow thanks for the wonderful idea.

protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e) 

{

Here i am creating new connection and inserting a new record into the table.

}

Best Regards

Arshad