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


Post New Web Links

Combining lists from multiple sites into SPGridview

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

I have one main SharePoint site which has 5 child sites. Each child site represents a different department. On each of these sites there is a list called "ActionPlans". These lists all have the same name and the same number of columns. I need to somehow combine the 5 "ActionPlans" from the child sites into one on the main page.

I was able to loop through the SharePoint object and pull out one list, populate a datatable and display it in the SPGridview. I am having problems looping through the other sites and combining all lists.

Please help, Ninel




View Complete Post


More Related Resource Links

MOSS 2007 - Propagate changes to multiple sites and lists

  
We use MOSS 2007 for doc mngmt and maintain individual sites containing lists and libraries for each of our 90+ projects.  All sites are created from a site template and we wish to keep them all identical.  How should I push out changes and updates as business requirements change?  In other words, if we change/update the template, how can I make all the sites and lists look the same?

How to combine multiple task lists on multiple sites into single task list which then connects to Ou

  

Hi,

I'm hoping someone can provide some insight into a problem I'm having.

 

I have been tasked with trying to find a way to create multiple sites within the same site collection with a standard Task list in each site.  Now, I'd like to combine each of those task lists into one single task list viewable by the managers.  I know I can create a dataview, however I haven't been able to get that view into Outlook using the "Connect to Outlook" option in the Actions Menu of a task list.

 

Is there a way this can be done?


Any help is appreciated.



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).

Forms based users being prompted for windows authentication login for My Sites photos in user lists

  
Here's an issue I didn't see coming for our forms based authentication users. 

We have a web application extended to an external url to handle forms based authentication for users outside of our domain. Our setup looks like this...

Internal Users/Windows Authentication - moss.domain.com
External Users/Forms Based - mossext.domain.com
My Site for Internal Users - mysites.domain.com

When our forms based users are accessing user lists, or discussion pages that display user pictures, they are getting a windows authentication login for our internal users (mysites.domain.com) who have populated their my site with personal photo.

How do we fix this? 

Combining data from 2 lists, then summing a field

  

I have 2 lists, one is a contact list (client, client title, address, etc.), the other is a list of meetings with these clients (client name, type of meeting, date, etc.).  The 2nd list has multiple entries for the same client.  I am trying to create a report that combines the data in these lists and displays them like this:

Client--Client Title--MeetingType1--MeetingType2

ClientA--President--1--3

ClientB--CEO--2--1

 

In addition to combining the list data, I also need to break up the Type of Meeting field and sum the number of different types of meetings for each client.  I added the 2 lists to a linked source, then inserted the data into a DVWP adding data from the 2nd list as a joined subview.

 

I tried this: xsl:value-of select="count(/dsQueryResponse/Rows/Row[@TypeOfMeeting = 'MeetingType1'])" but it just returns 0.  I'm not sure if that's the correct method though as I think it will return a count of ALL the rows, not the current row.  Any ideas would be appreciated!


Quick Note: Accessing Multiple SharePoint 2010 Lists by Using LINQ

  
In this exercise, you develop and deploy a visual Web Part that reads data from three lists by using LINQ queries and displays the results in a grid view control.

Connect multiple lists

  
Hi, I have a list "List1" with column let's say "A". I have 4 more lists List2,List3,List4,List5 with different columns. Once an item is created in List1, another item will be created in all the other lists. My requirement is to connect all these lists some how may be I can use column "A" from List 1. I know look up column works but I guess it is only one way. I need to be able to navigate from one list to another ex. If I use look up column, then I can navigate only one way from List1 to List2. I need to also navigate from List2 item to List1item. Please let me know a possible solution. Thanks in advance. I am using MOSS 2007 standard edition.

Connect multiple lists

  
Hi, I have a list "List1" with column let's say "A". I have 4 more lists List2,List3,List4,List5 with different columns. Once an item is created in List1, another item will be created in all the other lists. My requirement is to connect all these lists some how may be I can use column "A" from List 1. I know look up column works but I guess it is only one way. I need to be able to navigate from one list to another ex. If I use look up column, then I can navigate only one way from List1 to List2. I need to also navigate from List2 item to List1item. Please let me know a possible solution. Thanks in advance.   I am using MOSS 2007 standard edition.

Report on Sites, Lists and Libraries with Unique Permissions

  
I would like to get a report on Sites, Pages, Lists, Libraries, Items and Documents under a Site Collection having Unique Permissions. What is the best way to accomplish that ?

search on multiple lists

  
Team, I have a situation where i have to do a search on multiple lists at once. List A - Field A, Field B List A - Field A, Field C List A - Field A, Field D When a user searches by Field A i want to pull all records from all lists. How do i present it after u have done the search. What web parts should i use? Is is possible to search on multiple lists. How to do it through designer? Do i need to a roll up view and search on it. If its possible.. Should i do join of lists and try to filter it based on FIELD A? Can we filter on joined lists? Any ideas on this .... Thanks a lot in advance.      

Posting blog entries or announcements to multiple sites

  

I am in the process of mapping out our new sharepoint farm. In order to structure this properly I would like to be able to post an entry either as a blog or an annoucment to more than one site at the same time. An example would be a company announcement on an internal staff site as well as a team site with our consultants. Is this at all possible in any way? Or would these need to be posted in each place individually.

thanks!


Can not see another WSS3.0 sites lists in SPD Data Source Library

  
I am editing a WSS3.0 (not MOSS) site in Sharepoint Designer and I am trying to display items from lists in another WSS3.0 website.  I have gone through the "Connect to another library..." steps on the "Data Source Library" tab and SPD does show entries in the "XML Files" tree but does not show any entries (or the headings) for "Sharepoint Lists" or "Sharepoint Libraries".  Is this a limitation of WSS3.0, is this not possible or am I trying to do this the wrong way?  I am basically trying to pull annoucments / diary entries from one site to other sites.

Many thanks in advance

Jonathan

Is it possible for a sharepoint VIEW to aggregate multiple TASK LISTS?

  

I have a few TASK LISTS, each with identical structure, that can't be combined initially, based on the groups that control the task lists.  ALL Task Lists reside on the same SITE.  I would like to find a way to "UNION JOIN" multiple task lists under a single Tasks List VIEW, if that can be done.  Alternately, is there a WEB PART that can do this?

Is there a way to merge multiple similar-structured task lists within a single site - and if so, how would it be done?


How to assign multiple IP's to be assigned to the different WSS sites in the single share point ins

  

Hi guys,

 

This was one of the typical queries asked by my client which has to be answered to kick start the project based on the budget.


What is the possibility of WSS accepting 2 IP’s mapped for 2 web sites in a single share point server instance.

 

I don't have good share point administration knowledge to answer the question.

 

Guys please help me its bit urgent.... !!!

 

 


Thanks keshav,Share point Developer

SharePoint tool - sites, subsites,lists,listitems creation

  

Hi All

Recently I am investigating on a tool which can do the following-

1) helps in creating multiple number of sites, subsites, lists and list items

without having me to manually do all those actions.

 

 

This is because I am in the process of building a test environment for SharePoint which needs to have 100GB of data dispersed among different sites and subsites which turns out to be really tedious for me to create all these manually and fill the data

Does anyone have any idea of existence of such a tool.

 

Can some one help me with ideas to achieve this

 

Thanks

Carol

 


SharePoint tool - update metadata, permissions of sites, lists,listitems

  

Hi All,

 

I am setting a SharePoint test environment with loads of data.

I could some how manage to use tools to populate data in Sharepoint.

But I couldn't find a way to

1) Modify the sites/lists/listitems in an easy way without me havng to manually perform that

As I had 200GB of data with some thousands of sites and lists, I am not able to manage this data manually.

For my testing to run smoothly, I need to be able to add/delete/modify the metadata, permissions of many objects easily

 

Can someone suggest me  a tool which allows me to do this kind of functionality

 

Thanks

Carol


How to implement: Multiple *independent* sites on same server

  

Say I have three sites: http://my-server/active-development, http://my-server/beta-release and http://my-server/official-release that essentially 3 different version of the same code base and I need them to function independently w.r.t. to session state. As in, when I log into one site (say http://my-server/active-development), the session ID cookie generated for that site should not be present when I open another browser window (of same type: say IE) to another site (say http://my-server/official-release). Unfortunately, that won't happen. Its because when the ASP.NET SessionIDManager generates the ASP.NET_SessionID cookie, it always specifies Path = "/".

private static HttpCookie System.Web.SessionState.SessionIDManager.CreateSessionCookie(
Categories: 
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