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.

 
示例
 

MSDN :https://msdn.microsoft.com/zh-cn/library/office/microsoft.sharepoint.client.listitem.aspx 

posted @   秋风过、枯叶落  阅读(165)  评论(0编辑  收藏  举报
编辑推荐:
· 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语句:使用策略模式优化代码结构
· 字符编码:从基础到乱码解决
点击右上角即可分享
微信分享提示