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

RadGrid - Add, Update and Delete using Stored Procedures

1 Answer 275 Views
Grid
This is a migrated thread and some comments may be shown as answers.
John
Top achievements
Rank 1
John asked on 23 Sep 2008, 11:34 AM
Hi,

I have a DropDown on aspx page, upon selection, I will get the ClientId which will become a parameter for stored procedure to get the data to display on Rad Grid.

I have to do Add, Update, Delete on RadGrid . But I have to use Stored Procedures passing clientId  as parameter to do the above operations.

Also need to validate if Column1 < Column2 on Grid on client side,  both are integers.

Could you please suggest on this or let me know the best example to take a look.
 
Many thanks.
John

1 Answer, 1 is accepted

Sort by
0
Veli
Telerik team
answered on 25 Sep 2008, 11:08 AM
Hello John,

Implementing your data source operations and calling stored procedures can be done in the respective Insert/Update/DeleteCommand events of RadGrid, where your e.Item parameter is a reference to the current item generating the action. Thus, you can retrieve its cell values and pass to your stored procedures in these RadGrid events.

For more information on the topic, please refer to a similar help article, where you would use stored procedures instead of direct SQL statements:

Insert/Update/Delete at database level with queries

As for retrieving and comparing cell values on the client, here are a few articles on RadGrid's client API to get you started:

Extracting key values client-side

Getting cell values for selected rows client-side

Greetings,
Veli
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Tags
Grid
Asked by
John
Top achievements
Rank 1
Answers by
Veli
Telerik team
Share this question
or