更新结束日期将导致“无效数据已被用于更新列表项”

Question

以下是完整的错误：

Invalid data has been used to update the list item. The field you are trying to update may be read only. 

我基本上尝试更新SharePoint中的日历事件。

首先我得到以下内容。

ClientContext clientContext = new ClientContext(deptUrl); 
Web web = clientContext.Web; 
List list = web.Lists.GetByTitle(deptCal); 
clientContext.Load(list); 

CamlQuery query = new CamlQuery(); 
query.ViewXml = "<View><Query><Where><IsNull><FieldRef Name='EndDate' /></IsNull></Where></Query><RowLimit>1</RowLimit></View>"; 

ListItemCollection allEventIds = list.GetItems(query); 

clientContext.Load(allEventIds, 
items => items.Include(
    item => item["EventID"], 
    item => item["EventDate"], 
    item => item["EndDate"] 
)); 

clientContext.ExecuteQuery(); 

随之而来的是循环：

foreach (var item in allEventIds) 
{ 
    Console.Write("EventId: {0} StartDate: {1}\n", item.FieldValues["EventID"], item.FieldValues["EventDate"]); 

       if (item.FieldValues.ContainsKey("EventDate")) 
       { 
        object objValue = item.FieldValues["EventDate"]; 
        if (objValue != null) 
        { 
         clientContext.Load(item);       
         DateTime endDate = DateTime.Parse(objValue.ToString()); 
         item["EndDate"] = endDate; //Updated this! 

        } 
       } 
       item.Update(); 

      } 

然后最后：

clientContext.ExecuteQuery(); 

如果我尝试更新任何其他项目[X]在列表项工作正常。当我尝试更新“EndDate”时。我收到以下错误：

Microsoft.SharePoint.Client.ServerException was unhandled 
    Message="Invalid data has been used to update the list item. The field you are trying to update may be read only." 
    Source="Microsoft.SharePoint.Client.Runtime" 
    ServerErrorCode=-2147024809 
    ServerErrorTypeName="System.ArgumentException" 
    ServerStackTrace="" 
    StackTrace: 
     at Microsoft.SharePoint.Client.ClientRequest.ProcessResponseStream(Stream responseStream) 
     at Microsoft.SharePoint.Client.ClientRequest.ProcessResponse() 
     at Microsoft.SharePoint.Client.ClientRequest.ExecuteQueryToServer(ChunkStringBuilder sb) 
     at Microsoft.SharePoint.Client.ClientRequest.ExecuteQuery() 
     at Microsoft.SharePoint.Client.ClientRuntimeContext.ExecuteQuery() 
     at Microsoft.SharePoint.Client.ClientContext.ExecuteQuery() 
     at DisplayOnCalendarUtility.Program.Main(String[] args) in C:\Projects\DisplayOnCalendarUtility\DisplayOnCalendarUtility\Program.cs:line 61 
     at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args) 
     at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() 
     at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) 
     at System.Threading.ThreadHelper.ThreadStart() 
    InnerException: 

Answer 1

Sharepoint是这样连接的。当你自己更新EndDate时，它会给你上面列出的一个错误。解决方案是一起更新EventDate和EndDate。

DateTime startDate = DateTime.Parse(objValue.ToString()); 
item["EventDate"] = startDate; 
item["EndDate"] = startDate; //Or Any other date you want to set to. 

http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/31e84d74-3ea8-44df-86dc-2dc62381ab3b/#33ad370b-b137-4c2f-bcaa-d6f5c714f4dd