Adding Items Into A SharePoint list Programmatically Using C#

In this article we will to learn how to programmatically insert items into a SharePoint list using C#. Here, I am writing the code in a console application.

Step 1: Go to File, New, Project, Templates, then Visual C#, Windows and select the Console Application,

You will get the Project structure like below and open the Program.cs file.



Step 2: Go to Solution Explorer, select ‘References’, then right click and add the following references,

‘Microsoft.SharePoint.Client’, ‘System.Security’, ‘Microsoft.SharePoint.Client.Runtime’. Will see the use of these later in this article.

a) Refer the namespaces in the code at the namespace list at the starting of the program.

b) We require these namespaces to utilize ClientContext, ListItemCreationInformation, ListItem, SharePointOnlineCredentials, SecureString classes which we are going to use in this code.

Step 3: Now let’s start the implementation

a) To insert a list item from console we first need to connect with the SharePoint site. For that we need valid login and secure password.
1. Here we used the SecureString() class which is similar to a string object and stores a text value that should be kept confidential. The use of a SecureString is to secure a user's password to use it as a credential while starting a new process.

2. The value of the SecureString is automatically encrypted when the instance is initialized. Note: Can also instantiate it like,
b) Now initialize an instance of the ClientContext object for the specified SharePoint site.
1. The use ofClientContext class is to return context information about current web application, site collection and sites etc. To know more about ClientContext please refer this link.

c) Start getting list and creating list item objects,

1. Get the list from web called "myproducts",
2. To specify the properties of the new list item create an abject of ListItemCreationInformation and pass it as parameter to the method called AddItem of the List class.