How to access List from Sub Site in SharePoint 2010

Question

I have created a Site Named Application Test. In this site i again Create a Sub site Named Sub Application I add in site url "http://SP2010:2222/" in Visual Studio Project Project Scope is Site Now i when i try to access the List(TestList) From Sub site(Sub Application) it give error List Does not Exist. Following Code to Access the List(TestList):

using (SPSite sites = new SPSite(SPContext.Current.Site.Url))
    {
        using (SPWeb web = sites.OpenWeb())
        {
          SPList CurrentList = web.Lists["TestList"]; // Error comes here
        }
    }

anybody have solution?

Answer 1

You first have to get the SPWeb object related to the sub site.

Something like using(SPWeb web = sites.OpenWeb("subsiteurl")) may help.

Your code is actually trying to get the TestList at the root web.

Answer 2

According to your question i got the below things, 1) You have created a site "Application Test". In this site you created anothe site "SubApplication". No my question is "Application Test" site url is "http://sp2010:2222"?

2) If you are running the code in "Application Test" site level, then the thing is when ever "SPWeb web = sites.OpenWeb()" code it opens the Root web in the site. To open the site "Sub Application" you have to write "SPWeb web = sites.OpenWeb('[SubApplicationURL]')

3) Test list is in "ApplicationTest" site or "Sub Application"?

4) If it is in "ApplicationTest", and your code is running in "SubApplication" level, you have to write the code to access the parent web and then need to acces the list in that site.

5) Permissions are also concerns to access the list. Run the code with elevated previlizes will help to not to get permission issues.

Answer 3

code you have written will try to find list from current web only so try this code:

string webURL = "/<webname>";

using (SPWeb web = site.OpenWeb(webURL))
{
    // and as per best practices you should use web.Lists.TryGetList(ListName);
    // It will increase performance.
} 

Answer 4

Try this, this should work. I have tested this code, myself:

string _siteUrl = SPContext.Current.Site.Url + "/mysubsite";
using (SPSite siteColl = new SPSite(_siteUrl))
{
    using (SPWeb web = siteColl.OpenWeb())
    {
       // SPList CurrentList = web.Lists["TestList"]; // This will not work
       // web.Lists[] must have a GUID, or use web.GetList("/Lists/MyList");
        Guid guid = new Guid("XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX");
        SPList list = web.Lists[guid];
        SPQuery query = new SPQuery();
        query.Query = "<Where><Eq><FieldRef Name='ID'/><Value Type='Number'>1</Value></Eq></Where>";
        SPListItemCollection listCol = list.GetItems(query);
        if (listCol != null)
        {
            Response.Write(listCol[0]["Title"].ToString());
        }
    }
}

Answer 5

A new method ‘TryGetList’ is introduced in SharePoint 2010 to check whether the list exists or not.

Try the following code:

SPSecurity.RunWithElevatedPrivileges(() =>
{
    using (SPSite oSite = new SPSite(SPContext.Current.Web.Url))
        using (SPWeb oWeb = oSite.OpenWeb())
        {
            SPList myList = oWeb.Lists.TryGetList(listName);

            if (myList != null)
            {
            //Stmts
            }   
        }
});