using System;
using System.Text;
using Microsoft.SharePoint.Client;
namespace DMLSharePointList
{
class Program
{
private void
Insert()
{
string siteUrl =
"http://rohit:34143/";
//sharepoint site address
ClientContext clientContext =
new ClientContext(siteUrl);
List oList =
clientContext.Web.Lists.GetByTitle("Products");
ListItemCreationInformation
listCreationInformation = new
ListItemCreationInformation();
ListItem oListItem =
oList.AddItem(listCreationInformation);
oListItem["Title"] =
"6";
oListItem["ProductID"] =
"P006";
oListItem["ProductName"] =
"MotherBoard";
oListItem.Update();
clientContext.ExecuteQuery();
Console.WriteLine("Item Added");
}
private void
Update()
{
string siteUrl =
"http://rohit:34143/";
//sharepoint site address
ClientContext clientContext =
new ClientContext(siteUrl);
List oList =
clientContext.Web.Lists.GetByTitle("Products");
ListItem oListItem =
oList.GetItemById(1);
oListItem["Title"] =
"1";
oListItem["ProductID"] =
"P001";
oListItem["ProductName"] =
"Harddisk";
oListItem.Update();
clientContext.ExecuteQuery();
Console.WriteLine("Item Updated");
}
private void
Delete()
{
string siteUrl =
"http://rohit:34143/";
//sharepoint site address
ClientContext clientContext =
new ClientContext(siteUrl);
List oList =
clientContext.Web.Lists.GetByTitle("Products");
ListItem oListItem = oList.GetItemById(1);
oListItem.DeleteObject();
clientContext.ExecuteQuery();
Console.WriteLine("Item Deleted");
}
static void
Main(string[] args)
{
Program obj =
new Program();
byte ch = 0;
do
{
Console.WriteLine("\t\t\t----Select option----\t\t\t");
Console.WriteLine("\t\t\t----Press (1) For Insert ----\t\t\t");
Console.WriteLine("\t\t\t----Press (2) For Update ----\t\t\t");
Console.WriteLine("\t\t\t----Press (3) For Delete ----\t\t\t");
Console.WriteLine("\t\t\t----Press (0) For Exit ----\t\t\t");
ch = Convert.ToByte(Console.ReadLine());
switch (ch)
{
case
1:
obj.Insert();
break;
case 2:
obj.Update();
break;
case 3:
obj.Delete();
break;
default:
Console.WriteLine("Invalid Option");
break;
}
} while (ch != 0);
}
}
}