Converting ListItemCollection to DataTable in Client side object model for SP Online

Dewadatta Avasare 0

Is there any way to convert ListItemCollection to a datatable like we could do in Sharepoint server side code using
SPListItemCollection listcol= listname.GetItems(query);
DataTable datatableOne= new DataTable();
if (listcol!= null && listcol.Count > 0)
{
datatableOne= listcol.GetDataTable();
}
Is there any GetDataTable method for CSOM because I am unable to find one in documentation for SP Online.
Help would be much appreciated.

1 answer

RaytheonXie_MSFT 31,376 Reputation points Microsoft Vendor

2022-01-11T08:08:13.517+00:00

Hi anonymous user ,
There is no similar method in CSOM (C#). You have to build manually as like following code.
163824-test.txt

You can check the methods of ListItemCollection from the document

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Dewadatta Avasare 0 Reputation points

2022-01-11T12:53:57.163+00:00

This is working but it is taking all the columns including the following columns:
MetaInfo
_ModerationStatus
_Level
UniqueId
owshiddenversion
FSObjType
Created_x0020_Date
Created
Title
FileLeafRef
Modified
FileRef

I edited the load by using : clientContext.Load(listItems, items => items.Include( item => item.Id, item => item.DisplayName, item => item.HasUniqueRoleAssignments));

but that doesn't display anything neither the column names nor the data in the list which the context.web.list is accessing even though it has 123 in ReqNo as defined in the CamlQuery , is there a way to fetch specific columns? like given in the attached txt file: ID and ReqNo columns

RaytheonXie_MSFT 31,376 Reputation points Microsoft Vendor

2022-01-12T02:49:48.58+00:00

Hi anonymous user ,
You can refer to the below code to get specified columns

Microsoft.SharePoint.Client.CamlQuery camlQuery = new CamlQuery(); camlQuery.ViewXml = @"<View>" + "<Query> " + "<Where>" + "<And>" + "<IsNotNull><FieldRef Name='ID' /></IsNotNull>" + "<Eq><FieldRef Name='ReqNo' /><Value Type='Text'>123</Value></Eq>" + "</And>" + "</Where>" + "</Query> " + "<ViewFields>" + "<FieldRef Name='ID' />," + "<FieldRef Name='ReqNo' />" + "</ViewFields>" + "</View>"; ListItemCollection listItems = spList.GetItems(camlQuery); clientContext.Load(listItems, singleitem => singleitem.Include(item => item["ID"],item => item["ReqNo"])); clientContext.ExecuteQuery();

RaytheonXie_MSFT 31,376 Reputation points Microsoft Vendor

2022-01-13T08:30:19.973+00:00

Hi anonymous user ,
I am checking to see if the problem has been resolved.

RaytheonXie_MSFT 31,376 Reputation points Microsoft Vendor

2022-01-21T09:42:49.677+00:00

Hi anonymous user ,
would you please provide us with an update on the status of your issue?
Sign in to comment