Multiple Lists from multiple sites and display in one list..

Question

Hi All I have one site collection. Site collection has multiple websites and each and every website has one list. So 3 lists from 3 different websites. Finally i want to display these 3 lists in one List at TopLevelSite(SiteColletion) Home page..... Is there any way to do like this...Please tell me... Regards k. Mahesh.

Mahesh Babu · Answer

Hi All By using sharepoint Designer we can get the data from different lists and disply in one list...By using Linked Data Source we can do this... I am giving URL for this.... http://www.codeproject.com/Articles/194252/How-to-Link-Two-Lists-and-Create-a-Combined-Ciew-i

Nitesh Luharuka · Answer

Thanks for posting the answer :)

Nitesh Luharuka · Answer

Glad you found it. Woulkd be good if you can share the solution here so that other memebers can be benefitted here :)

Mahesh Babu · Answer

Thanks Nitesh for your reply... It looks like getting data from one list...but i want getting data from multiple list into one list..any way i got the answer.. thanks for your support and your effort.... Regards k. Mahesh.

Nitesh Luharuka · Answer

Hi Mahesh Check this ... http://www.c-sharpcorner.com/uploadfile/anavijai/how-to-createupdatedelete-sharepoint-2010-list-items-using-client-object-model/

Nitesh Luharuka · Answer

Hi Mahesh Sure. Getting data from a list will not take much time. Thanks Nitesh.

Mahesh Babu · Answer

Hi Nitesh Can you provide sample code to get the data in one list... Regards k.Mahesh

Nitesh Luharuka · Answer

You will need to write a custom Web part to do this. Are the schema of these 3 lists are same?