SharePoint 2010 how to find the subsite name programmatically and refer the Parent site WebPart

Question

I have List created in the Parent Web and created a Visual WebPart to pull the data from the list and display. When I add the same WebPart in the SubSite pages the data is not populating to display. When I try the following condition:

String siteUrl = SPContext.Current.Web.ParentWeb.Url; //Featch the top site url

data is populating in the SubSites and not display in the Parent site.

How can I conditionally change the site url path for Parent site and Sub sites to refer the list created in Parent site.

Answer 1

You should get the current site collection rootweb url as below

String siteUrl = SPContext.Current.Site.RootWeb.Url;

Answer 2

i think you might be getting confused ;)

SPContext.Current.Web.ParentWeb.Url is fine if you do:

SPContext.Current.Web.RootWeb.Url 

root web is the web at the root level (top most level) of the site collection!

if its at root which i think your refering to??:

SPWeb web = SPContext.Current.Web.RootWeb

//you are now in the root parent spweb object
SPList list = web.Lists["MyCustomList"];
SPListItemCollection itemCol = list.Items;

foreach (SPListItem item in itemCol)
{
    //do what you want with each item
}

the above code would work if you were to put the webpart on any site or subsite as its refering to the root site of all sites and subsites.

if your not happy with the code above than you can use:

String siteUrl = SPContext.Current.Web.Site.Url; //Featch the top site url 

above also gets the root site url for that given sitecollection! eith use it as it is as it will give you the url or:

SPSite site = SPContext.Current.Web.Site; 
using(SPWeb web = site.OpenWeb())
{
   //you are now in the root parent spweb object
   SPList list = web.Lists["MyCustomList"];
   SPListItemCollection itemCol = list.Items;

   foreach (SPListItem item in itemCol)
   {
       //do what you want with each item
   }
}

Answer 3

To access the list in Parent site from the subiste we can check the based on the condition of current web url:

String siteUrl = SPContext.Current.Web.Url;  //Fetch the top site url                

//Fetch the top site url if it is any subsite 
if ( siteUrl.ToLower().Contains("/blog") )
{
     siteUrl = SPContext.Current.Web.ParentWeb.Url;
}