Must declare the variable '@OrderID'

[Johan Olofsson]

I looked at the online demos of this control, section: "Insert/Update/Delete" / "Edit on Double-Click".

I created a project just like that and replaced the Session Data Source with an asp:SqlDataSource.
The latter does not take the argument PrimaryKeyFields which is set to "OrderID,ProductID" in the original data source.
Because of this (I assume), I get the error...

Unable to update Orders. Reason: Must declare the variable '@OrderID'.

..when trying to update. I am using the Northwind SQL database I have made no changes in the select or update command. How do I use this control with an asp:SqlDataSource?

  

[Daniel]

Hi Johan,

I have modified the demo in order to fit your needs. Please look at the attached file.

Best wishes,
Daniel
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Johan Olofsson]

Actually that code did not help me at all. I still get the same error.

[Daniel]

Hi Johan,

Please excuse me for sending you the wrong version of the project. I've attached the right version now.

Let me know whether you need additional assistance.

Kind Regards,
Daniel
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center