Intersoft Community - WebDesktop - How to pass back the new added row key value to webgrid in client bidning mode

How to pass back the new added row key value to webgrid in client bidning mode

yudi — Tue, 06 Nov 2012 08:05:01 GMT

The WebGrid development team stated that this feature will be implemented in the next build version of WebGrid. I will send you the nightly build of the hotfix when the pre-release hotfix is ready to be evaluated.

Edited on November 12, 2012 8:30 PM
Reason: Update Latest Status of Task #974

WebGrid development team has managed to implement the feature.

I'd like to introduce the "NewID" property of TransactionResult object. For your scenario, we need to set the value of NewID to the ID of the inserted object.

Below is the snippet code of InsertMethod in my WebService.

[WebMethod]
public TransactionResult InsertShipper(Shipper newObject)
{
    NorthwindDataContext context = new NorthwindDataContext();
    WebGridDataProvider<Shipper> provider = new WebGridDataProvider<Shipper>(context.Shippers.AsQueryable());
    TransactionResult tresult = provider.Insert(newObject);
    tresult.NewID = newObject.ShipperID;
    return tresult;
}

This insert method will insert Shipper object. I'm using Shippers table of Northwind database in my simple sample. The table has ShipperID as the primary key and it is incremental primary key.

After invoke the Insert(newObject) method, simply set the NewID property of the TransactionResult object and then return this object.

There are points that need to be done in the WebGrid:

Please ensure that the DataKeyField of WebGrid's RootTable has been set correctly.
Example:

<ISWebGrid:WebGrid ID="WebGrid2" runat="server" ...>
    <LayoutSettings ...>
    </LayoutSettings>
    <RootTable DataKeyField="ShipperID">
        <Columns>
            ...
        </Columns>
    </RootTable>
    <ClientBindingSettings DataSourceType="WebService" ServiceUrl="WebService.asmx"
        ItemTypeName="Shipper">
        <ServiceMethods SelectMethod="GetShippers" InsertMethod="InsertShipper" />
    </ClientBindingSettings>
</ISWebGrid:WebGrid>

Set the DefaultValue property of the WebGridColumn to -1.
Example:

<Columns>
    <ISWebGrid:WebGridColumn Caption="ShipperID" DataMember="ShipperID" DataType="System.Int32"
        Name="ShipperID" Width="100px" EditType="NoEdit" DefaultValue="-1" IsAutoIncrement="true">
    </ISWebGrid:WebGridColumn>
    ...
</Columns>

I have sent you a message to your registered email account. The message contains the link to download the nightly build of the hotfix and step by step to apply them manually.

I have tested in a simple sample and found no problem so far. Please have the nightly build hotfix tested on your end and let us hear your feedback.

How to pass back the new added row key value to webgrid in client bidning mode

mmikaeel2 — Sat, 03 Nov 2012 23:32:37 GMT

I gave up on you guys, to be really honest, you have fantastic looking UI and also functionality, BUT you also have too many unnecessary issues and many perfromance issues, these problems really delay my development and also almost no fix for any issues I raised to you guys. I think I will have to switch to another UI without that much of issues, mostly Dev Express will do the job without these problems and issues.

How to pass back the new added row key value to webgrid in client bidning mode

yudi — Tue, 23 Oct 2012 21:11:15 GMT

I apologized for any inconvenience this problem may have caused you. Your feature request is already queued in our work items. I may be able to help raising the priority for your feature request.

I’ll let you know any update I heard from the team regarding Task #974.

How to pass back the new added row key value to webgrid in client bidning mode

mmikaeel2 — Mon, 22 Oct 2012 00:57:28 GMT

Any update?!!

Its now over a year and NO fixe yet!! Can't belive you can't fix such issue!!

How to pass back the new added row key value to webgrid in client bidning mode

yudi — Thu, 04 Oct 2012 21:24:16 GMT

The status of Task #974 is on progress. When the nightly build of the hotfix is ready, I will let you know.

How to pass back the new added row key value to webgrid in client bidning mode

mmikaeel2 — Wed, 03 Oct 2012 16:43:46 GMT

Any update?!

How to pass back the new added row key value to webgrid in client bidning mode

yudi — Tue, 07 Feb 2012 16:40:47 GMT

Task #974 has not been completed yet.
I will let keep you informed with any news I heard from the team regarding task #974.

How to pass back the new added row key value to webgrid in client bidning mode

mmikaeel2 — Mon, 06 Feb 2012 17:19:39 GMT

Hi there,

Is this task (Task #974.) was done?

Thanks,

Maged

How to pass back the new added row key value to webgrid in client bidning mode

yudi — Mon, 02 May 2011 06:38:13 GMT

This feature request is already queued in our work items, Task #974.
When the hotfix is ready, I’ll surely let you know and give you an example about how to use it.

How to pass back the new added row key value to webgrid in client bidning mode

mmikaeel2 — Thu, 28 Apr 2011 01:13:28 GMT

Was this addressed yet? If yes can you give me an example of how to use it?

How to pass back the new added row key value to webgrid in client bidning mode

mmikaeel2 — Tue, 15 Feb 2011 10:18:35 GMT

Hi,

I’ve WebGrid, and defined BindingOperationMode="ClientBinding" AllowAddNew="Yes". Also set DataSourceType="WebService".

I’ve this code for the insert function in the webservice:

private TransactionResult InsertMembershipTypePrice(MembershipTypePrice newObject, int nPriceType)
    {
        Medcan.Business.MembershipTypePrice price = new Medcan.Business.MembershipTypePrice();

        price.MembershipTypeID  = newObject.MembershipTypeID;
        price.IsActive          = newObject.IsActive;
        price.EffectiveDate     = newObject.EffectiveDate;
        price.EndDate           = newObject.EndDate;
        price.Description       = newObject.Description;
        price.PriceFlag         = nPriceType;

        price.MemberCategory = GetComboConfigID(newObject.MemberCategoryName, "MembershipCategory");
        Decimal nTemp = 0;
        Decimal.TryParse(newObject.MemberPrice, out nTemp);
        price.MemberPrice = nTemp;

        using (TransactionScope scope = new TransactionScope())
        {
            price.Save();
            newObject.MembershipTypePriceID = price.MembershipTypePriceID;
            scope.Complete();
        }

        MembershipDataContext context = new MembershipDataContext();
        return new TransactionResult()
        {
            OperationType   = DataSourceOperation.Insert,
            ReturnValue     = true,
            AffectedResults = newObject.MembershipTypePriceID
        };
    }

How can the grid recognize the new added row key value, like when I add a new record in the database, how can I pass back the new row key value to the grid?

Thanks,

Maged Mikaeel