Retrieve Values after Insert Command

[Dominic]

Hi

My grid allows automatic operations but i have some other controls (usercontrol in a templateColumn) that i need to extract the values to be able to save some other informations in related tables, so i need the primary key of the inserted item. I've tried to extract the value in the ItemInserted but it seems that the informations are no longer available at this moment... How i can use automatic operations and be able to save other informations who needs the primary key of the inserted item ?

Thanks in advance for your help. If you need more detail about my case, please let me know.

[Vlad]

Hello Dominic,

You can use InsertCommand to achieve this.

Best wishes,
Vlad
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Dominic]

Hi

I know how to save the new item but i want to know how i can read the Primary key of the last inserted item after the insertitem command ? i'm using the automatic insert to add some item but after that i need to know what is the primary key of the inserted item because i need to save the content of some other usercontrols included in the EditTemplate.

Maybe i'm missing something so if it is the case , please show me how i can read the primarykey of the inserted item ?

Thanks for your help.

[Daniel]

Hello Dominic,

I suggest you examine the following links:
Returning auto generated primary key
Retrieving Identity or Autonumber Values (ADO.NET)

I hope this helps.

Kind regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Dominic]

Hi


Maybe my previous post was not clear. I just want to get the primary key of the last saved item in the grid by using automatic operations , how can i get it ?

Thanks

[Daniel]

Hello Dominic,

For your convenience I created a sample website illustrating what I meant.

Regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Dominic]

hi

Ok, i know that you can do this but is there a way to do this in one of the Grid event without using the datasource event ?

Thanks

[Daniel]

Hello Dominic,

You can access the auto-generated key on the DataSource event only. The same approach is also used for the standard ASP.NET controls.

Getting the identity of the most recently added record

Let me know if you need more information.

Regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.