View Single Post
  #1 (permalink)  
Old December 8th, 2003, 04:04 PM
CyberNet99 CyberNet99 is offline
Registered User
Join Date: Dec 2003
Location: Vancouver, BC, Canada.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Dreamweaver MX2004 Datagrid update error

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?

Reply With Quote