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
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
0
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.
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.