SPList represents a list on a Microsoft SharePoint Foundation Web site.

learn more… | top users | synonyms

15
votes
3answers
26k views

Fastest way to delete all items with C# [duplicate]

Possible Duplicate: Deleting all the items from a large list in SharePoint What is the fastest way to delete all items in a list programmatically? I do not want to remove list and re-create it,...
9
votes
3answers
14k views

How to change internal field name(column name) of sharepoint list?

Can we direct change it from sql database? if yes then how? or any other solution?
9
votes
2answers
232 views

Efficient way to retrieve all list items

I am retrieving all items from list containing around 4000 items. But it seems to take longer time to fetch all items which is ~15 to ~22 seconds. Is there any best way to fetch all items from list in ...
7
votes
1answer
234 views

Efficiently get a collection of all users following a list in SP2013 using CSOM or SSOM?

Does anyone know if there is a way to leverage the SocialFollowingManager() class or the SPList() class to efficiently get a collection of all of the users that follow a specific List? I thought ...
6
votes
2answers
2k views

Is it possible to update a list's icon?

Is there a way to update a list's icon? I was looking to use SPList.ImageUrl, but this is read only. The problem is that I've updated a list definition's icon; unfortunately there several list ...
6
votes
2answers
2k views

How to set list alert using JavaScript in SharePoint 2010?

I need to set a list alert for current (logged in) user using JavaScript. Code: var currentcontext = new SP.ClientContext.get_current(); var currentweb = currentcontext.get_web(); ...
6
votes
1answer
6k views

How to get attachment URL programmatically From SharePoint list item?

How to get attachment full URL programmatically From SharePoint list item? Explanation: I have adding new item with attachment. Now I have to bind that attachment link to grid. When click on that ...
5
votes
5answers
4k views

How do you hide a hidden list?

If you set the SPList.Hidden property to true, the list isn't shown in the Quick Launch, All Site Content, Lookup lists, etc. However, it is still possible to navigate to the list by typing in the ...
5
votes
4answers
7k views

How to bind dropdownlist from splist column with choice field using C#

Here is my list with name "Department" and name,mobile these are my column name and i want to add to my dropdown list only mobile number(column)plz help me ... SPSite site = new SPSite("http://...
5
votes
2answers
599 views

SPQuery returning different before and after using RunWithElevatedPrivileges method

I am having a huge problem here. I am executing a query looking for a SPListItem, when I execute this query with user identity it works well, retuning the fields "Author" and "Editor" that I need. ...
5
votes
0answers
294 views

SPGridView - How to make it look & feel like built-in SP grid

In C# code, I'm working with the SPGridView control to display list items from a list of type SPDocumentLibrary. It binds fine, but it looks totally plain and has basically no features. I would like ...
4
votes
1answer
378 views

Update SPList.TemplateFeatureId

I need to update the TemplateFeatureId for a couple of lists in our SharePoint 2010 installation. The current TemplateFeatureId points to a feature that is no longer installed in the farm. Both SPList....
4
votes
4answers
1k views

Programmatically adding SharePoint Lists to external SQL database

I need to export a SharePoint list to an external SQL database. My initial idea is to open the list as a datatable and bulk update. I created a console app I can run anytime I need to sync the data. ...
4
votes
4answers
350 views

Does SPList.ItemCount equal SPList.Folders.Count plus SPList.Items.Count?

I'm trying to do some inventorying of SharePoint 2007 content and have been scratching my head over this for a while now. I understand from MSDN that SPList.ItemCount counts all folders and items ...
3
votes
4answers
677 views

SharePoint List / Library property bag

I'm working with sharepoint 2007 and i have a question, does a sharepoint library / list has something like property bag, where i could store some properties for the list? Like a SPWeb object. Or ...
3
votes
1answer
113 views

CalculatedColumn or SPServices with jQuery in SP 2010 List

I need to create a calculated column -say ResCount - based on another datetimefield field, ie,assuming if mydt is my datetimefield, from this field, I need to extract month part and based on month ...
3
votes
1answer
2k views

List.AddItem() and List.Item.Add() … why two methods for same purpose

I searched and got the difference between List.AddItem() and List.Item.Add(). SPList.Add() vs SPList.AddItem() SharePoint 2010 Now the query which comes to my mind is that why Sharepoint has two ...
3
votes
3answers
1k views

Enable versioning on SPList programmatically

I might be missing something obvious, but I am trying to enable version history on a regular task list programmatically. It is definitely possible from the UI, but how can this be achieved in code? I ...
3
votes
2answers
3k views

Using PowerShell how do I change the column ordering for a SharePoint List

Been trying to search for the answer to this, what I need to do is re-order the fields of a SharePoint list and propagate that change down to 300+ sites (should have used a content type, but oh well) ...
3
votes
1answer
491 views

ProcessBatchData - update a currency field

I'm using SPWeb.ProcessBatchData to update list items, and I'm having a problem with currency field. When I insert something like this <SetVar Name=\"urn:schemas-microsoft-com:office:office#...
3
votes
1answer
82 views

Create custom list in sharepoint 2007 using JQuery

I need to create a custom list in Sharepoint 2007 using JQuery (only!). I'm using Sharepoint 2007. Is there any way to do it?
2
votes
2answers
1k views

How to find a file with name = X in a SPList

Looking for recommendations. Have a file in a document library with name x.txt. In a workflow code behind, I need to get the file to read its contents. What is the best/most efficient way to do ...
2
votes
2answers
9k views

Add New Item Link not appear in Sharepoint List

Add New Item Link not appear in Sharepoint List. I logging with admin account(having full control). How to resolve ?
2
votes
2answers
457 views

Avoid SharePoint 2013 List View Threshold

In client environment we cannot let our hands on SharePoint list threshold. in such case rest api is not usable, there for i moved to the approach of content iterator and found that it also have a ...
2
votes
1answer
3k views

How to Set SPQuery.RowLimit to get all items?

I'm using my SPList View to get the html code of extracted items by an SPQuery over the listview SPList myList = mySite.RootWeb.Lists.GetByInternalName("ListINStr"); SPView oView = myList.Views["...
2
votes
3answers
131 views

web.GetList(“Lists/TestList”) throws FileNotFound exception

I have the following code in my application. It is throwing FileNotFound exception at `web.GetList("Lists/TestList") This list exists and I am able to get the list from web.Lists.TryGetList("...
2
votes
1answer
131 views

Changed URL to pages, but still redirects to Pages?

I have an external website which needs to show URL in lowercase only. I don’t want to use URL Rewrite or any third party tool. Instead we decided to change the actual URL’s of the Pages Library. I’ve ...
2
votes
1answer
283 views

Will using a `SPList` object derived from a disposed `.OpenWeb()` cause errors?

Will using a SPList object derived from a disposed .OpenWeb() cause errors? SPList list = null; using (SPWeb web = SPContext.Current.Site.OpenWeb("/myweb")){ list = web.Lists["Awesome Name"]; } ...
2
votes
2answers
3k views

GetDataTable from SPListItemCollection

My question is regarding the use of DataTable vs ListItemCollection. Basically I have a small solution, where I have to loop through the items in the list to verify if the items already exists or not. ...
2
votes
2answers
362 views

Retrieving the highest value from list

My question is regarding retrieving a value from a sharepoint list. Basically I have a list with some data. One of the fields in the list is a text field with numbers. So what i want to do, i want to ...
2
votes
1answer
722 views

get hold of a list

$web gives me the title of the website $list is not giving me any and therefore item add/update i m doing is failing. What is wrong? The code works in dev area. btw, I am running with full rights on ...
2
votes
1answer
647 views

How to modify the existing list template file in SharePoint

I want to modify a list template which is already created in my site collection.Once I upload the list into the template gallery it becomes a .stp file.But how to modify this again? I am having a ...
2
votes
1answer
133 views

Get Checked out items in a document library

I have a document library which has 18000 items. When I go to the All Site Contents page, I see 18000 items against the document library name. But when I query the items in C# as foreach(SPListItem ...
2
votes
1answer
269 views

SPListDataValidationException in an event receiver on a task list with Overdue tasks

I have a task list called Finance Department Tasks on this task list i have created an item updating event receiver which checks if all fields in the task list are filled and then sets the task status ...
2
votes
2answers
328 views

Unable to set permission on list for multiple spgroup

I have a list to which I want to set permission to 2 site groups. Among them, one is contribute level and second is read. My code for assigning the permission to list is: private void ...
2
votes
1answer
1k views

SPField not visible on default view when SPList created programatically

I'm creating an SPList item programatically. Everything goes fine, I add a list, I add spfields to it. SPList list = (SPList)oWeb.Lists[listName]; SPField libraryNameField = new SPField(list.Fields,...
2
votes
2answers
145 views

Getting latest datetime from a splist

I have sharepoint list with data and one of the columns contains date ... how can i programmatically retrieve the latest date, the field is a Date And Time type?
2
votes
2answers
456 views

QueryThrottleMode in non-query operations?

I have a big List which I want to empty. Therefore I create a template from that list, delete the list and create a new list from the template I just saved before. I know there are other ...
2
votes
2answers
3k views

Sharepoint Designer SPList option “Hide from browser” in code?

When I hide the list using list.Hidden = true; It's hidden from the Quick Launch and it's also hidden from the Sharepoint Designer. I'm rather interested in a useful feature for lists in ...
2
votes
0answers
223 views

Is my Object Casting Model acceptable?

I'm creating a SharePoint application, and am trying some new things to create what amounts to an API for Data Access to maintain consistency and conventions. I haven't seen this before, and that ...
2
votes
1answer
303 views

Add content types programmatically into SPList takes too long

I've dozens of CTypes to add to an SPList programmatically (cause content types are provided by CTH) and each oSPList.ContentTypes.Add() takes almost 1sec. Is there any other approach ou code ...
1
vote
4answers
2k views

Get List by “InternalName”

I'm trying to use the SharePoint 2013 JavaScript Object Model to retrieve a List via an internal name equivalent. SPList doesn't have a Name or Internal Name property. It is referred to by the Title;...
1
vote
2answers
429 views

Why does SPList.GetItems(string fields[]) return more fields than specified?

I'm using SPList.GetItems(string fields[]) to obtain only specific item fields from a document library: SPListItemCollection items = list.GetItems("UniqueId", "Name"); However, iterating the items ...
1
vote
3answers
995 views

is this causing memory leaks?

I have a couple of utility functions that help with querying lists and wanted to see if they I wrote them would cause either memory leaks or cause the client code to try to access already disposed ...
1
vote
2answers
2k views

Add/Copy SPListItem object to Sharepoint List

explanation: I have fetched list items based on conditions. Like this. var query = from SPListItem oItem in splist.Items where Convert.ToDateTime(oItem["Status"])....
1
vote
2answers
303 views

How to create a custom SPList without saving it on the SPSite

I am trying to create a webpart which loads document information from a different application. I want this information loaded into a list which looks like a SharePoint list. I was able to create a ...
1
vote
2answers
419 views

View aggregations programmatically

I have a view in my list, I defined aggregations in my view: sum and average of several columns. Now I want to get programmatically the aggregations results. How can I get it?
1
vote
1answer
3k views

Share List between subsites of sharepoint2010

Anyone know how can we share one subsites list to another subsite ? I want to allow all operations also and also want to put in read only mode in another subsite. Anyone have idea how can i do this ?
1
vote
1answer
2k views

When to use List<SPList> vs SPListCollection?

If I have to grab numerous lists which I have the name, URL or Guid of, should I use web.Lists and return the entire SPListCollection or grab the specific ones I need via web.Lists[Guid] and place ...
1
vote
1answer
28 views

Unique constraint on multiple columns

I would like to be able to set a unique constraint on two columns to avoid entries like in the 4th record below (1234,B1) ColumnA ColumnB 1234 B1 1212 A1 3211 B1 1234 ...