This is a migrated thread and some comments may be shown as answers.

No datakey options when using stored procedure

1 Answer 36 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Matthew
Top achievements
Rank 1
Matthew asked on 30 Jun 2010, 04:40 PM
Hi all,
I am using the radgrid with data that must be accessed using SQL stored procedures.
I have created the SQLDataSource and assigned all the required sp's and their parameters.

My select statement *does* select a unique PK for the dataset

However, when I bind the radgrid to the SDS there are no options to select in the "Data key name(s)" field in the grid property builder.
Is there a trick to getting them to show up here?

I have loosely followed the guide here:
http://www.telerik.com/community/code-library/aspnet-ajax/grid/update-insert-delete-with-stored-procedures-and-sqldatasource-control.aspx

But still I get no options for datakeys

Is there a silver bullet here? Some setting I may have incorrectly applied?

Thanks



1 Answer, 1 is accepted

Sort by
0
Matthew
Top achievements
Rank 1
answered on 30 Jun 2010, 06:21 PM
I have resolved the issue.

I can manually type in the value and it works.
However, the name of the value must match the column name in the child row and the parameter name for the stored procedure.
Tags
Grid
Asked by
Matthew
Top achievements
Rank 1
Answers by
Matthew
Top achievements
Rank 1
Share this question
or