.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> SharePoint >> Post New Question Subscribe to Interview Questions

What will you do for fast and efficient retrieval of items from sharepoint lists ?

Posted By :Sagar Pardeshi     Posted Date :December 24, 2013    Points :40   Category :SharePoint 
You can use either SPquery object from SPquery class or you can use PortalSiteMapProvider class. PortalSiteMapProvider class includes a method called GetCachedListItemsByQuery that retrieves data from a list based on an SPQuery object that is provided as a parameter to the method call. The method then looks in its cache to see if the items already exist. If they do, the method returns the cached results, and if not, it queries the list, stores the results in cache and returns them from the method call.

You can also find related Interview Question to What will you do for fast and efficient retrieval of items from sharepoint lists ?  below: 

How to query from multiple lists in SharePoint?

  
Using SPSiteDataQuery you can get data from multiple lists. (More...)

How to Update SharePoint List Items without Creating New Versions?

  
SystemUpdate method avoids updating modified and modifier fields.
here is the sample below.
SPSite site = new SPSite("http://mossportal/");
SPWeb web = site.OpenWeb();
SPList leaveslist = web.Lists["My Leaves"];
SPListItem collection = leaveslist.Items[0];
collection["Earned_x0020_Leaves"] = "1";
collection.SystemUpdate(false);
collection.Update(); (More...)

How do you return SharePoint List items using SharePoint web services?

  
In order to retrieve list items from a SharePoint list through Web Services, you should use the lists.asmx web service by establishing a web reference in Visual Studio. The lists.asmx exposes the GetListItems method, which will allow the return of the full content of the list in an XML node. It will take parameters like the GUID of the name of the list you are querying against, the GUID of the view you are going to query, etc.
Side Question: I got asked how I built queries with the lists.asmx web service. In order to build queries with this service, one of the parameters that the GetListItems method exposes is the option to build a CAML query. There are other ways to do this as well, but that was how I answered it. (More...)

When retrieving List items using SharePoint Web Services, how do you specify explicit credentials to be passed to access the list items?

  
In order to specify explicit credentials with a Web Service, you generally instantiate the web service, and then using the credentials properties of the Web Service object you use the System.Net.NetworkCredential class to specify the username, password, and domain that you wish to pass when making the web service call and operations.
(More...)

How do you return SharePoint List items using SharePoint web services?

  
Ans.
In order to retrieve list items from a SharePoint list through Web Services, you should use the lists.asmx web service by establishing a web reference in Visual Studio. The lists.asmx exposes the GetListItems method, which will allow the return of the full content of the list in an XML node. It will take parameters like the GUID of the name of the list you are querying against, the GUID of the view you are going to query, etc. (More...)

how to Join 2 Lists in SharePoint 2010 ?

  
In sharepoint 2010 we join 2 lists using query.Join function. (More...)

What is the .NET that allows the retrieval of data by a unique key?

  
HashTable is the .NET collection class that allows the retrieval of data by a unique key (More...)

How can I add icons to menu items?

  
Unfortunately there is no built-in feature for this.You need configure the menu items to be owner-drawn (set OwnerDraw to True) and then use GDI+ to draw both the text and graphics (handle the MeasureItem and DrawItem events). Microsoft's "Got Dot Net" site (www.gotdotnet.com) is a good place to start for information about implementing owner-drawn controls. (More...)

What is Sharepoint?

  
Sharepoint is a Portal Collaboration Software provided by Microsoft , That can be configured to run Intranet, Extranet and Internet sites (More...)

What is the difference between SharePoint Portal Server and Windows SharePoint Services?

  
SharePoint Portal Server is the global portal offering features like global navigation and searching.Windows SharePoint Services is more content management based with document libraries and lists. You apply information to certain areas within your portal from windows share point Services or directly to portal areas. (More...)

What is a document library in SharePoint?

  
A document library in SharePoint is where you upload your main or core documents. Document Library is consist of a row and column view with links to the documents, When the document is updated and so is the link is created on your site. You can also track metadata of your documents. Meta data in SharePoint is consisting of document properties. (More...)

What is a meeting workspace in SharePoint?

  
A meeting workspace in SharePoint is a place to store information, attendees, and tasks related to a specific meeting. (More...)

What is a document workspace in SharePoint?

  
Document workspaces in SharePoint consist of information surrounding a single or multiple documents. (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend