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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SPquery skips or omits some items in large list

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :SharePoint

I am using below SPQuery  with known options for better performance like rowlimit and pagenation and including sub-folders.

SPWeb objWeb = mySite.OpenWeb();

SPList objList = objWeb.Lists["My list"];

SPQuery myQuery = new SPQuery();

myQuery.Query = "<Where><Eq><FieldRef Name='Title'/><Value Type='Text'>"+myValue+"</Value></Eq></Where>";

SPListItemCollection myItemcoll = objList.GetItems(myQuery);

myQuery.RowLimit = 2000;

myQuery.ViewAttributes = "Scope='RecursiveAll'";



   foreach (SPListItem item in myItemcoll)



    Console.WriteLine("Item title:{0}", item["Title"]);

     Console.WriteLine(" Clinent : {0}", item["Client"]);


   myQuery.ListItemCollectionPosition = stateCol.ListItemCo

View Complete Post

More Related Resource Links

Type in first few characters to select items in a large list quicker

is there a way that you can type in the first few characters of an item in a dropdown box eg if you type ‘rad’ in the dropdown box it will take you to the first item starting with ‘rad’.

Is it possible that you could type in rad to get you to radiator for example?

MOSS 2007 This list or library contains a large number of items.


I have a library showing "This list or library contains a large number of items.".

The library contains only 1300 items.


1. Would the performance, e.g., upload files/change item properties, be affected?

2. Any way I can better organize the items?

3. I kown we can create folders in a library, how can I create subfolder? Or subfolder refers to Content Type?

4. Would create content type improves performance?


Many thanks.

Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).

Get pixel format, raw format, property id list and property items image in VB.net - C#.net.

n this simple article you will learn that how we can get pixel format, raw format, property id list and property items image in VB and C#.net.

Get Pixel Format:

Image consists of pixels to get the format of the pixel we have a property named pixel format. This property returns an enumeration of pixel format. This enumeration tells the pixel format.

To demonstrate make a window application. Drag one button and a picture box on form.

Now write the following code on Button click event:

Way of adding items in Drop Down List or List Box using Javascript

The article Way of adding items in Drop Down List or List Box using Javascript was added by raja.s on Sunday, June 06, 2010.

Hi,script type="text/javascript"> function AddItem(Text,Value) { // Create an Option object var opt = document.createElement("option"); // Add an Option object to Drop Down/List Box document.getElementById("DropDownList"

How to Customize the Add Comment 'Items on this list require content approval...' notification in


WSS 3.0:

If content approval is turned on, the Add Comment section displays a fairly ugly notification. Is there any way I can customize that section through e.g. CSS or SPDesigner?

I'd like to change at least the text, and preferably the yellow exclamation image, and also the background if possible.

Add Items to List with BDC Column via Web Services

I really hope this is possible.  I am trying to add items to a list that have a BDC column as one of the fields.  Here is the code I am using in the Batch

batchElement.InnerXml = "<Method ID='1' Cmd='New'>" +  
"<Field Name='Title'>Hello World</Field>" +  
"<Field Name='bdc'>BDCIdentifier</Field>&

Display tooltip for Sharepoint list items


Hi All,

I am using MOSS 2007 and my requirement is to show tooltip when I hover the mouse over the title column for each item. I am planning on storing the tooltip string for each listitem in a seperate column. Is there a way to do it. I am sure there is. Any help is greatly appreciated.

Thanks in advance!




Delete list items en masse?

Is there a way to delete list items en masse from a SP list?  I am on MOSS 2007.  In order to use a particular site as a site template I had to save with content and I don't want the content.

Video: Large List Support in SharePoint 2010

SharePoint 2010 has support for very large lists of up to 50 million items. With this expanded list size comes the ability to throttle and control how much data is returned to the user and prevent large queries from compromising the SharePoint farm. (Length: 15:36)

Filter items with a date column with parameters start date and end date on a sharepoint list?

If I have alist with a view that has the columns Title, Status and Status Date and the view has some items. How Can I add a filter with two parameters, start date and end date, to only show records with status date equal to or greater than parameter start date and status date is less than or equal to parameter end date? This is a sharepoint online site and I can't create and deploy custom code, can use SPD though. Do I need to use SPD or is this something I can do in the list settings? Thanks in advance.   Edit: I had a look here http://www.endusersharepoint.com/2009/09/29/sharepoint-date-filter-filtering-a-list-by-greater-than-or-equal-to-date/ but I don't have the Date Filter web part.

Remove items from a list literally not working as needed

This is why SharePoint drives me insane.  Everything I have been able to find on the web says I *can* programmatically remove list items from a list, all I have to do is a declining loop.  I have even copied verbatium several code examples found in this forum and on the web and every last one of them gives me a "Collection was modified; enumeration operation may not execute." error in the Event log.  This is a C# Windows Form Application we want to use to remove a common announcement from any announcement list in our entire site (top down).  We can *add* it to every announcement list without issue (seperate code).  Can anyone point out to us the error in our code below? using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using Microsoft.SharePoint; using System.Text; using System.Reflection; using System.IO; using System.Diagnostics; using System.Xml; namespace RemoveAnnouncement { public partial class RAForm : Form { public RAForm() { InitializeComponent(); } private void removeAnnouncment_Click(object sender, EventArgs e) { const string a = "Application"; try { if (tlsURL.Text.ToString() == "http://" || tlsURL.Text.ToString() == &qu

External List - Access Selected Items

Hello, The situation;- An external list in SP 2010 from SQL A custom ribbon/button that calls via JS a Dialog box(Application page) and passes the selected items IDs Some code behind to process items after confirmation from user. Question is how to access the selected items in the code behind. As far as I can tell the JS 'getselecteditems' only returns the list ID, which in the case of a standard list is fine, but with an External list returns something like '_B00234' - how do I use this or how to return a more meaningfull ID? (I would rather work in my confort zone VB/C# than JS to process items) casey

how to change the permissions list items using the workflow?

How to change the permissions list items using the workflow? Or how to instull SPDActivities on sharepoint 2010?

Get related item id in task list to display all task items related to this item

this is my scenario i have a document library with customized workflow in this workflow i have 6 collect data from user all of them have description feild i need when user display any item in library to view all of its description feilds related to this document as its meta data   sooo any idea

Get all items form List using JavaScript.

Hi! I'm develop for SharePoint 2010 and I have a ribbon button with CommandAction code like this:     function demoCallback(dialogResult, returnValue) { if (dialogResult == SP.UI.DialogResult.OK) { SP.UI.Notify.addNotification(returnValue); SP.UI.ModalDialog.RefreshPage(SP.UI.DialogResult.OK); } } var ctx = SP.ClientContext.get_current(); var items = SP.ListOperation.Selection.getSelectedItems(ctx); if (CountDictionary(items)==0) { var selectList = SP.ListOperation.Selection.getSelectedList(); //var currentList = currentWeb.get_lists().getById(selectList); alert(selectList); } var myItems = ''; var myFolders = ''; var k; for (k in items) { if (items[k].fsObjType == 0) myItems += '|' + items[k].id; if (items[k].fsObjType == 1) myFolders += '|' + items[k].id; } var options = { url: SP.Utilities.UrlBuilder.urlCombine(ctx.get_url(), '_layouts/MetaVis.Classifier2010/Classify.aspx') + '?items=' + myItems + '&amp;folders=' + myFolders + '&amp;List=' + SP.ListOperation.Selection.getSelectedList(), args: m
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

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