Updating is not supported by data source unless updatecommand
Figure 2: Select the Delete Query Property from the Properties Window provide a value for this parameter (leave its Parameter source at None ).
Once we add deleting support to the Grid View, the Grid View will automatically supply this parameter value, using the value of its property added, the Grid View s smart tag now contains the Enable Deleting option. As discussed in An Overview of Inserting, Updating, and Deleting, this causes the Grid View to add a Command Field with its .
For a live example that demonstrates automatic data source operations, see Automatic operations.When the Sql Data Source control s method is invoked either programmatically or automatically from a data Web control a connection to the database is established, the parameter values are assigned to the query, and the command is shuttled off to the database.The results are then returned as either a Data Set or Data Reader, depending on the value of the control s value has been specified, the Enable Inserting, Enable Editing, or Enable Deleting option in the corresponding data Web control s smart tag will become available.Rad Grid can extract values from columns that are set as read-only, if the column's Force Extract Value property is set to: The default value for the Force Extract Value property is "None", which means that the extraction of default values will not be performed for read-only columns.Automatic operations through the Data Source control are not supported when you use standard Web User Control as a custom edit form.