Sqldatasource updating parameters

@modified=3/15/2007 PM @userid=unknow @userid Domain=unknown @sort Order= @product Name=ok22 @product URL=http @product Support URL=http @original_product Name=ok @original_product URL=ok Notice how the "@original_product URL" has the same value as the "@original_product Name"? The @original_product URL should equal "http" since I didn't update the field's value.

sqldatasource updating parameters-15sqldatasource updating parameters-6sqldatasource updating parameters-11sqldatasource updating parameters-54

I've read several articles on the web an in the forums on this topic. NET beta version alteration from "original_" to "".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.Parameters that get values from a specific object, such as a control, session variable, or the user profile, require you to set additional properties.I believe those conversations do not describe my problem. Here's the ASP source code for a grid view and sql data source."INSERT INTO [home Page List] ([product Name], [product URL], [product Support URL], [description], [modified], [userid], [userid Domain], [sort Order]) VALUES (@product Name, @product URL, @product Support URL, @description, @modified, @userid, @userid Domain, @sort Order)""UPDATE home Page List SET product Support URL = @product Support URL, description = @description, modified = @modified, userid = @userid, userid Domain = @userid Domain, sort Order = @sort Order, product Name = @product Name, product URL = @product URL WHERE (product Name = @original_product Name) AND (product URL = @original_product URL)"I added a text box for every field in the grid to the form and update the fields when the user selects a record in the Grid View.I then added an Update button to the form and tied the event to this procedure: UPDATE home Page List SET product Support URL = @product Support URL, description = @description, modified = @modified, userid = @userid, userid Domain = @userid Domain, sort Order = @sort Order, product Name = @product Name, product URL = @product URL WHERE (product Name = @original_product Name) AND (product URL = @original_product URL) @description=interesting!