share point CSOM 客户端模式 创建 list
/// <summary> /// 创建新的列表 list /// </summary> /// <param name="web"></param> /// <param name="context"></param> public static void CreateLsit(Web web, ClientContext context) { //表名 string tableName = "Form11List"; ListCreationInformation listCreationInfo = new ListCreationInformation(); listCreationInfo.Title = tableName; listCreationInfo.TemplateType = (int)ListTemplateType.GenericList; List list_Info = web.Lists.Add(listCreationInfo); list_Info.Description = "New Description"; // Add fields to the list. Field field1 = list_Info.Fields.AddFieldAsXml( @"<Field Type='Choice' DisplayName='City' Format='Dropdown'> <Default>北京市</Default> <CHOICES> <CHOICE>上海市</CHOICE> <CHOICE>深圳市</CHOICE> </CHOICES> </Field>", true, AddFieldOptions.DefaultValue); Field field2 = list_Info.Fields.AddFieldAsXml( @"<Field Type='Text' DisplayName='Name'/>", true, AddFieldOptions.DefaultValue); Field field3 = list_Info.Fields.AddFieldAsXml( @"<Field Type='Number' DisplayName='Age'/>", true, AddFieldOptions.DefaultValue); Field field4 = list_Info.Fields.AddFieldAsXml( @"<Field Type='Note' DisplayName='Desc'/>", true, AddFieldOptions.DefaultValue); list_Info.Update(); context.ExecuteQuery(); List announcementsList = context.Web.Lists.GetByTitle(tableName); ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem newItem = announcementsList.AddItem(itemCreateInfo); newItem["Title"] = "My New Item!"; newItem["Name"] = "1"; newItem["Age"] = "28"; newItem["Desc"] = "1"; newItem.Update(); context.ExecuteQuery(); }
Contains CSOM expando fields, which correspond to the fields defined in the parent list. The CSOM expando field name is the name of the field defined in the list and the CSOM expando field value is the field value in the list item. The following table defines the mapping between field types and values.
Field Type |
CSOM Expando Field Value Type |
Meaning |
---|---|---|
Integer |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Int32. |
Field allows an integer value. |
Text |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM String. |
Field allows a limited-length string of text. |
Note |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM String. |
Field allows larger amounts of text. |
DateTime |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM DateTime. |
Field allows full date and time values, as well as date-only values. |
Counter |
It must be CSOM Int32. |
Counter is a monotonically increasing integer field, and has a unique value in relation to other values that are stored for the field in the list. Counter is used only for the list item identifier field, and not intended for use elsewhere. |
Choice |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM String. |
Field allows selection from a set of suggested values. A choice field supports a field-level setting which specifies whether free-form values are supported. |
Lookup |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Object. |
Field allows a reference to another list item. The field supports specification of a list identifier for a targeted list. An optional site identifier can also be specified, which specifies the site of the list which contains the target of the lookup. |
Boolean |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Boolean. |
Field allows a true or false value. |
Number |
When its value is undefined it must be CSOM null, otherwise it must be CSOM Double. |
Field allows a positive or negative number. A number field supports a field level setting used to specify the number of decimal places to display. |
Currency |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Double. |
Field allows for currency-related data. The Currency field has a CurrencyLocaleId property which takes a locale identifier of the currency to use. |
URL |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Object. |
Field allows a URL and optional description of the URL. |
Computed |
N/A |
Field renders output based on the value of other columns. |
Threading |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM String. |
Contains data on the threading of items in a discussion board. |
Guid |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM GUID. |
Specifies that the value of the field is a GUID. |
MultiChoice |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Array. |
Field allows one or more values from a set of specified choices. A MultiChoice field can also support free-form values. |
GridChoice |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Array. |
Grid choice supports specification of multiple number scales in a list. |
Calculated |
N/A |
Field value is calculated based on the value of other columns. |
File |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM String. |
Specifies a reference to a file that can be used to retrieve the contents of that file. |
Attachments |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Boolean. |
Field describes whether one or more files are associated with the item. See Attachments for more information on attachments. true if a list item has attachments, and false if a list item does not have attachments. |
User |
When its value is undefined it MUST be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Object. |
A lookup to a particular user in the User Info list. |
Recurrence |
When its value is undefined it MUST be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Boolean. |
Specifies whether a field contains a recurrence pattern for an item. |
CrossProjectLink |
When its value is undefined it MUST be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Boolean. |
Field allows a link to a Meeting Workspace site. |
ModStat |
When its value is undefined it MUST be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM int32. |
Specifies the current status of a moderation process on the document. |
Error |
N/A |
Specifies errors. Value = 24. |
ContentTypeId |
When its value is undefined it MUST be CSOM 空引用(无 在 Visual Basic 中), otherwise it MUST be CSOM Object. |
Field contains a content type identifier for an item. ContentTypeId conforms to the structure defined in ContentTypeId. |
PageSeparator |
N/A |
Represents a placeholder for a page separator in a survey list. PageSeparator is only intended to be used with a Survey list. |
ThreadIndex |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM String. |
Contains a compiled index of threads in a discussion board. |
WorkflowStatus |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Int32. |
Contains status on a running workflow for a particular item. |
AllDayEvent |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Boolean. |
The AllDayEvent field is only used in conjunction with an Events list. true if the item is an all day event (that is, does not occur during a specific set of hours in a day). |
WorkflowEventType |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Int32. |
A description of a type of a historical workflow event. See WorkflowEventType Enumeration for more information. |
Facilities |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Array. |
|
FreeBusy |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM String. |
|
Overbook |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM String. |
|
Confidential |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Boolean. |
|
WhatsNew |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Boolean. |
|
DueDate |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM DateTime. |
|
AllowEditing |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Boolean. |
|
SendTo |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Array |
|
Confirmations |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM String. |
|
CallTo |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM Array. |
|
CallTime |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM DateTime. |
|
Whereabout |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM String. |
|
From |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM DateTime. |
|
Until |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM DateTime. |
|
ContactInfo |
When its value is undefined it must be CSOM 空引用(无 在 Visual Basic 中), otherwise it must be CSOM String. |
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· AI与.NET技术实操系列:向量存储与相似性搜索在 .NET 中的实现
· 基于Microsoft.Extensions.AI核心库实现RAG应用
· 阿里巴巴 QwQ-32B真的超越了 DeepSeek R-1吗?
· 【译】Visual Studio 中新的强大生产力特性
· 10年+ .NET Coder 心语 ── 封装的思维:从隐藏、稳定开始理解其本质意义
· 【设计模式】告别冗长if-else语句:使用策略模式优化代码结构
· 字符编码:从基础到乱码解决