[Solved] How to pass the value from RadGrid to the Stored Procedure

[wilmos]

Dear all,

I am new to asp.net from Java. May i know how can i get the row value (CustID) when selected the row in RadGrid to pass it to the stored procedure to perform tasks (update or delete) ?

Many thanks.

Regards,
Wilmos.
 

[Adam Hubble]

Hi,

You need to set the DataKeyNames property of radGrid to the identity key for your records. So in your case you would set DataKeyNames="CustID". RadGrid also allows for comma delimited (and therefore multiple) datakeyvalues.

Controls like sqldatasource or objectdatasource can pick the id key up automatically if you set them to use the selected value of radgrid. In code you could access the selected value via gridIdname.SelectedValue

Hope this helps,
Matt

[Shinu]

Hi Wilmos,

You may also refer the following code library submission which explains how to perform Update/Insert/Delete operations  in RadGrid with stored procedures and SqlDataSource control .
Update/Insert/Delete with stored procedures and SqlDataSource control

Regards
Shinu.

[wilmos]

thanks Shinu and Matt Davis for your kind infor.

May i know what is the different DataKeyNames and Child DataKeyNames?

I will continue to try for the solution provided by Shinu.

Thanks again for your big help.

Regards,
Wilmos.

[Princy]

Hello Wilmos,

I've not heard of a property such as the ChildDataKeyNames. Did you mean ClientDataKeyNames? Anyways, let me explain all that i know :)

If you want to set DataKeyNames for the child(detail) tables, then you can set the DataKeyNames property in the GridTableView tag of the DetailTables as shown below:
aspx:

<telerik:RadGrid ID="RadGrid" DataSourceID="SqlDataSource1" runat="server" GridLines="None">
   <MasterTableView DataKeyNames="ProductID">
       <DetailTables>
          <telerik:GridTableView DataSourceID="SqlDataSource2" DataKeyNames="OrderID">

The DataKeyNames array can be used to fetch the primary key field values for grid items of the MasterTableView or a detail GridTableView, server-side.
Retrieving primary key field values for selected items

Whereas, the ClientDataKeyNames array can be used to fetch the key field values for grid items of the MasterTableView or a detail GridTableView, client-side.
Extracting key values client-side

Thanks
Princy.