Sharepoint 2010 send data from custom webpart to another custom webpart

Question

I have 3 site collections : -site collection portal (http://xxx/SitePages/Home.aspx),

-site collection Spain (http://xxx/sites/spain/SitePages/Home.aspx)

-site collection China(http://xxxx/sites/china/SitePages/Home.aspx)

In site spain and china I have a custom web part, with same columns (example : code, Country,ReviewType, submittedDate, daysLeft), this is an example for spain,, same Webpart is in china too. I want to create in the portal a webpart that brings the same data from webpart china and spain with daysLeft = 2. like that I want to know if this scenario is feasable, and if yes, could you please give me an idea ? Thanks

Answer 1

I don't think it is possible (but of course I could be wrong because I have never faced similar problem before).

But if the webpart you are going to build is just for viewing data from both site collections, I think it is possible by using common Custom Visual Webpart functionality and ASP.NET code (hope what I think here is suitable to what you need), for example:

1. Add a DataGrid, ListView, Repeater, or whatever data controls you think suitable to your needs.
2. On the code behind, pull the data from both sites, do some processing if necessary, and bind them to your data control.
3. Add other necessary functionalities such as pagination and sorting.