遇到多个list联合查询的问题,where条件来自多个表
遇到多个list联合查询的问题,需要用CAML做到类似于SQL中的:
遇到多个list联合查询的问题,需要用CAML做到类似于SQL中的:
select A.*,A.CityID,B.CityNAME from tableA A left join tableB B on A.CityID=B.ID where tableA .Name=xxx or tableB.CityName=xxx or....
先说SPQuery 和SPSiteDataQuery的区别
MOSS 关于SPQuery 的用法,是关于列表的查询
SPWeb web = (new SPSite(" http://moss/sites/hello)).OpenWeb ();
SPList list = web.Lists["test"];
SPQuery query = new SPQuery();
query.Query = " 4 ";
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 = " 4 ";
query.Lists = "
";
query.Webs = " ";
query.ViewFields = "
";
DataTable dt = web.GetSiteData(query);
Console.WriteLine(dt.Rows.Count);
SPSiteDataQuery siteQuery = new SPSiteDataQuery();
siteQuery.Webs = "<Webs Scope=\"SiteCollection\" />";
siteQuery.Lists = string.Format("<Lists><List ID='{0}' /><List ID='{1}' /&g