using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint.Client;
using System.Data;
namespace ConsoleApplication5 {
class Program {
static void Main(string[] args) {
string PeoplePicker, Lookup;
ClientContext context = new ClientContext("SiteName");
List list = context.Web.Lists.GetByTitle("ListName");
CamlQuery query = new CamlQuery();
query.ViewXml = "<View/>";
ListItemCollection items = list.GetItems(query);
context.Load(list);
context.Load(items);
context.ExecuteQuery();
DataTable Listtodt = new DataTable();
Listtodt.Columns.Add("ID");
Listtodt.Columns.Add("Title");
Listtodt.Columns.Add("PersonorGroupfield");
Listtodt.Columns.Add("SingleLineOfText");
Listtodt.Columns.Add("LookupField"); // Value come from another parent sharepoint list
foreach(ListItem item in items) {
var testPersonorGroupfield = (FieldUserValue) item["PersonorGroupfield"];
if (testPersonorGroupfield == null) {
PeoplePicker = "";
} else {
PeoplePicker = testPersonorGroupfield.LookupValue;
}
var childIdField = item["LookupField"] as FieldLookupValue;
if (childIdField != null) {
var childId_Value = childIdField.LookupValue;
var childId_Id = childIdField.LookupId;
Lookup = childId_Value.ToString();
} else {
Lookup = "";
}
Listtodt.Rows.Add(item.Id, item["Title"], PeoplePicker, item["SingleLineOfText"], Lookup);
}
}
}
}Below code show you how to insert data to datatable to SharePoint list using client object model.
