Enable Editing on Gridview - RESOLVED
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.
EDIT: I've decided to use a details view, as I have managed to get that working