iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
Again, thanks for taking time to respond. It appears that declaring the Original_Id parameter in the UpdateParameters of the SQLDataSource is what is causing the Object Reference error. If I leave the statement as I originally wrote and remove the declaration, the grid works as expected. Allowing me to change key values if needed. Which is what was expected. What is confusing is that the Delete works with the Original_Id parameter declared. The @Original_Id parameter is provided by the DataSource control when you set the OldValuesParameterFormatString to "Original_{0}". This allows you access the parameter values before the change.
Thanks again.
Hi Handy,
Thanks
Thanks for taking the time to reply to my question. I've attached the DLL to this post. As far as the Id column, it is a primary key on the table. It is identified as the key field in the WebGrid (or should be). As far changing the value of the Id field, while rare, this event does happen and that is why the Original_Id is used in the WHERE clause to let the the SqlDataSource know what value to use when is using the UPDATE statement. The database uses cascading updates and deletes so that an issue isn't opened with the IT department everytime our clients want to change the foreign key because of a typing error or business requirements. Also, I took the update to the Id column out of the statement and received the same error. Believe me, I've looked at this until I'm crossed eyed and cannot see why this is failing.
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname