Please check 'New Identity Insert' documentation of WebGrid that related to auto-increment field and SmartBatchUpdate™ at here.
I’m sure it helps.

Hi,

I have gone through those articles. But they do not seem to help much in my case.

I must be doing something wrong while definign the columns or child tables.

Please have a look at my attached file and tell me what my be possible mistake i am doing.

One question.

Do you support Auto-increments in child tables?

Thanks,

Huzefa

Hi,

Why there is no reply from your side???

Hi Huzefa,

Please let me try to help you. In you attached sample, there is nothing we can do because we don't have your database. As Yudi has mentioned, based on the article, you will need to handle to select the identity when insert new record.

We have a sample in WebGrid sample called BatchUpdate_Enterprise.aspx. In child table (orders), we hanlde insert and select the identity with DoInsert method.
You can try to see the method in dsNorthwind_Extended.cs.

Hope this helps.

Regards,
Handy

Hi handy,

Did u see the attached image file? The Auto-Increment is not happening at client side..

I am trying to do a batch update. The key is not getting incremented that's why its doesn't allow me to add more then one row..

We have a sample in WebGrid sample called BatchUpdate_Enterprise.aspx. In child table (orders), we hanlde insert and select the identity with DoInsert method.

This sample is not so useful in my case as i am doing batch update using strongly typed custom objects and this sample use DataSource controls.

I want a sample where there is a batch update in Hierarchical Mode using Strongly Typed Custom Objects??

Please help me out...

Thanks,

Huzefa

Hi Huzefa,

Yes, I saw the attached image. As I said before, you will need to handle to select identity when insert a new row.
I think no matter what you used, as long as you hadle to select identity which will retrieve the current increment id.

In our sample, we used the code below to handle it.

 int? identity = this.SelectIdentityQuery();
 OrderID = identity;

Here is the other article to do in Sql.

e.g try not to use BatchUpdate first. If you don't handle it, after you insert new row, try to remove the added row. It will surely return an error (incorrect id).

I see that you are using List as your strongly type custom object. I need to discuss to our developer if this is already supported or asked how to select identity in your scenario.

It would be great if you can provide a simple runable sample. So when we debug it, we can know if it returns the correct id or not.

Regards,
Handy

Hi Handy,

In our sample, we used the code below to handle it.

 int? identity = this.SelectIdentityQuery();
 OrderID = identity;

The above mentioned will be called when user has added few rows into the grid and then click the AcceptAllChanges button on WebGrid.

But in case i am not able to add more then one row into the ChildTables of webGrid.

I am handling the update of Identity key once the user submits the Grid for Update.

I will also create a sample and send it to you..

Thanks,

Huzefa

Hi Huzefa,

Yes, a simple runable sample which replicate the issue should help us to investigate this.
n our sample, we could not replicate your issue.
I know that the select identity should correctly run after you accept the changes.
But while in batch update, it should be handled automatically.
As I remembered I ever told you that you must not use List in AutoIncrement scenario.
http://www.intersoftpt.com/Community/WebGrid/AutoIncrement-of-KeyField-giving-problem-when-record-already-exists/

Regards,
Handy