Automatic data source operations: insert, update, delete

r.a.d.grid 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).

Further information about the automatic data source operations and error handling supported by r.a.d.grid 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

	r.a.d.grid
	1Overview 2Outlook grid 3Web grid 4Migration from MS GridView What's new 5Client-side delete 6SEO-friendly paging 7Displaying pivot data 8Slider/Advanced-style pager 9Flexible server-side validation 10Auto postback on row click Columns 11Column types 12Column formatting 13Column/Row/Grid resize/reorder Rows 14Normal/Alternating rows 15Selected rows 16Accessing cells and rows Populating with Data 17Simple data-binding 18Advanced data-binding 19Hierarchy with declarative relations 20Hierarchy with DetailTableDataBind event 21Self-referencing hierarchy 22Related grids 23Various data sources 24Programmatic creation from XML 25Heavy data load/viewstate optimization Sorting 26Basic sorting 27Advanced sorting Paging 28Basic paging 29Pager template 30Customizing the pager programmatically 31Custom paging Scrolling 32Basic scrolling 33Virtual scrolling and paging Selecting 34Client-side row selection 35Server-side row selection Exporting 36MS Excel and MS Word AJAX 37AJAX r.a.d.grid 38Loading template 39AJAXifying standard controls 40AJAX request events 41JavaScript after AJAX 42Triggering an AJAX call outside of the grid Filtering 43Basic filtering 44Filtering in hierarchy 45Filtering template columns Hierarchy 46Three-level hierarchy 47Several tables at a level 48Client-side hierarchy load 49Mixed hierarchy load Grouping 50Outlook-style grouping 51Group-By expressions 52Client group load Insert/Update/Delete 53Automatic operations Extracting values 54Using column editors 55Using grid server-side API for extraction 56Auto-generated edit form with multiple columns 57Command item 58User control edit form 59Form template edit form 60Edit on double-click 61Editing XML using XmlDataSource Programmatic creation 62On PageInit 63On PageLoad 64Creating hierarchy programmatically Appearance 65Skins 66Styling Header, Footer and Pager items 67Styling edited rows Client-Side API and Events 68Client objects and events 69Client-side API 70Keys/Values client-side Accessibility 71Keyboard navigation Integration 72Google-like Filtering 73Context Menu

Demos

Automatic operations