Including Search for your website documents -Part 2

If you have come to this article without reading the Part 1, please check Part 1

Once you have created the Catalog for your Search, you can use the Catalog for searching.

Using the Catalog in your Application

1. In your Search Page, have a Textbox (TextBox1) and a Button (Button1).

2. In the click event of the Button, put the following code.

string strCatalog = <Put the Name of the Catalog here>;

strQuery = "Select Filename from Scope() where FREETEXT('" + TextBox1.Text + "')";

string connstring = "Provider=MSIDXS.1;Integrated Security .='';Data Source="+ strCatalog;

OleDbConnection objconn = new OleDbConnection(connstring);

OleDbCommand objcmd = new OleDbCommand(strQuery, objconn);

OleDbDataReader objRdr=null;
objconn.Open();
objRdr=objcmd.ExecuteReader();

if(objRdr.HasRows)
{
while(objRdr.Read())
{
docname += objRdr["Filename"].ToString() + ",";
}
docname=docname.Remove(docname.Length-1,1);
}
}


Now "docname" has a comma separated list of file names containing the search text.

You can have an XML File or a Database table with Nodes/Fields - FileName, a Heading and a Description, which you can use to look up for the document name and get the desired results for displaying in your Page.

This way, you can implement search for your website without writing the logic for search.

This article applies to Windows 2000, Windows XP and Windows 2003

Note:
If you would like to search for PDF Files, you need to install the PDF Filter for Indexing Service which helps the Indexing Service in searching within PDF Files. Its a freeware download and can be downloaded from
Here

posted @ Monday, April 25, 2005 7:55 AM

Print

Comments on this entry:

No comments posted yet.

Your comment:



 (will not be displayed)


 
 
 
 
 

Live Comment Preview:

 
«November»
SunMonTueWedThuFriSat
25262728293031
1234567
891011121314
15161718192021
22232425262728
293012345