Thanks, naturehermit for your help. What does VM mean?
I have submitted a bug report available here: https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=305579
Just in case some needs some time to kill ;) here are the steps to reproduce the prob.
- Create a new website in VWB EE 2008 Beta 2
- Add a new database to the App_Data folder
- Add a new table to the database with the following table definition
-- ProjectID (DataType = int, Primay Key, IsIdentity = True, Identity Increment = 1, Identity Seed = 1)
-- Name (DataType = nvarchar(100), Allow Nulls = false)
-- Description (DataType = nvarchar(MAX), Allow Nulls = false)
-- StartDate (DataType = smalldatetime, Allow Nulls = false)
-- EndDate (DataType = smalldatetime, Allow Nulls = false)
-- Notes (DataType = nvarchar(MAX), Allow Nulls = true)
- Put in two sets of data in the table, one that has no value for Notes and one that does.
- In design view, add a SqlDataSource, link it to the above database and allow Insert, Delete and Update database with Optimistic Concurrency turned on.
- In design view, add a DetailsView control and pick the above as Data Source. Enable Paging, Inserting, Editing and Deleting
- View in browser.
- Click Edit for the entry that does not have a value for Notes. Make any changes to any field, then click Update.
- Do the same for the entry that does have a value for Notes.
The data set for which there is no Notes does not get updated with new information. It just displays the same information as before changes were submitted. It is not possible to delete this data entry either.
Everything works fine for the data set that has a value for Notes except until you delete the value for Notes and then it starts behaving like the above.
If optimistic concurrency is turned off, data editing/deleting behaves normally without the above problems.