Automatic data source operations: insert, update, delete

Telerik RadGrid provides rich server API for inserting new data, updating existing data and deleting data directly from the specified data source (AccessDataSource, SqlDataSource or ObjectDataSource). Keep in mind that you will have to configure the respective data source control (including update/insert/delete parameters to its definition) to trigger the automatic operations. The new ASP.NET 2.0 framework allows using these features entirely declaratively, except the error-handling logic.

You have to set the following properties of the grid to true to propagate automatic update/insert/delete operation:

AllowAutomaticUpdates
AllowAutomaticInserts
AllowAutomaticDeletes

What is on this example:

You can insert a new item using the [Add new record] button in the Command row.
You can edit an item using the Edit button (the first button in each row).
You can delete an item, using the Delete button (at the end of each row).

Note: SessionDataSource is simply a tool used in this grid demo to prevent permanent changes from be made to demo data. It is essentially an AccessDataSource that stores data in Session so that no changes are persisted permanently to the database file.
You are free to use this assembly in your projects, but it is not necessary for RadGrid to function. Unless you want to copy the telerik demo behavior in your own project, you can remove this assembly from your project.

Further information about the automatic data source operations and error handling supported by Telerik RadGrid is available in these resources:
Automatic data source operations
API for controlling automatic data source operations
Error handling
Automatic operations with SqlDataSource control
Automatic operations with ObjectDataSource control
Automatic operations with SqlDataSource in hierarchical grid
Update/Insert/Delete with stored procedures and SqlDataSource control

	RadGrid
	1Overview 2Outlook grid 3Web grid 4Business grid 5Web Mail Grid 6Migration from MS GridView Columns 7Column types 8Column formatting 9Column/Row/Grid resize/reorder Rows 10Normal/Alternating rows 11Selected rows style 12Accessing cells and rows 13Auto postback on row click Populating with Data 14Simple data-binding 15Advanced data-binding 16Hierarchy with declarative relations 17Hierarchy with DetailTableDataBind event 18Self-referencing hierarchy 19Related grids 20Various data sources 21Programmatic creation from XML 22Heavy data load/viewstate optimization 23Displaying pivot data Sorting 24Basic sorting 25Advanced sorting Paging 26Basic paging 27Alphabetic pager 28Slider/Advanced-style pager 29Pager template 30Customizing the pager programmatically 31Custom paging 32SEO-friendly paging Scrolling 33Basic scrolling 34Virtual scrolling and paging 35Frozen columns Selecting 36Client-side row selection 37Server-side row selection Exporting 38MS Excel/MS Word/CSV 39Export to PDF AJAX 40AJAX RadGrid 41Loading template 42AJAXifying standard controls 43AJAX request events 44JavaScript after AJAX 45Triggering an AJAX call outside of the grid Filtering 46Basic filtering 47Filtering in hierarchy 48Filtering template columns Hierarchy 49Three-level hierarchy 50Several tables at a level 51Client-side hierarchy loading 52Mixed hierarchy loading Grouping 53Outlook-style grouping 54Group-By expressions 55Client group load Insert/Update/Delete 56Automatic operations Extracting values 57Using column editors 58Using grid server-side API for extraction 59Auto-generated edit form with multiple columns 60Command item 61User control edit form 62Form template edit form 63Edit on double-click 64Client-side delete 65Editing XML using XmlDataSource Validation 66Flexible server-side validation Programmatic creation 67On PageInit 68On PageLoad 69Creating hierarchy programmatically Appearance 70Skins 71Styling Header, Footer and Pager items 72Styling edited rows 73Right to left support Client-Side API and Events 74Client objects and events 75Client-side API 76Keys/Values client-side Accessibility 77Keyboard support Integration 78File Browser 79Updating RadGrid with a WebService 80Grid Filtered by Combo 81Google-like Filtering 82LoadOnDemand Grid in Combo 83Window Editing 84Ajax-enabled context menu 85Custom Editors 86Resizing RadGrid in RadSplitter 87RadUpload and RadGrid 88RadNumericTextBox for RadGrid footer totals 89RadChart in RadGrid column 90RadGrid and aggregate RadChart

Demos

Automatic operations