Asp detailsview not updating

09 Feb

dictionary contains the names and values of fields that uniquely identify the record to update or delete, and always contains the original values of the key fields before the record was edited.I am new to so I'm just now getting into using Template Fields.Hi I have a Details View that is bound to a sql server.Problem is when I press the auto generated Edit button make some change and press the Update link I get the below error; Updating is not supported by data source 'mysqlserver' unless Update Command is specified.

There are a number of ways to create a data source control, including dragging data elements from Server Explorer or Database Explorer onto the page.By using a combination of a data source control that encapsulates data access and controls that display records in an editable format, you can create a data entry page that allows users to edit existing records or insert new ones, all without any code.A Visual Studio project with source code is available to accompany this topic: Download.I'm not sure if I have to do something else since it's in an Edit Template? After binding to the datafield, as you suggested (it's called "Status" in my database) I had to update my Update Parameter and query.I thought it should pass the Drop Down List ID, which was "Status List".If you use an existing table, the steps in some of the procedures will not match your database exactly.However, the concepts illustrated in the walkthrough will be the same.The To perform the steps in this walkthrough, you must have a database table.If you do not already have a table, you can create one by using the following procedure.In this walkthrough, you will start with the This walkthrough has illustrated the basics of creating a Web page that allows users to modify data records.You might want to explore additional data capabilities of ASP.