如何从 sharepoint 的讨论区获取最新 10 条帖子？

Question

我正在尝试使用 SPQuery 从 sharepoint 的讨论区获取最新的 10 篇帖子。我需要阅读 [PostUrl] [Subject] [Body] [LastModifyDate]？

请有人帮帮我吗？

Answer 1

尝试使用下面的示例代码，它适用于我的环境。

        SPSite oSite = new SPSite("http://localhost/");
        SPWeb oWeb = oSite.OpenWeb();
        SPList oList = oWeb.Lists["DiscussionBoardList"];

        SPQuery qry = new SPQuery();
        qry.RowLimit = 10;
        qry.Query = "<OrderBy><FieldRef Name='Created' Ascending='False' /></OrderBy>";
        qry.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='Body' /><FieldRef Name='Modified' />";
        DataTable dt = oList.GetItems(qry).GetDataTable();

Answer 2

尝试使用下面的示例代码，它适用于我的环境。

     SPSite oSite = new SPSite("http://localhost/");
     SPWeb oWeb = oSite.OpenWeb();
     SPList oList = oWeb.Lists["DiscussionBoardList"];
     SPQuery qry = new SPQuery();
     qry.RowLimit = 10;
     qry.Query = "<OrderBy><FieldRef Name='Created' Ascending='False' /></OrderBy>";
     qry.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='Body' /><FieldRef Name='Modified' />";
     DataTable dt = oList.GetItems(qry).GetDataTable();