[Solved] Selected item value for parameter

[Megan]

I want to be able to update the value of one field for the selected row of my grid when a button is pressed.

However, I am having trouble trying to get the selected value of the row based on its "DataKeyNames" value.

My stored procedure uses a value of the selected item as a parameter, this is why I want to extract the value.

I've tried things like "selectedvalue" but nothing works dynamically.

My stored procedure is basically "update rows with data where id = @id" and I need that id being the selected grid value.

Any ideas?

[Princy]

Hi Megan,

Have you gone through the following help article which explains how to access primary key field values for selected items.
Retrieving primary key field values for selected items

Thanks
Princy.

[Megan]

I tried to do this to directly input the value into the value of the parameter:

Dim iValidationId As New SqlParameter("@iValidationId", SqlDbType.Int, 4)
iValidationId.Value = grdPrices.SelectedItems(0).OwnerTableView.DataKeyValues(grdPrices.SelectedItems(0).ItemIndex)(

"iValidationId")


And it comes up with this error:

[ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index]