Sqldatasource onupdating parameters
Although it is common for key fields to be read-only, there are valid scenarios where you will want to be able to update fields that are also used to match the data row to update.
For example, if you set Read Only=false on a field in the Grid View's Columns collection that is also set in Data Key Names, Grid View will pass the old value for the field in the Keys dictionary, whereas it will pass the new value for the field in the Values dictionary.
NET SQL database provider, such as SQL, OLEDB, ODBC, or Oracle." Select Command="SELECT [au_id], [au_lname], [au_fname], [state] FROM [authors]" Update Command="UPDATE [authors] SET [au_lname] = @au_lname, [au_fname] = @au_fname, [state] = @state WHERE [au_id] = @au_id" Delete Command="DELETE FROM [authors] WHERE [au_id] = @au_id"/ Notice the naming convention for parameters in the Update statement assigned to Update Command.