Bind ListItemCollection as a DataSource of a DataGridView

Question

I am using SharePoint Server 2013. I am trying to show a list data in a DataGridView in a windows forms application(client application). I obtained the ListItemCollection object related to the specific list. How can I map that object to the datasource of the DataGridView?

I can't find any specific way to obtain a DataTable object from the ListItemCollection object. Because the list I used to obtain data is selected by a drop down list. So there is no predetermined columns for a Datatable object. Thanks in advance. :)

Answer 1

Check the below link

http://dinooptech.blogspot.in/2012/11/retrieving-list-items-with-caml-query.html

Thanks

Girish

---

Girish

Answer 2

@Girish

Unfortunately, ListItemCollection object in SharePoint Client Object Model doesn't have a GetDataTable() method. :( 

Thanks for the help.cheers.

Answer 3

you can bind the gridview to a list or array but remember to set autogenerated columns to false and select only the columns you loaded while executing the query 

 dataGridView1.AutoGenerateColumns = false;
            context.Load(itemscoll,
                 items => items.Include(
                    item => item.Id,
                    item => item.DisplayName,
                    item => item.HasUniqueRoleAssignments));
            context.ExecuteQuery();

            dataGridView1.DataSource = itemscoll.ToList();

---

Hope that helps|Amr Fouad|MCTS,MCPD sharePoint 2010