Tuesday, December 28, 2010

Parser Error in sharepoint


Today I have faced parser error in SharePoint when someone has changed compat.browser file in
SharePoint designer.

After searching in Google, I found that some of file App_Browsers folder was corrupted. I have deleted file from folder and reset IIS. My site is working fine.





Saturday, December 4, 2010

SharePoint search using FullTextSqlQuery

//SharedServices2 refers to the Shared Service Provider servicing
ServerContext context = ServerContext.GetContext("SharedServices2");
FullTextSqlQuery qrySearch = new FullTextSqlQuery(context);
//Specifies the results set containing the main search results from
//the content index matching the search query.
qrySearch.ResultTypes = ResultType.RelevantResults;
//Sremming : expansion of searches to include plural forms and
//other word variations :-)
qrySearch.EnableStemming = true;
qrySearch.TrimDuplicates = false;
qrySearch.QueryText = "SELECT URL, Title, Size, Write, HitHighlightedSummary FROM SCOPE() where \"scope\"='NTFS Archive' And FREETEXT(*,'" + TextBox1.Text.Trim() +
"')";
ResultTableCollection results = qrySearch.Execute();
ResultTable resultTable = results[ResultType.RelevantResults];
// Data Table to Store Search Results
DataTable dtResults = new DataTable();
dtResults.Load(resultTable, LoadOption.OverwriteChanges);