Create Datatable using .Net Client Context in SharePoint 2010

Create Data Table while using SharePoint 2010 Client Context with .Net Code I am using .net code to access SharePoint List.I created a method ExecuteSPQuery() which returns Data Table. For that I wrote below code. public static DataTable ExecuteSPQuery()     {         DataTable dtData = new DataTable();         Microsoft.SharePoint.Client.ListItemCollection listCollection = null;         ClientContext context = new ClientContext(“SITE_URL”);         try         {                        Site oWebsite = context.Site;             context.AuthenticationMode = ClientAuthenticationMode.Anonymous;             List list = … Read more

Display SharePoint List Items using ECMA Script – Client Object Model

Display SharePoint List Items using ECMA Script In this blog, I will explain, how to get list items using ECMA Script.ECMA script is a client side way to work with SharePoint object. Create a web part page in page library. Add a content editor web part on that page.In content editor webpart write below code: … Read more

Bind Drop-down with SharePoint List and display list items in a Gridview

In this blog, I will explain about below point through C# code:1. Bind all list in a dropdown2 Load List items in a Gridview once a user changes list name in dropdown. You need to create a visual webpart in Visual studio 2010. Visual WebPart ASCX code: <asp:DropDownList ID=”ddlList” AutoPostBack=”true” runat=”server”     onselectedindexchanged=”ddlList_SelectedIndexChanged”></asp:DropDownList><p>    <asp:Label … Read more

The method “GetItems” of the type “List” with id “{Guid}” is blocked by the administrator on the server.

I was working on SharePoint Client Context, and i was writing a piece of code to fetch items from SharePoint list. I got this error at this line:objContext.ExecuteQuery(); I solved this issue by executing powershell command.Open SharePoint Powershell  and type below command one by one. $webapp = Get-SPWebApplication “http://spserver”$webapp.ClientCallableSettings.AnonymousRestrictedTypes.Remove([microsoft.sharepoint.splist], “GetItems”)$webapp.Update()Open SharePoint Powershell  and type below command … Read more