Bind SearchService query results to a ASP.Net dataview control

Hi,

I am new to asp.net Wep application development.

I have executed a search to Livelink successfully using the SearchService EWS. I receive the results using the SingleSearchResponse method.

I would like to link/bind the the asp.net dataview control GridView(or any other appropriate control) to the results returned from my search to Livelink.

How do I do this?

I need to go through the results and make some changes and then display the results in a report format.

This is my code to setup and execute my query:

SearchService. SingleSearchRequest query = new SearchService. SingleSearchRequest ();

query.DataCollectionSpec = "\"LES Access Person Imaging\"" ;

query.QueryLanguage = "Livelink Search API V1" ; // use the Search API for queries

query.FirstResultToRetrieve = 1; // start retrieving results at Result #1

query.NumResultsToRetrieve = 100; // retrieve up to 100 search results

query.ResultOrderSpec = "sortByRegion=OTCreatedBy" ; // sort by the OTCreatedBy region

query.ResultSetSpec = "lookfor1=complexquery&where1=" + APInfo_APID + ":" + userApID + " AND " + APInfo_Account + ":" + userAcctNum;

query.ResultTransformationSpec = new string [] { APInfo_APID, APInfo_APFname, APInfo_APLname, APInfo_Account, APInfo_Entity, APInfo_Broker, APInfo_Year,

APInfo_January, APInfo_February, APInfo_March, APInfo_April, APInfo_May, APInfo_June, APInfo_July,

APInfo_August, APInfo_September, APInfo_October, APInfo_November, APInfo_December, "OTName" };

// Execute the search

SearchService. SingleSearchResponse results = ss.Search(ssOTAuth, query, "" );

Find more posts tagged with

Comments

John Thomas

Did you find any possible way to bind it with grid?

Mahesh_Pinnamaneni

we can probably use DataTable and bind it to Grid as something like this:

SingleSearchRequest qry = new SingleSearchRequest();

qry.DataCollectionSpec = "'LES Enterprise'"; // use the Enterprise search slice

qry.QueryLanguage = "Livelink Search API V1";

qry.FirstResultToRetrieve = 1; // start retrieving results at Result #1

qry.NumResultsToRetrieve = 50; // retrieve up to 5 search results

qry.ResultOrderSpec = "sortByRegion=OTCreatedBy"; // sort by the OTCreatedBy region

qry.ResultSetSpec = "where1=" + txtsearchqry.Text; // set the where clause of the query

qry.ResultTransformationSpec = new string[] { "OTName", "OTLocation", "OTObject" };

SingleSearchResponse results = searchClient.Search(ref searchAuth, qry, "");

SResultPage srp = results.Results;

SGraph[] sra = results.ResultAnalysis;

DataTable dt = new DataTable();

dt.Columns.Add("Name");

dt.Columns.Add("DataID");

if (srp != null)

{

SGraph[] items = srp.Item;

DataBagType[] types = srp.Type;

// Proceed if there was at least one search result

if (items != null && types != null && items.Length > 0)

{

int cnt =0;

foreach (SGraph sg in items)

{

string[] s = sg.N[0].S;

//Console.WriteLine("Name=" + s[1] + " DataID=" + s[2].Split('&')[0].Split('=')[1]);

dt.Rows.Add();

dt.Rows[cnt]["Name"] = s[1];

dt.Rows[cnt]["DataID"] = s[2].Split('&')[0].Split('=')[1] ;

cnt += 1;

}

GridView1.DataSource = dt;

GridView1.DataBind();

}

else

{

throw new Exception("Search didn't return any results...");

}

HTH