Thursday, 14 January 2016

SharePoint Keyword Query Code

Below the C# code to display the Search Result for a Query from Console Application.

Console Code to View the Search Results


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using System.Data;
using Microsoft.SharePoint;
using Microsoft.Office.Server.Search.Query;

namespace SearchConsoleApplication1
{
       class Program
       {
              static void Main(string[] args)
              {
                     using (SPSite siteCollection = new SPSite("http://w15-sp"))
                     {
                           KeywordQuery keywordQuery = new KeywordQuery(siteCollection);
                           keywordQuery.QueryText = "SharePoint";
                           keywordQuery.SortList.Add("Author", SortDirection.Ascending);
                           keywordQuery.SortList.Add("Size", SortDirection.Descending);

                           SearchExecutor searchExecutor = new SearchExecutor();
                           ResultTableCollection resultTableCollection = searchExecutor.ExecuteQuery(keywordQuery);
                           var resultTables = resultTableCollection.Filter("TableType", KnownTableTypes.RelevantResults);

                           var resultTable = resultTables.FirstOrDefault();

                           DataTable dataTable = resultTable.Table;
                DataTable workTable = dataTable;
                DataRow[] currentRows = workTable.Select(null, null, DataViewRowState.CurrentRows);

                    if (currentRows.Length < 1 )
                      Console.WriteLine("No Current Rows Found");
                    else
                    {
                        Console.WriteLine("Writing Column Names ");
                      foreach (DataColumn column in workTable.Columns)
                        Console.Write("\t{0}", column.ColumnName);

                      Console.WriteLine("\tRowState");
                      Console.WriteLine("Writing Rows values ");
                     /* foreach (DataRow row in currentRows)
                      {
                        foreach (DataColumn column in workTable.Columns)
                          Console.Write("\t{0}:", row[column]);

                        Console.WriteLine("\t::" + row.RowState);
                      }*/
                    }

Console.ReadLine();
                     }
              }
       }
}



References




No comments:

Post a Comment