RadGrid's Datasource which is Datatable doesnt get updated

[Jaya]

I assigned Datatable variable as Datasource for RADGrid in needDataSource event. When editing the row item in the Grid, those changes are not saved back to Datatable automatically. Is there anyway the edits directly go back to datatable and I can save in to database later, only if the user clicks on save by calling Datatable.GetChanges(). for now I have used following code in UpdateCommand event to save the changes back to datatable.

In the following code dtaddress is my datatable

 

protected void rgAddress_UpdateCommand(object sender, GridCommandEventArgs e)

{

GridEditableItem editedItem = e.Item as GridEditableItem;

editedItem.OwnerTableView.AllowAutomaticUpdates = true // this line didnt work

 

 

 

int row = editedItem.RowIndex - 3; //removed header rows.. this is ugly

dtaddress.Rows[row]["address1"] = (editedItem["Address1"].Controls[0] as TextBox).Text;

dtaddress.Rows[row]["address2"] = (editedItem["Address2"].Controls[0] as TextBox).Text;

dtaddress.Rows[row]["city"] = (editedItem["City"].Controls[0] as TextBox).Text;

 dtaddress.Rows[row]["state"] = (editedItem["State"].Controls[0] as TextBox).Text;

 dtaddress.Rows[row]["country"] = (editedItem["Country"].Controls[0] as TextBox).Text;

 dtaddress.Rows[row]["ZipCode"] = (editedItem["ZipCode"].Controls[0] as TextBox).Text;*/

e.Item.OwnerTableView.Rebind();

Also even after it comes out of updatecommand code block, the edit mode doesnt go away. Please help.

[Jayesh Goyani]

Hello Jaya,

Please remove below code line.

e.Item.OwnerTableView.Rebind();

Note : it will rebind grid and then remove edit item automatically.


OR

GridEditableItem editedItem = e.Item as GridEditableItem;
............
...........
editedItem.IsInEditMode = false;
e.Item.OwnerTableView.Rebind();

Note : you can also use : "RadGrid1.MasterTableView.ClearChildEditItems();"  or "RadGrid1.MasterTableView.ClearEditItems();"

Thanks,
Jayesh Goyani

[Jaya]

None of the options you said worked...

first of all IsInEditMode is a readonly . you can't assign a value false to it..

Is there a way for datatable to be automatically updated without me assigning edited values for each field in the updatecommand event? Can anyone help?

[Jayesh Goyani]

Hello Jaya,

Sorry for this,
Please use below property,

item.Edit = false;

Thanks,
Jayesh Goyani

[Eyup]

Hi Jaya,

You could use declarative datasource for handling the editing automatically as demonstrated in the following demo:
 Grid / Automatic Operations

If you will use Advanced ( NeedDataSource ) databinding, however, you could use OnUpdateCommand server event of the grid as shown in this article:
 Manual Insert/Update/Delete operations 

Give it a try and let me know what the result is.

Regards,
Eyup
the Telerik team