Instructor
Notes |
|
Cross list queries
require the use of the new SPSiteDataQuery class. When used within a custom
Web Part, this class allows you to prepare and execute a query that returns
an ADO.NET DataTable object. Before executing the query, you specify the
criteria for what lists or document libraries you want to query. The query in
the slide above is run against all document libraries because it specifies a
ServerTemplate of 101. You can also specify the fields to be returned as well
as filtering and ordering information similar to what you would add to WHERE
clauses and ORDER BY clauses in a SQL query. |