Search multiple lists

Question

I want to search through my lists. And show it on a repeater control. On my dropdown i got 3 options, (All, List1 and List2). But my If statement wont work. The else is working fine, but it hangs when i click on "All". Any suggestions? My code below.

        using (SPSite site = new SPSite("http://knowitintranet:9797/sites/News"))
        {
            SPWeb web = SPContext.Current.Web;

            if (DropDownListNewsFeed.SelectedItem.Value == "All")
            {
                SPSiteDataQuery query = new SPSiteDataQuery();
                    query.Lists = "<Lists " +
                                  "ServerTemplate=\"10000\"" +
                                  "ServerTemplate=\"10001\"" +
                                  "ServerTemplate=\"10002\">" +
                                  "</Lists>";

                query.Query = string.Format("<OrderBy><FieldRef Name='Modified' Ascending='FALSE'></FieldRef></OrderBy>");
                query.Webs = "<Webs Scope=\"SiteCollection\" />";

                query.RowLimit = 10;

                DataTable dataTable = web.GetSiteData(query);

                RepeaterNewsFeed.DataSource = dataTable;

                RepeaterNewsFeed.DataBind();
            }
            else
            {
                SPList list = web.Lists.TryGetList(DropDownListNewsFeed.SelectedItem.Value);

                SPQuery query = new SPQuery();
                query.Query = "<OrderBy><FieldRef Name='Modified' Ascending='FALSE' /></OrderBy>";
                query.RowLimit = 10;

                SPListItemCollection items = list.GetItems(query);

                RepeaterNewsFeed.DataSource = items;
                RepeaterNewsFeed.DataBind();
            }
        }

Answer 1

I don't see anything wrong with your code, but you should really check to see if this works..

What you get from web.Lists.TryGetList("Staff News").ID is a guid wrapped in {} like {Some Guid} eg. {700de2ad-9bde-432b-b7a7-11fdc5168c4b} So if you can take these Guids and strip the curly braces out before assigning them inside the xml for "<List ID=" + web.Lists.TryGetList("Staff News").ID + " />". As this can cause problems with caml queries.

Just add .ToString() to the end as shown:

"<List ID=" + web.Lists.TryGetList("Staff News").ID.ToString()" />