提取不同網站下的列表內容

       多話不說了,還是來點實在的,以下代碼實現的是將大網站下的幾個小網站提取出來,並顯示在一個GridView中,前台代碼就省了.

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using Microsoft.SharePoint.Utilities;
using System.Reflection;

public partial class Controls_NewHref : System.Web.UI.UserControl
...{
    private SPSite site;
    private SPWeb web;
    private SPList list;
    //private SPFolder folder;
    protected DataTable dt;
    protected string[] listUrl;
    protected string viewName;
    protected string[] webUrl;
    protected string[] itemName;
    protected DataView dv;
    int m = 1;

    protected void Page_Load(object sender, EventArgs e)
    ...{
        listUrl = new string[] ...{ "Lists/List7/", "Lists/List1/" };
        viewName = "ViewAllContent";
        webUrl = new string[] ...{ "", "RunInfo/" };
        itemName = new string[] ...{ "新聞標題" ,"會議名稱"};

        GridView1.Attributes.Add("class", "table");
        dt = new DataTable();
        dt.Columns.Add("ID", System.Type.GetType("System.Int32"));
        dt.Columns.Add("Title", System.Type.GetType("System.String"));
        dt.Columns.Add("URL", System.Type.GetType("System.String"));
        dt.Columns.Add("CreateTime", System.Type.GetType("System.DateTime"));
        if (!IsPostBack)
        ...{
            MakeTable();
            BindGridView();
        }
    }

    private void BindGridView()
    ...{
        GridView1.DataSource = dv;
        GridView1.DataBind();
    }

    private void MakeTable()
    ...{
        dt.Rows.Clear();
        try
        ...{

            for (int i = 0; i < listUrl.Length; i++)
            ...{
                site = new SPSite("http://" + Request.Url.Host + "/" + webUrl[i]);
                web = site.OpenWeb();
                list = web.GetList(webUrl[i] + listUrl[i]);
                SPView view = list.Views[viewName];
                SPQuery q = new SPQuery(view);
                SPListItemCollection items = list.GetItems(q);
                for (int j = 0; j < items.Count; j++)
                ...{
                    dt.Rows.Add(m,items[j][itemName[i]], "http://" + Request.Url.Host + "/" + webUrl[i] + listUrl[i] + "DispForm.aspx?ID=" + items[j].ID,items[j]["建立時間"]);
                    m++;
                }
            }

            dv = new DataView(dt);
            dv.Sort = " CreateTime ASC";
            dv.RowFilter = " ID <= 4";
        }
        catch (Exception ex)
        ...{
            Response.Write(ex.Message);
        }
    }
}