Intersoft Community - WebGrid Enterprise - how to easily assign gridchanges to database table

how to easily assign gridchanges to database table

yudi — Wed, 28 Dec 2011 02:51:19 GMT

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.

how to easily assign gridchanges to database table

soniya — Mon, 19 Dec 2011 23:16:10 GMT

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

how to easily assign gridchanges to database table

yudi — Mon, 19 Dec 2011 22:27:00 GMT

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.

how to easily assign gridchanges to database table

soniya — Mon, 19 Dec 2011 04:02:48 GMT

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....

protected void gvRequisition_InitializeDataSource(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)

{

if (xpRequisition != null && xpRequisition.dsReqOrder != null)

{

if (xpRequisition.dsReqOrder.xpReqDet != null)

{

// DataView dv =new DataView(xpRequisition.dsReqOrder.xpReqDet);

e.DataSource = xpRequisition.dsReqOrder.xpReqDet;//.dtReqdet;

}

protected void gvRequisition_PrepareDataBinding(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)

{

if (gvRequisition.FlyPostBackAction == "Refresh" || !IsPostBack)

{

// gvRequisition.RetrieveStructure(); gvRequisition.RootTable.DataKeyField = "PSEUDO_LINE_ID";

UPdetails.Update();

}

protected void gvRequisition_BatchUpdate(object sender, BatchUpdateEventArgs e)

{

// gvRequisition.PerformBatchUpdate(true,true);

foreach (WebGridRowChanges rowChanges in e.PendingChanges)

{

try

{

switch (rowChanges.RowState)

{

case RowState.Modified:

{

string TypeGuid = rowChanges.KeyValue.ToString();

MapChangesToObject(rowChanges.Data, TypeGuid);

// DataLayer.UpdateCustomer(customer); break;

}

catch (Exception exp)

{

// adds the Exception to batch update list to take advantage of WebGrid's partial errors support.

gvRequisition.AddBatchUpdateException(new WebGridBatchUpdateException(rowChanges,

new Exception("Record '" + rowChanges.KeyValue.ToString() + "' has error '" + exp.Message + "'", exp)));

}

private void MapChangesToObject(List<WebGridCellData> data, string strkey)

{　

DataRow row;

row = xpRequisition.dsReqOrder.xpReqDet.Rows.Find(strkey);

// row.BeginEdit(); foreach (WebGridCellData cellData in data)

{

switch (cellData.Column.DataMember)

{

case "DESCRIPTION":

row[cellData.Column.DataMember] = cellData.NewText;

break;

}

// row.EndEdit();

}

<ISWebGrid:WebGrid ID="gvRequisition" runat="server" Height="300px" UseDefaultStyle="True" Width="100%" EnableViewState="False" OnInitializeDataSource="gvRequisition_InitializeDataSource" OnPrepareDataBinding="gvRequisition_PrepareDataBinding" OnBatchUpdate="gvRequisition_BatchUpdate"> <LayoutSettings AllowBatchUpdate="True" AllowColumnSizing="No" AllowContextMenu="False" AllowAddNew="Yes" AllowDelete="Yes" AllowEdit="Yes" AllowFilter="Yes"> <BatchUpdateSettings AutomaticObjectUpdate="False" AllowReviewChanges="true" /> <ClientSideEvents OnInitialize="InitializeGrid" /> </LayoutSettings> <RootTable DataKeyField="PSEUDO_LINE_ID"> <Columns> <%-- <ISWebGrid:WebGridColumn Caption="Line #" DataMember="LINE_NO" Name="LINE_NO" Width="50px">

</ISWebGrid:WebGridColumn>--%>

<ISWebGrid:WebGridColumn Caption="PSEUDO_LINE_ID" DataMember="PSEUDO_LINE_ID" Name="PSEUDO_LINE_ID" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="PRODUCT_CODE" DataMember="PRODUCT_CODE" Name="PRODUCT_CODE" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="DESCRIPTION" DataMember="DESCRIPTION" Name="DESCRIPTION" DataType="System.String" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Resource" DataMember="RES_NAME" DataType="System.String" EditType="WebComboNET" Name="RES_NAME" WebComboID="cbResource" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Specifications" DataMember="SPECIFICATIONS" Name="SPECIFICATIONS" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="UOM" DataMember="" DataType="System.String" EditType="WebComboNET" Name="UOM" WebComboID="cbUOM" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Numbers" DataMember="NOS" Name="NOS" DataType="System.Int32" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Qty per Unit" DataMember="QTY_PER_UNIT" Name="QTY_PER_UNIT" DataType="System.Int32" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Qty" DataMember="QTY" Name="QTY" Width="20%"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Qty. Fulfilled" DataMember="QTY_FULFILLED" Name="QTY_FULFILLED" DataType="System.Int32" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Qty to be Waived" DataMember="QTY_WAIVED" Name="QTY_WAIVED" DataType="System.Int32" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Qty Waived" DataMember="TOTAL_QTY_WAIVED" Name="TOTAL_QTY_WAIVED" DataType="System.Int32" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Balance Qty." DataMember="BALANCE_QTY" Name="BALANCE_QTY" DataType="System.Int32" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Qty Waived" DataMember="TOTAL_QTY_WAIVED" Name="TOTAL_QTY_WAIVED" DataType="System.Int32" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Remarks" DataMember="REMARKS" Name="REMARKS" DataType="System.String" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Required By" DataMember="REQUIRED_BY" Name="REQUIRED_BY" DataType="System.DateTime" EditType="CalendarCombo" Width="100px"> </ISWebGrid:WebGridColumn> </Columns> </RootTable> </ISWebGrid:WebGrid>

how to easily assign gridchanges to database table

yudi — Wed, 07 Dec 2011 04:18:08 GMT

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.

how to easily assign gridchanges to database table

soniya — Tue, 06 Dec 2011 05:14:23 GMT

Earlier we used devexpress ...After executing following code the grid values automatically used to get stored in database table..

DataRow row = (DataRow)gvRequisition.GetDataRow(gvRequisition.EditingRowVisibleIndex);

if (row != null)

{

IDictionaryEnumerator enumerator = e.NewValues.GetEnumerator();

enumerator.Reset();

while (enumerator.MoveNext())

{

if (enumerator.Value != null && enumerator.Value.ToString() != "")

{

row[enumerator.Key.ToString()] = enumerator.Value;

}

here "E.NEWVALUES" Gets a dictionary that contains the values of the non-key field name/value pairs in the row to be updated.

Now while using intersoft how can i get IDictionaryEnumerator object of gridchanges ...or a collection object of gridchanges to easily iterate through and assign values to database table

I have seen the sample provided by you on "batchupdate using custom object update" But as in the sample i can't create "custom.cs" files with so many fields as we are using too many tables and too many grids

I want a simple method like above ( iterating through enumerator and assigning values to row in datatable)You can also refer to email sent to technical@intersoftpt.com----

"changes in DAL? [IS-1C9B284D-4DF8-466E-B45B-8BC0D8A148E6] {99812}"