1- Add, Update and Delete List Items in SharePoint SSOM
using (SPSiteoSPsite = new SPSite("http://website url/"))
{
using (SPWeboSPWeb = oSPsite.OpenWeb())
{
oSPWeb.AllowUnsafeUpdates = true;
// Fetch the List
SPList list = oSPWeb.Lists["MyList"];
//Add a new item in the List
SPListItemitemToAdd = list.Items.Add();
itemToAdd["Title"] = "Test Title";
itemToAdd["Description"] = "Test Description";
itemToAdd.Update();
// Get the Item ID
listItemId = itemToAdd.ID;
// Update the List item by ID
SPListItemitemToUpdate = list.GetItemById(listItemId);
itemToUpdate["Description"] = "Changed Description";
itemToUpdate.Update();
// Delete List item
SPListItemitemToDelete = list.GetItemById(listItemId);
itemToDelete.Delete();
oSPWeb.AllowUnsafeUpdates = false;
}
}
2-Add, Update and Delete List Items in SharePoint CSOM
// Common for All
stringsiteUrl = "http://s07ssharv008lvs:37238/cdr";
ClientContextclientContext = newClientContext(siteUrl);
List oList = clientContext.Web.Lists.GetByTitle("StudentDetails");
// Get Records
CamlQuerycamlQuery = newCamlQuery();
camlQuery.ViewXml =
@"<View>
<Query>
<Where>
<Eq>
<FieldRef Name='StudentName'/>
<Value Type='Text'>Ram</Value>
</Eq>
</Where>
</Query>
<RowLimit>100</RowLimit>
</View>";
ListItemCollectionlistItems = oList.GetItems(camlQuery);
clientContext.Load(
listItems,
items => items
.Include(
item => item["Title"],
item => item["StudentName"]));
clientContext.ExecuteQuery();
foreach (ListItemlistIteminlistItems)
{
Console.WriteLine("Title: {0}", listItem["Title"]);
Console.WriteLine("StudentName: {0}", listItem["StudentName"]);
}
// Insert Records
ListItemCreationInformationlistCreationInformation = newListItemCreationInformation();
ListItemoListItem = oList.AddItem(listCreationInformation);
oListItem["Title"] = "Hello World";
oListItem.Update();
clientContext.ExecuteQuery();
// Update Records
oListItem = oList.GetItemById(17);
oListItem["Title"] = "Hello World Updated!!!";
oListItem.Update();
clientContext.ExecuteQuery();
// Delete Records
oListItem = oList.GetItemById(36);
oListItem.DeleteObject();
clientContext.ExecuteQuery();
3-Save, Update, and Delete List Items Using JavaScript (JSOM)
1-Save
varsiteUrl = '/sites/MySiteCollection';
functioncreateListItem() {
varclientContext = newSP.ClientContext(siteUrl);
varoList = clientContext.get_web().get_lists().getByTitle('Announcements');
varitemCreateInfo = newSP.ListItemCreationInformation();
this.oListItem = oList.addItem(itemCreateInfo);
oListItem.set_item('Title', 'My New Item!');
oListItem.set_item('Body', 'Hello World!');
oListItem.update();
clientContext.load(oListItem);
clientContext.executeQueryAsync(Function.createDelegate(this, this.onQuerySucceeded), Function.createDelegate(this, this.onQueryFailed));
}
functiononQuerySucceeded() {
alert('Item created: ' + oListItem.get_id());
}
functiononQueryFailed(sender, args) {
alert('Request failed. ' +args.get_message() + '\n' + args.get_stackTrace());
}
2-Update
varsiteUrl = '/sites/MySiteCollection';
functionupdateListItem() {
varclientContext = newSP.ClientContext(siteUrl);
varoList = clientContext.get_web().get_lists().getByTitle('Announcements');
this.oListItem = oList.getItemById(3);
oListItem.set_item('Title', 'My Updated Title');
oListItem.update();
clientContext.executeQueryAsync(Function.createDelegate(this, this.onQuerySucceeded),
Function.createDelegate(this, this.onQueryFailed));
}
functiononQuerySucceeded() {
alert('Item updated!');
}
functiononQueryFailed(sender, args) {
alert('Request failed. ' +args.get_message() + '\n' + args.get_stackTrace());
}
3-Delete
varsiteUrl = '/sites/MySiteCollection';
functiondeleteListItem() {
this.itemId = 2;
varclientContext = newSP.ClientContext(siteUrl);
varoList = clientContext.get_web().get_lists().getByTitle('Announcements');
this.oListItem = oList.getItemById(itemId);
oListItem.deleteObject();
clientContext.executeQueryAsync(Function.createDelegate(this, this.onQuerySucceeded),
Function.createDelegate(this, this.onQueryFailed));
}
functiononQuerySucceeded() {
alert('Item deleted: ' + itemId);
}
functiononQueryFailed(sender, args) {
alert('Request failed. ' +args.get_message() + '\n' + args.get_stackTrace());
}
4-Get Items
varsiteUrl = '/sites/MySiteCollection';
functionretrieveListItems() {
varclientContext = newSP.ClientContext(siteUrl);
varoList = clientContext.get_web().get_lists().getByTitle('Announcements');
varcamlQuery = newSP.CamlQuery();
camlQuery.set_viewXml('<View><Query><Where><Geq><FieldRef Name=\'ID\'/>' +
'<Value Type=\'Number\'>1</Value></Geq>
</Where></Query><RowLimit>10</RowLimit></View>');
this.collListItem = oList.getItems(camlQuery);
clientContext.load(collListItem);
clientContext.executeQueryAsync(Function.createDelegate(this, this.onQuerySucceeded),
Function.createDelegate(this, this.onQueryFailed));
}
functiononQuerySucceeded(sender, args) {
varlistItemInfo = '';
varlistItemEnumerator = collListItem.getEnumerator();
while (listItemEnumerator.moveNext()) {
varoListItem = listItemEnumerator.get_current();
listItemInfo += '\nID: ' + oListItem.get_id() +
'\nTitle: ' + oListItem.get_item('Title') +
'\nBody: ' + oListItem.get_item('Body');
}
alert(listItemInfo.toString());
}
functiononQueryFailed(sender, args) {
alert('Request failed. ' +args.get_message() + '\n' + args.get_stackTrace());
}
4-Save, Update, and Delete List Items Using JavaScript (Rest API)
1-Save
functionAddListItem()
{
varindustryVal = $("#Industry").val();
var Company = $("#Company").val();
$.ajax({
url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('EMPMaster')/items",
type: "POST",
data: JSON.stringify
({
'__metadata': {'type': 'SP.Data.EMPMasterListItem' },
"Title": Company,
"Industry":industryVal
}),
headers:
{
"Accept": "application/json;odata=verbose",
"content-type": "application/json; odata=verbose",
"X-RequestDigest": $("#__REQUESTDIGEST").val()
},
success: function(data)
{
retriveListItem();
alert("Item added successfully!");
},
error: function(err)
{
alert("Error while adding item: " + JSON.stringify(err));
}
});
}
2-Update
functionUpdateListItem () {
varindustryVal = $("#Industry").val();
var Company = $("#Company").val();
$.ajax({
url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('EMPMaster')/items(1)",
type: "POST",
data: JSON.stringify
({
'__metadata': {'type': 'SP.Data.EMPMasterListItem' },
"Title": Company,
"Industry":industryVal
}),
headers:
{
"Accept": "application/json;odata=verbose",
"content-type": "application/json; odata=verbose",
"X-RequestDigest": $("#__REQUESTDIGEST").val(),
"X-HTTP-Method": "MERGE",
"If-Match": "*"
},
success: function(data)
{
retriveListItem();
alert("Item updated successfully!");
},
error: function(err)
{
alert("Error while updating item: " + JSON.stringify(err));
}
});
}
3-Delete
functionDeleteListItem()
{
$.ajax({
url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('EMPMaster')/items(1)",
type: "POST",
headers: {
"Accept": "application/json;odata=verbose",
"content-type": "application/json; odata=verbose",
"X-RequestDigest": $("#__REQUESTDIGEST").val(),
"X-HTTP-Method": "DELETE",
"If-Match": "*"
},
success: function(data){
retriveListItem();
alert("Item deleted successfully!");
},
error: function(err){
alert("Error while deleting item: " + JSON.stringify(err));
}
});
}
4- Get Items
functionretriveListItem()
{
varresultGridHtmlMySubmission=''
$.ajax (
{
url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('EMPMaster')/items?$select=Title,Industry",
type: "GET",
data: JSON.stringify,
headers:
{
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"X-RequestDigest": $("#__REQUESTDIGEST").val(),
"IF-MATCH": "*",
"X-HTTP-Method": null
},
cache: false,
success: function(data)
{
for (vari = 0; i<data.d.results.length; i++)
{
var item = data.d.results[i];
resultGridHtmlMySubmission+='<tr>';
resultGridHtmlMySubmission+='<tdalign="center" valign="middle"><span title="Sr.No."><b>'+item.Title+'</b></span></td>';
resultGridHtmlMySubmission+='<td align="center" valign="middle"><span title="Sr.No."><b>'+item.Industry+'</b></span></td>';
resultGridHtmlMySubmission+='</tr>';
}
$("#tbodycontent").html(resultGridHtmlMySubmission);
},
error: function(data)
{
// $("#ResultDiv").empty().text(data.responseJSON.error);
}
});
}
5-Save, Update, and Delete List Items Using JavaScript (SP Services)
1-Save
functionAddNewListItem(title)
{
$().SPServices({
operation:"UpdateListItems",
async: false,
batchCmd: "New",
listName: "StudentDetails",
valuepairs:[["Title",'Harmeet Singh']],
completefunc:function(xData, Status)
{
alert("Item inserted");
}
});
}
2-Update
functionUpdateListItem(title)
{
$().SPServices({
operation:"UpdateListItems",
async: false,
batchCmd: "Update",
listName: "StudentDetails ",
ID: 3,
valuepairs:[["Title",”Mahesh”]],
completefunc:function(xData, Status)
{
alert("Item Updated");
}
});
}
3-Delete
functionDeleteListItem()
{
$().SPServices({
operation:"UpdateListItems",
async: false,
batchCmd: "Delete",
listName: "StudentDetails",
ID: 3,
completefunc:function(xData, Status)
{
alert("Item Deleted");
}
});
}
4- Get Items
functionGetItem()
{
$().SPServices({
operation: "GetListItems",
async: false,
listName: "StudentDetails",
CAMLViewFields: "<ViewFields><FieldRef Name='Title' /></ViewFields>",
completefunc: function (xData, Status)
{
$(xData.responseXML).find("[nodeName='z:row']").each(function() {
varliHtml = "<li>" + $(this).attr("ows_Title") + "</li>";
$("#ulTasks").append(liHtml);
});
}
});
}
6-Save, Update, and Delete List Items Using JavaScript (Angular JS)
1Get Items
varmyAngApp = angular.module('SharePointAngApp', ['ui.bootstrap', 'ngResource']);
myAngApp.controller('spCustomerController', function ($scope, $http)
{
$scope.eEditable= -1;
$http({
method: 'GET',
url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getByTitle('UserTest')/items?$select=Title,Employee,Company,ID",
headers:
{
"Accept": "application/json;odata=verbose"
}
}).success(function (data, status, headers, config) {
$scope.customers = data.d.results;
$scope.totalItems = $scope.customers.length;
$scope.numPerPage = 5;
$scope.currentPage = 1;
$scope.paginate = function (value) {
var begin, end, index;
begin = ($scope.currentPage - 1) * $scope.numPerPage;
end = begin + $scope.numPerPage;
index = $scope.customers.indexOf(value);
return (begin <= index && index < end);
};
// var a= $scope.customers;
}).error(function (data, status, headers, config) {
});
1Get ItemsBy ID
//$scope.customers = [];
$scope.getByDataID = function (customer) {
varcustomerId= customer;
$.ajax({
url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('UserTest')/getitembyid("+customerId+")/?$select=Title,Employee,Company,ID",
type: "GET",
headers:
{
"Accept": "application/json;odata=verbose",
"content-type": "application/json; odata=verbose",
"X-RequestDigest": $("#__REQUESTDIGEST").val()
},
success: function(data){
$( "#btnupdateval" ).prop( "disabled", false );
$scope.customer=data.d;
$('#txtItemId').val(data.d.Id);
$('#txttitle').val(data.d.Title);
$('#txtcompany').val(data.d.Employee);
$('#txtemployee').val(data.d.Company);
$( "#btnsave" ).prop( "disabled", true );
},
error: function(err){
alert("Error while fetching list item: " + JSON.stringify(err));
}
});
};
1-Save
$scope.Save = function () {
$.ajax({
url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('UserTest')/items",
type: "POST",
data: JSON.stringify
({
'__metadata': {'type': 'SP.Data.UserTestListItem' },
"Title": $scope.customer.Title,
"Employee":$scope.customer.Employee,
"Company":$scope.customer.Company }),
headers: {
"Accept": "application/json;odata=verbose",
"content-type": "application/json; odata=verbose",
"X-RequestDigest": $("#__REQUESTDIGEST").val()
},
success: function(data){
alert("Item added successfully!");
},
error: function(err){
alert("Error while adding item: " + JSON.stringify(err));
}
});};
4-Update
$scope.Update = function () {
$.ajax({
url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('UserTest')/items("+$scope.customer.ID+")",
type: "POST",
data: JSON.stringify({
'__metadata': {'type': 'SP.Data.UserTestListItem' },
"Title": $scope.customer.Title,
"Employee":$scope.customer.Employee,
"Company":$scope.customer.Company
}),
headers: {
"Accept": "application/json;odata=verbose",
"content-type": "application/json; odata=verbose",
"X-RequestDigest": $("#__REQUESTDIGEST").val(),
"X-HTTP-Method": "MERGE",
"If-Match": "*"
},
success: function(data){
alert("Item updated successfully!");
},
error: function(err){
alert("Error while updating item: " + JSON.stringify(err));
}
});
};
5-Delete
$scope.Delete= function (customer) {
varcustomerId=customer;
$.ajax({
url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('UserTest')/items("+customerId+")",
type: "POST",
headers: {
"Accept": "application/json;odata=verbose",
"content-type": "application/json; odata=verbose",
"X-RequestDigest": $("#__REQUESTDIGEST").val(),
"X-HTTP-Method": "DELETE",
"If-Match": "*"
},
success: function(data){
alert("Item deleted successfully!");
},
error: function(err){
alert("Error while deleting item: " + JSON.stringify(err));
}
});
};});
