using DWMX2004 I have built a simple datagrid page, that connects to a sql2000 db.
The datagrid displays all of the information correctly, and will delete records as expected.
When I go to edit a record, all works as expected, until I go to update a record. Then I get the following error.
System.Data.SqlClient.SqlException: The variable name '@ProductID' has already been declared.
If anyone needs to see the code, I can post it for review to see if I am missing something, or have incorrectly added a field.
When I try comparing my code to the datagrid example from Macromedia, the example will not update a record either? Is there a bug in the dreamweaver controls for db updates within the datagrid?