Details view not updating

In this post I will explain an issue related with Read-only data fields.

We will bound a Details View control to a Sql Data Source for simplicity reason you can use any data source control ... After configuring the pet Shop Sql Data Source and enable update, insert and delete we set the Details View Data Source Id to our pet Shop Sql Data Source Id and so the Details View now have 3 fields bound to Category table.

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.

What is the Updat Command that I need to specify if my Select command is SELECT Field A, Field B FROM My Table?

Still nothing happen and no error except insert part where it say cannot insert null value which I already did by select value from dropdownlist. I have to go to Edit Data Binding to set it target to specific column.When changing the status of a case using the 'Change Status' widget within Case Feeds and the Service Cloud Console, the Status field within the Highlight Panel does not update. Test that the Status field DOES update in the Highlight Panel (when My Domains is not yet enabled) a. Follow these steps to get My Domains enabled: https://sites.google.com/a/salesforce.com/customer-domains/home/getting-started-with-customer-domains b.This is only seen when the org also has "My Domains" (a custom domain) enabled. Whilst viewing the case, click 'Change Status' case feed link b. Note that the Status field DOES update in the highlight panel (expected). Log in with the Case feeds user, ensuring that the "My Domain" URL is active c. Note that the Status field DOES NOT update in the highlight panel (not expected).A common way to use these collections is to HTML-encode the values supplied by the user before they are stored in the data source. For more information about handling events, see NIB: Consuming Events.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. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. Imar --------------------------------------- Imar Spaanjaars Ht H, Imar --------------------------------------- Imar Spaanjaars NET 2.0 Professional section of the Wrox Programmer to Programmer discussions. To see if that's the problem, change the WHERE to: WHERE [ID] = @original_ID Also, make sure the Details View is set up correctly and uses the right keys and columns. Imar --------------------------------------- Imar Spaanjaars Thanks Regards On Jun 22, *am, "John" Hi I have a Details View that is bound to a sql server.Thanks Regards I have included the primary key in SELECT and it now works fine.I use all data Bound Field in Details View from SQL Server.I get the correct display, then I click Edit, then edit some dropdownlist with SQLData Source and some textboxes.

Leave a Reply

  1. d s dating sites 25-Apr-2020 15:15

    Not someone who thinks they are masculine and gets their eyebrows done like a woman. Anyone with a good sense of humor, make me laugh and you've got my atte...

  2. fdating commyprofile 09-Nov-2019 05:14

    These cute Asian teens (日本中文 | XXX 18 ) may come from a land far away, but these sweet babes will find a place in your loins and, perhaps, your heart!

  3. coffee dating service 09-Jan-2020 15:39

    This is one of life’s big mysteries but sometimes I think the key is identifying the right places to look. When you’re over 40, you’re usually pretty comfortable in your own skin You know what you like, and what you don’t.