Sqldatasource change update parameters

If you specify a stored procedure for a command, you must specify that the command type of the command is StoredProcedure. The SqlDataSource control adds the value of the ParameterPrefix property to the beginning of all parameter names.

The default prefix is " ". If a data-bound control such as a GridView control is bound to the SqlDataSource control, during an update or delete operation the data-bound control passes both current and original record values to the SqlDataSource control. The current values are passed in the Values dictionary. The original values are passed in the Keys or OldValues dictionaries.

The contents of these dictionaries are appended to the underlying DbCommand object's Parameters collection for a given data operation. In the SqlDataSource control's SQL commands, you use a naming convention to match parameter placeholders to the old values passed into the command. Consider an update operation that involves a field named LastModifiedDate.

The current value for the field is passed in the Values dictionary and the original value for the field is passed in the OldValues dictionary. You can then include both parameters in an SQL statement to differentiate between the current and original values for the field, as shown in the following example:. The ability to separate current and original values in a command is essential when performing optimistic concurrency checks or working with a data source where the primary key can be modified.

By default, the SqlDataSource control uses the System. Learn more. Asked 2 years, 4 months ago. Active 2 years, 1 month ago. Viewed times. ActionLink item. QueryString["device"]; Chart1. DataBind ; GridView1. Sir Asks a Lot. Okay, I rescind the "Please be gentle" requirement.

Does anyone have anything at all? ToString ; if entry. Add " userName" ; ds. Add " city" ; ds. Add " UserId" ; But I don't know the right syntax, can someone direct me in right direction please. Community Bot 1 1 1 silver badge. Mathematics Mathematics 6, 20 20 gold badges 67 67 silver badges bronze badges. Add a comment. Active Oldest Votes.

Open ; cmd. Add new SqlParameter " Name", userName ; cmd. Add new SqlParameter " city", city ; cmd. Doug Wilson Doug Wilson 4, 3 3 gold badges 29 29 silver badges 34 34 bronze badges. SqlDataSource is intended for databinding to controls on a WebForm. It's way overkill for what you're doing, particularly when you're trying to do it manually.

If you want to change the parameter name in the update parameter list here you can do this by changing the updatecommand text and update command like below:.

Here i have a complete example of how to use the sqldatasource and gridview to update the records using the stored procedure. Is there any specific reason that column to be identified as UserId in the code? If not, this should resolve your problem right,. Column is defined in stored procedure as "UserId". Thanks prabhakarbn. The content you requested has been removed.