public static DataTable ExecuteQuery(string SiteCollection, string QueryString) { SPSite col = new SPSite(SiteCollection); ServerContext ctx = ServerContext.GetContext(col); FullTextSqlQuery ftq = new FullTextSqlQuery(ctx); ftq.ResultTypes = ResultType.RelevantResults; ftq.EnableStemming = true; ftq.TrimDuplicates = true; ftq.QueryText = QueryString; ResultTableCollection allresults = ftq.Execute(); ResultTable relevant = allresults[ResultType.RelevantResults]; DataTable dt = null; if (relevant.RowCount > 0) { dt = new DataTable("Search Result"); dt.Columns.Add("Title"); dt.Columns.Add("URL"); while (relevant.Read()) { DataRow row = dt.NewRow(); row[0] = relevant.GetString(0); row[1] = relevant.GetString(1); dt.Rows.Add(row); } } return(dt); }
private void btnSearch_Click(object sender, EventArgs e) { SPSite col = new SPSite(txtSC.Text); ServerContext ctx = ServerContext.GetContext(col); DropDownHelper <Scope> dds = (DropDownHelper <Scope>)cbScope.SelectedItem; string ScopeName = dds.Item.Name; string query = "Select title, url FROM Scope() where \"Scope\" = '" + ScopeName + "' AND Freetext('" + txtPhrase.Text + " ')"; FullTextSqlQuery ftq = new FullTextSqlQuery(ctx); ftq.ResultTypes = ResultType.RelevantResults; ftq.EnableStemming = true; ftq.TrimDuplicates = true; ftq.QueryText = query; ResultTableCollection allresults = ftq.Execute(); ResultTable relevant = allresults[ResultType.RelevantResults]; DataTable dt = null; if (relevant.RowCount > 0) { dt = new DataTable("Search Result"); dt.Columns.Add("Title"); dt.Columns.Add("URL"); while (relevant.Read()) { DataRow row = dt.NewRow(); row[0] = relevant.GetString(0); row[1] = relevant.GetString(1); dt.Rows.Add(row); } gvResult.DataSource = dt; gvResult.AutoResizeColumns(); } }
public string GetString(int index) { return(m_resultTable.GetString(index)); }