[Solved] How to get the datakey of a newly row

[Eric Ulliac]

Hi,

I need to get the dataKey of the newly added row after automatic insert in a RadGrid.
It's possible to get it with the ItemInserted event function?
I tried to get the dataKey like as

protected void MyRadGrid_ItemInserted(object o, GridInsertedEventArgs e)
{
   if (e.Exception != null)
   {
      e.ExceptionHandled = true;
      //Error messsage here
   }
   else
   {
      GridEditableItem An_item = (GridEditableItem)e.Item;
      int The_data_key = int.Parse(An_item.GetDataKeyValue("Id").ToString());
   }
}

But this code works only in the ItemUpdated case.

[Yavor]

Hello Eric,

You can use the ItemCommand event handler, after checking for PerformInsert command name.

Sincerely yours,
Yavor
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Eric Ulliac]

I follow your instructions but I don't manage to get the new dataKey Value

protected void MyRadGrid_ItemCommand(object o, GridCommandEventArgs e)
{
        if (e.CommandName == "PerformInsert")
        {
            GridEditableItem Un_item = (GridEditableItem)e.Item;
            int The_key_value = int.Parse(Un_item.GetDataKeyValue("Id").ToString());
        }
    }

It retrun a ArgumentOutOfRangeException at the execution.

[Yavor]

Hello Eric,

You can actually access the insert/update form controls (Un_item["ColumnName"].controls[0] as TextBox).
If this is an insert operation, you can cast the item to GridEditFormInsertItem (as opposed to GridEditableItem).
I hope this information helps.

Sincerely yours,
Yavor
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Eric Ulliac]

Hi Yavor,

So sorry beacause I miss to tell you one detail :
The Id field is an auto increment field in my table, that why I can't retrive it on the insert form.
I need to get this auto created id after an auto insert in my radGrid.

[Yavor]

Hello Eric,

Unfortunately, when this is the case, it is beyond the control of the grid product, and into the realm of the underlying database. You may consider using triggers, in a fashin similar to this.

Greetings,
Yavor
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center