Insert/Update/Delete

[Ryan C]

Is there an example for a RadGrid with Insert/Update/Delete functions and thats not bind to any database. Basically the grid will be used to insert new data.

[robertw102]

Are you asking how to handle the insert/update/delete commands of the grid without using the automatic features of the RadGrid or are you asking how to handle those events to another datasource.

If it's the first one, where you want to handle the insert/update/delete commands yourself, you just need to handle the InsertCommand, UpdateCommand and DeleteCommand events of the grid.

I hope that helps.

[Ryan C]

All I want is an interface (the RadGRid) to be able to insert/delete multiple new rows into my non existent table. So that when I click on the button "save" I have on below the page, I would be able to save all the details on the page into an actual table my database, and then save teh details in my "virtual" grid into another table binding with a foreign key with the newly created table.

[Radoslav]

Hello Ryan,

Please check out the following code library which explains how to create an Excel-Like-Grid with empty cells and DataItems set to the edit mode:
http://www.telerik.com/community/code-library/aspnet-ajax/grid/excel-like-radgrid.aspx

To achieve the desired functionality concerning dynamically creating the tables into the database you could try creating the commands and execute an SQL statements from c# code behind. Following this approach you can create dynamically tables into the database and insert/update/delete rows to them.

Additionally please see the following blog posts which describes how to create database and table dynamically in c#.net code behind:
http://www.dotnetspider.com/forum/202939-How-create-database-table-dynamically-c-net-code-behind.aspx

I hope this helps.


Best wishes,
Radoslav
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Ryan C]

http://www.telerik.com/community/code-library/aspnet-ajax/grid/excel-like-radgrid.aspx

Thanks that what I was exactly looking for. All that is needed is a delete feature for the rows.