Hi,

I have a gridview displaying 3 fields of my table(Quantity, PrintPrice, NoPrintPrice).

I want the update command to only allow these fields to be edited, and the others to remain the same.

My update command is this:

UpdateCommand="UPDATE [HIPPricing] SET [Quantity] = @Quantity, [Price] = @Price, [NoPrintPrice] = @NoPrintPrice WHERE [ID] = @original_ID AND [ProductCode] = @original_ProductCode AND [CustomerCode] = @original_CustomerCode AND [CoverType] = @original_CoverType AND [Pages] = @original_Pages"

I thought this would do it, but my edit just doesn't do anything.

Any thoughts?

EDIT: I've decided to use a details view, as I have managed to get that working