MOSS 关于SPQuery 和SPSiteDataQuery的区别好用法！

MOSS 关于SPQuery 和SPSiteDataQuery的区别好用法！

              
　　　　　下面的代码是给在做ＭＯＳＳ开发的同行们的一些对象模型的学习，和自己的看法
　　　　MOSS 关于SPQuery 的用法，是关于列表的查询范围比较的小。。　
　　　　  SPWeb web = (new SPSite("http://moss/sites/hello")).OpenWeb();
                SPList list = web.Lists["test"];
                SPQuery query = new SPQuery();
                query.Query = "<Where><Contains><FieldRef Name='Title'/><Value Type='Text'>4</Value></Contains></Where>";
                SPListItemCollection items = list.GetItems(query);
                foreach(SPListItem item in items)
                    Console.WriteLine(item.DisplayName);
　　　　SPSiteDataQuery的是查询整个Site的范围比SPQuery大，我就不在这里罗嗦拉，大家看拉代码测试一下，就很明白拉 
                SPWeb web = (new SPSite("http://moss/sites/hello")).OpenWeb();
                SPSiteDataQuery query = new SPSiteDataQuery();
                query.Query = "<Where><Contains><FieldRef Name='Title'/><Value Type='Text'>4</Value></Contains></Where>";
                query.Lists = "<Lists BaseType='0' />";
                query.Webs = "<Webs Scope='Recursive' />";
                query.ViewFields = "<FieldRef Name='Title' /><ProjectProperty Name='Title' /><ListProperty Name='Title' />";
                DataTable dt = web.GetSiteData(query);
                Console.WriteLine(dt.Rows.Count);

 

 

 

/测试代码//

protected void btnSearch_Click(object sender, EventArgs e)
{
try
{

SPSecurity.RunWithElevatedPrivileges(delegate()
{
string query = ""+this.texName.Text+"";

SPSite site = new SPSite(@"http://wh/sites/oa");
site.AllowUnsafeUpdates = true;
SPWeb web = site.OpenWeb();
web.AllowUnsafeUpdates = true;
SPList list = web.Lists["文件查询"];
SPViewCollection views = list.Views;

StringCollection viewFields = new StringCollection();

for (int i = 0; i < list.DefaultView.ViewFields.Count; i++)
{
viewFields.Add(list.DefaultView.ViewFields[i]);

}

SPView view = null;
try
{
view = views["查询结果"];

}
catch
{
}
if (view == null)
{
view = views.Add("查询结果", viewFields, query, 10, true, false);

}
else
{
view.Query = query;
}
view.Update();

string url = list.DefaultViewUrl.Replace(list.DefaultViewUrl, view.Url);
this.Response.Redirect(url);
web.AllowUnsafeUpdates = false;
site.AllowUnsafeUpdates = false;


});
}
catch(Exception ex)
{
this.Response.Write(ex.Message);
}