The following list shows additional methods to perform server-side related tasks.

• GetChanges()
  Returns all pending changes regardless of the row’s state and table.
• GetChanges(RowState rowState)
  Returns all pending changes with given row state.
• PerformBatchUpdate(bool throwExceptionOnError)
  Processes changes and updates it to physical database programmatically.
• GetBatchUpdateExceptions()
  Returns one or more exceptions that occurred while processing batch update.
• AddBatchUpdateException(WebGridBatchUpdateException exception)
  Adds an exception when a batch update-related error occurred.

The provided server side APIs, as described above, enables you to programmatically work against pending changes data that submitted from client-side.

Process pending changes programmatically and call your custom data access method to perform physical update.

This scenario is especially useful when you bind WebGrid to custom object collection instead of dataset or datasource control.

The following C# codes show how to use many of the server-side methods to iterate each change and update it using custom data access layer.

protected void WebGrid1_BatchUpdate(object sender, BatchUpdateEventArgs e)
{
    foreach (WebGridRowChanges rowChanges in e.PendingChanges)
    {
        CustomObjects.Customer customer = null;
        try
        {
            switch (rowChanges.RowState)
            {
                case RowState.Added:
                    customer = new CustomObjects.Customer();
                    MapChangesToObject(rowChanges.Data, customer);
                    DataLayer.InsertCustomer(customer);
                    break;
                case RowState.Modified:
                    customer = DataLayer.GetCustomer(rowChanges.KeyValue.ToString());
                    MapChangesToObject(rowChanges.Data, customer);
                    DataLayer.UpdateCustomer(customer);
                    break;
                case RowState.Deleted:
                    customer = DataLayer.GetCustomer(rowChanges.KeyValue.ToString());
                    DataLayer.DeleteCustomer(customer);
                    break;
            }
        }
        catch (Exception exp)
        {
            // adds the Exception to batch update list to take advantage of WebGrid's partial errors support.
            WebGrid1.AddBatchUpdateException(new WebGridBatchUpdateException(rowChanges,
                new Exception("Record '" + rowChanges.KeyValue.ToString() + "' has error '" + exp.Message + "'", exp)));
        }
    }
}

The following is the C# codes to map the changes into object.

private void MapChangesToObject(List<WebGridCellData> data, CustomObjects.Customer customer)
{
    foreach (WebGridCellData cellData in data)
    {
        string newText = cellData.NewText;
        switch (cellData.Column.DataMember)
        {
            case "CustomerID":
                customer.CustomerID = newText;
                break;
            case "Address":
                customer.Address = newText;
                break;
            ...
        }
    }
}

Codes explanation:

• In custom object scenario, developers often have their own data access layer to perform data management such as select, inserts, updates and deletes. Thus, you need to handle OnBatchUpdate server side event to process the changes as shown in above sample codes.
• You can access all pending changes from e.PendingChanges, which is List<WebGridRowChanges>.
• You iterate on each WebGridRowChanges. Then perform update based on the RowState value.
• Notice that the sample used strongly-typed custom object to perform data update in elegant fashion. For add and modified changes, you need to map the changes into the object accordingly. In the sample above, it is done with MapChangesToObject function.
• Call AddBatchUpdateException when an exception occurred. This enables the codes to continue updating the other records. This error handling is also taking advantage of partial errors support.

after execution of batchupdate event of webgrid,i am getting error "Can't find DataColumn with name "PSEUDO_LINE_ID" in the specified datasource" .When i debug i found that it exists in datatable "xpRequisition.dsReqOrder.xpReqDet".....

 It also updates data in datatable but still shows the error "Can't find DataColumn with name "PSEUDO_LINE_ID" in the specified datasource"...I can't send you a simple sample as my project consists of devexpress dlls that are used in master page..Plz help me fed up with this error .....trying continuously since past two days....It's urgent....

Based on the error message, the process is interrupted because it can’t find data column with name “PSEUDO_LINE_ID” in the specified datasource. I used to suspect that you have different value specified in “Name” and “DataMember” property of WebGridColumn object, but the embedded WebGrid code proves me wrong.

I’d like to suggest you to add a breakpoint at the grid page’s code in order to determine the exact location where the error happens.

i have already mentioned that it happens after execution of batchupdate event of webgrid

Even if i comment the code inside batchupdate event of webgrid , this happens.."xpReqDet" is a datatable to which grid's datasource given.

 I suspect that after batch update it may be searching column in dataset "dsReqOrder" instead of datatable "xpReqDet".How can i rectify the problem

I have also checked turning off the batchupdate feature then also same error occurs

Apologize for the delay in sending this.

I have sent a reply and enclosed a sample file to be evaluated at here. Please have the sample evaluated on your end and let me hear your feedback.