CSOM:- Programmatically Get SharePoint list person or group column value in SharePoint using CSOM

  public static string GetUserFieldType(ClientContext ctx, FieldUserValue value)
        {
            var objList = ctx.Site.RootWeb.SiteUserInfoList;
            var userInfo = objList.GetItemById(value.LookupId);
            ctx.Load(userInfo, i => i.ContentType);
            ctx.ExecuteQuery();
            return userInfo.ContentType.Name;
        }


  public void  Getpersonorgroupvalue()
            {
 using (ClientContext clientContext = new ClientContext("SiteCollectionUrl"))
            {
                clientContext.Credentials = new NetworkCredential("UserName", "Password", "DomainName");
                Web web = clientContext.Web;
                clientContext.Load(web);
                clientContext.ExecuteQuery();
var list = web.Lists.GetByTitle("ListName");
                CamlQuery camlQuery = new CamlQuery();
                camlQuery.ViewXml = @"<View></View>";
                Microsoft.SharePoint.Client.ListItemCollection lstCollection = list.GetItems(camlQuery);
                clientContext.Load(lstCollection);
                clientContext.ExecuteQuery();
                FieldUserValue[] objfieldvalue = lstCollection[0]["PersonGroupColumnName"] as FieldUserValue[];

   if (objfieldvalue != null && objfieldvalue.Length > 0)
                {
                    for (int UserIndex = 0; UserIndex < objfieldvalue.Length; UserIndex++)
                    {
                        string type = GetUserFieldType(clientContext, objfieldvalue[UserIndex]);
                        break;
                    }
                }
    for (int UserIndex = 0; UserIndex < objfieldvalue.Length; UserIndex++)
                     {
                      string UserId =Convert.ToString(objfieldvalue[UserIndex].LookupValue);
                        break;
                     }

}
              }

Continue Reading...

Select Insert update delete SharePoint custom list data using CSOM C# Example

public class EmpInfo
        {
            public EmpInfo(string Name, string Age)
            {
                _Name = Name;
                _Age = Age;
            }
            private string _Name;
            private string _Age;
            public string Name
            {
                get { return _Name; }
                set { _Name = value; }
            }
            public string Age
            {
                get { return _Age; }
                set { _Age = value; }
            }
        }
public void getdata()
        {
            NetworkCredential credentials = new NetworkCredential("UserName", "Pwd ", "DomainName");
            List<EmpInfo> lsts = new List<EmpInfo>();
            ClientContext cc = new ClientContext("http://Abc:4000/sites/Rsite1/");
            cc.Credentials = credentials;
            Web web = cc.Web;
            List list = web.Lists.GetByTitle("Users");
            CamlQuery caml = new CamlQuery();
            ListItemCollection items = list.GetItems(caml);
            cc.Load<List>(list);
            cc.Load<ListItemCollection>(items);
            cc.ExecuteQuery();
            foreach (Microsoft.SharePoint.Client.ListItem item in items)
            {
                string Name = Convert.ToString(item.FieldValues["Name"]);
                string Age = Convert.ToString(item.FieldValues["Age"]);
                lsts.Add(new EmpInfo(Name, Age));
            }
            GridView1.DataSource = lsts;
            GridView1.DataBind();
        }
Insert item:-
            NetworkCredential credentials = new NetworkCredential("UserName", "Pwd ", "DomainName");
            ClientContext context = new ClientContext("http://Abc:4000/sites/Rsite1/");
            context.Credentials = credentials;
            Web web = context.Web;
            List list = web.Lists.GetByTitle("Users");
            ListItemCreationInformation newItem = new ListItemCreationInformation();
            ListItem listItem = list.AddItem(newItem);
            listItem["Name"] = "Mohamed";
            listItem["Age"] = "27";
            listItem.Update();
            context.ExecuteQuery();
Update Item:-
            NetworkCredential credentials = new NetworkCredential("UserName", "Pwd", "DomainName");
            ClientContext context = new ClientContext("http://Abc:4000/sites/Rsite1/");
            context.Credentials = credentials;
            List list = context.Web.Lists.GetByTitle("Users");
            CamlQuery query = new CamlQuery();
            query.ViewXml = "<View/>";
            ListItemCollection listItems = list.GetItems(query);
            context.Load(listItems);
            context.ExecuteQuery();
            ListItem item = listItems[0];
            item["Name"] = "Mohamed sithik...";
            item["Age"] = "26";
            item.Update();
            context.ExecuteQuery();
Delete Item:-
            NetworkCredential credentials = new NetworkCredential("UserName", "Pwd ", "DomainName");
            ClientContext context = new ClientContext("http://Abc:4000/sites/Rsite1/");
            context.Credentials = credentials;
            List list = context.Web.Lists.GetByTitle("Users");
            ListItemCollection listItems = list.GetItems(new CamlQuery() { ViewXml = "<View/>" });
            context.Load(listItems);
            context.ExecuteQuery();
            listItems[2].DeleteObject();
            context.ExecuteQuery();

Continue Reading...