Ok, Now I'm sure this was working the other day and I don't think I've changed anything but now it's not working and I can't see anything wrong with the code.
The product table is not updating with the new values.I think the problem is to do with the new values from the textbox not being retrieved.As when I assign updated Name to Label1 it displays the old product name value and not the one in the textbox.But I can't see why it wouldn't be bringing back the new textbox values. When the Details View control is bound to a data source control, the Details View control can take advantage of the data source control's capabilities and provide automatic updating, deleting, inserting, and paging functionality. Input controls that are appropriate for the field's data type (such as a Text Box or a Check Box control) are displayed with a field's value for the user to modify.
The Details View control provides built-in capabilities that allow the user to update, delete, insert, and page through items in the control. In edit mode, the Edit button is replaced with an Update and a Cancel button. For more information, see Validation Server Controls. The Details View control can automatically add a Command Field row field with an Edit, Delete, or New button by setting the Details View. Unlike the Delete button (which deletes the selected record immediately), when the Edit or New button is clicked, the Details View control goes into edit or insert mode, respectively. Validation server controls are also provided to assess user input. Auto Generate Insert Button properties to true, respectively. For more information, see Script Exploits Overview. Check any information that is sent from a client for executable script, SQL statements, or other code before displaying it in your application. NET provides an input request validation feature to block script and HTML in user input. Use one of the following methods to bind the Details View control to the appropriate data source type: For more information on data binding, see ASP. This control can be used to display user input, which might include malicious client script.