开发者

How to convert a FullTextSqlQuery result to an SPListItem?

I though the following code would work but every time I look at file.Item; it is null. Should I be doing something different?

Microsoft.Office.Server.Search.Query.FullTextSqlQuery query = new Microsoft.Office.Server.Search.Query.FullTextSqlQuery(siteCollection);
query.QueryText = "SELECT Title, Path, Description, Write, Rank, Size from s开发者_如何学运维cope() where \"scope\" = 'SocialNetworking'";
query.ResultTypes = Microsoft.Office.Server.Search.Query.ResultType.RelevantResults;
//query.RowLimit = Int32.MaxValue;
query.TrimDuplicates = true;
query.EnableStemming = false;
query.IgnoreAllNoiseQuery = true;
query.KeywordInclusion = Microsoft.Office.Server.Search.Query.KeywordInclusion.AllKeywords;
query.Timeout = 0x2710;
query.HighlightedSentenceCount = 3;
query.SiteContext = new Uri(siteCollection.Url);
query.AuthenticationType = Microsoft.Office.Server.Search.Query.QueryAuthenticationType.NtAuthenticatedQuery;
Microsoft.Office.Server.Search.Query.ResultTableCollection queryResults = query.Execute();
Microsoft.Office.Server.Search.Query.ResultTable queryResultsTable = queryResults[Microsoft.Office.Server.Search.Query.ResultType.RelevantResults];
DataTable queryDataTable = new DataTable();
queryDataTable.Load(queryResultsTable, LoadOption.OverwriteChanges);
foreach (DataRow dr in queryDataTable.Rows)
{
    //if (dr["ContentType"].ToString() == "Item")
    //{
        using (SPSite lookupSite = new SPSite(dr["Path"].ToString()))
        {
            using (SPWeb web = lookupSite.OpenWeb())
            {
                SPFile file = web.GetFile(dr["Path"].ToString());
                SPListItem li = file.Item;
            }
        }
    //}

}


If you know it is an item try SPWeb.GetListItem

http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spweb.getlistitem.aspx

The file might also not exist, check SPFile.Exists before using any of SPFile's properties

http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfile.exists.aspx

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜