I have a gridview and would like to update one of the columns within the gridview.
I want to be able to search for the product id of an item and when the item is displayed the user can enter a number to a textbox. When the submit button is clicked I want the number in the textbox to be added to the number already in one of the database columns (stock).
E.g - The number in the database column for the particular product is 10.
User enters 5 into text box then clicks submit.
New value in stock column for product is 15.
Hope i have explained clearly enough.
I have the search working so its just the update I'm having difficulty with.
Thanks for any help.