Updating gridview rows using sqldatasource
Scenario: I am using the Row Updating Event of the Gridview to do updates because I need more flexibility than the SQLDatasource Update provides.
You can get parameter values from various sources, including ASP.
For more information on the dictionaries passed by a data-bound control, see With named parameters, the order in which the parameters is specified in the command's parameters collection is not important.
However, you must ensure that the parameter names that you use in your SQL command correspond to the names of the parameters in the associated collection.
NET application variables, user identities, and user-selected values.
You can use parameters to supply search criteria for data retrieval; to supply values to be inserted, updated, or deleted in a data store; and to supply values for sorting, paging, and filtering. You can specify a name, type, direction, and default value for each parameter.