Hello to all, I'm using a gridview to get a list of products for a selected product category (from a DDL control). The gridview shows all the products as it should, and a select link for each product.

When I select a product it is openned up in a Form View control on the same page below the gridview in the "Edit" template mode. I changed the default mode in the Form View Properties to "edit".

The edit mode contains the default links at the bottom "Update" and "Cancel". After making a change to the price of the selected product and clicking the update link I noticed that I changed every product in the DB to the selected product as well as added an additional product of the same. In other words I started with 35 different products and tried to update one of them and now I have 36 of the same product.

Questions:

1. Could this be because I'm updating to a MSSQL 2000 DB?

2. How can I rewrite the code in VB to only update the selected product and not the entire product table?

Robert

This sounds like a missing WHERE clause in your SQL statement, although it's weird that you get a new item as well.

Can you post the relevant code?

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Yes you are correct. There was a missing WHERE clause for the Update statement in the stored procedure "insertupdatesinglerecord". Adding "WHERE Id = @ Id" fixes this problem.

I think it was also adding a new one because it didn't have one. An, Id that is.

Thanks

Robert