Microsoft KB Archive/820983

= How to use an ASP.NET application to query an Indexing Service catalog by using Visual C# .NET =

Article ID: 820983

Article Last Modified on 1/12/2007

-

APPLIES TO


 * Microsoft ASP.NET 1.1
 * Microsoft ASP.NET 1.0
 * Microsoft Visual C# .NET 2003 Standard Edition
 * Microsoft Visual C# .NET 2002 Standard Edition
 * Microsoft Windows Indexing Service 2.0

-





For a Microsoft Visual Basic .NET version of this article, see 820105.



IN THIS TASK

 * SUMMARY
 * Create a Test Folder
 * Create an Indexing Service Catalog
 * Define the Scope of the Catalog
 * Create an ASP.NET Web Application
 * Run the Application
 * Troubleshoot
 * REFERENCES



SUMMARY
This step-by-step article describes how to create an Indexing Service catalog. This article also describes how to use an ASP.NET Web application to query Indexing Service catalogs.

back to the top

Create a test folder
 Create a new folder on the C drive of your computer. Name the folder myCatalogFolder . Start a text editor such as Notepad, and then paste the following text in a blank document:

This is test document to test the index server query and this file name is IndexText.text.

 Save the file as C:\myCatalogFolder\IndexText.txt .

back to the top

Create an Indexing Service catalog
 Click Start, click Run, type compmgmt.msc, and then click OK. Expand Services and Applications.</li> Right-click Indexing Service, point to New, and then click Catalog.</li> In the Name text box, type TestCatalog .</li> Click Browse, locate the folder where you want to put the catalog, and then click OK two times.</li> Under New Catalog Created, you receive the following message:

Catalog will remain off-line until Indexing Service is restarted

Click OK.</li> Right-click Indexing Service, and then click Stop to stop the Indexing Service.</li> Right-click Indexing Service, and then click Start to restart the Indexing Service.</li></ol>

back to the top

Define the scope of the catalog
After you create a new catalog, add the folders that you want to include in the scope of the catalog. The scope is the set of folders that is included in the catalog and excluded from the catalog. The scope defines the content that is included in the index and excluded from the index. For each folder that is included or excluded, all its subfolders are also included or excluded.
 * 1) Double-click TestCatalog (the catalog that you created in the &quot;Create a Test Folder&quot; section).
 * 2) Right-click Directories, point to New, and then click Directory.
 * 3) Click Browse, locate and then click the folder that you want to add (C:\myCatalogFolder\), and then click OK.

Note Under Include in Index ?, click Yes.

back to the top

Create an ASP.NET Web application
 Start Microsoft Visual Studio .NET.</li> Use Visual C# .NET to create a new ASP.NET Web Application project. Name the project IndexQueryApp. By default, WebForm1.aspx is created.</li> In Design view, right-click WebForm1, and then click View HTML Source.</li>  Replace the existing HTML code with following sample code: <%@ Page language=&quot;c#&quot; Codebehind=&quot;WebForm1.aspx.cs&quot; AutoEventWireup=&quot;false&quot; Inherits=&quot;IndexQueryApp.WebForm1&quot; %> <!DOCTYPE HTML PUBLIC &quot;-//W3C//DTD HTML 4.0 Transitional//EN&quot; > <HTML> <HEAD> WebForm3 <meta name=&quot;GENERATOR&quot; Content=&quot;Microsoft Visual Studio 7.0&quot;> <meta name=&quot;CODE_LANGUAGE&quot; Content=&quot;C#&quot;> <meta name=&quot;vs_defaultClientScript&quot; content=&quot;JavaScript&quot;> <meta name=&quot;vs_targetSchema&quot; content=&quot;http://schemas.microsoft.com/intellisense/ie5&quot;> </HEAD> <body MS_POSITIONING=&quot;GridLayout&quot;> <form id=&quot;WebForm3&quot; method=&quot;post&quot; runat=&quot;server&quot;> <asp:TextBox id=&quot;TextBox1&quot; style=&quot;Z-INDEX: 101; LEFT: 90px; POSITION: absolute; TOP: 136px&quot; runat=&quot;server&quot;></asp:TextBox> <asp:DataGrid id=&quot;DataGrid1&quot; style=&quot;Z-INDEX: 102; LEFT: 328px; POSITION: absolute; TOP: 138px&quot; runat=&quot;server&quot;></asp:DataGrid> <asp:Button id=&quot;Button1&quot; style=&quot;Z-INDEX: 103; LEFT: 92px; POSITION: absolute; TOP: 199px&quot; runat=&quot;server&quot; Text=&quot;Button&quot;></asp:Button> </HTML> </li>  In Solution Explorer, right-click WebForm1, and then click View Code. Replace the existing code with the following sample code: using System; using System.Data;

namespace IndexQueryApp {  public class WebForm1 : System.Web.UI.Page {     protected System.Web.UI.WebControls.TextBox TextBox1; protected System.Web.UI.WebControls.DataGrid DataGrid1; protected System.Web.UI.WebControls.Button Button1; private void Page_Load(object sender, System.EventArgs e)       { // Put user code to initialize the page here. }

#region Web Form Designer generated code override protected void OnInit(EventArgs e)       { //           // CODEGEN: The ASP.NET Web Form Designer requires this call. //           InitializeComponent; base.OnInit(e); }       ///         /// Required method for Designer support - do not modify /// the contents of this method by using the code editor. ///        private void InitializeComponent {                                 this.Button1.Click += new System.EventHandler(this.Button1_Click); this.Load += new System.EventHandler(this.Page_Load); }       #endregion

private void Button1_Click(object sender, System.EventArgs e)     { // Catalog Name string strCatalog = &quot;TestCatalog&quot;; string strQuery=&quot;&quot;;

strQuery = &quot;Select DocTitle,Filename,Size,PATH,URL from Scope where FREETEXT('&quot; +TextBox1.Text+ &quot;')&quot;; // TextBox1.Text is the word that you type in the text box to query by using Indexing Service.

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

System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connstring); conn.Open;

System.Data.OleDb.OleDbDataAdapter cmd = new System.Data.OleDb.OleDbDataAdapter(strQuery, conn); System.Data.DataSet testDataSet = new System.Data.DataSet; cmd.Fill(testDataSet, &quot;SearchResults&quot;); DataView source = new DataView(testDataSet.Tables[0]); DataGrid1.DataSource = source; DataGrid1.DataBind; }      } } </li> On the Build menu, click Build Solution.</li></ol>

back to the top

Run the application

 * 1) On the Debug menu, click Start to run the application.
 * 2) Type the query word document in the text box. (You can type any word from the IndexText.txt file.)
 * 3) Click Button. Notice that the data grid appears and contains the query results from the IndexText.txt file.

back to the top

Wait for the index to be built
Indexing Service automatically processes the TestCatalog and prepares a word list for indexing. When you run the sample code, you may not receive the results as quickly as expected because Indexing Service requires some time to build the index.

To verify the state of the index, start the Computer Management MMC snap-in. Click Indexing Service in the right pane, and then verify that the Word List value for TestCatalog is greater than zero. If the Word List value is zero, wait for the index to build the list.

Index data may have become corrupted
If the search does not return the expected search results when you query the index, the index data may have become corrupted. To troubleshoot this issue, stop and then restart Indexing Service to index all documents again. To do this, follow these steps:
 * 1) Click Start, point to Settings, and then click Control Panel.
 * 2) Double-click Administrative Tools, and then double-click Computer Management.
 * 3) In the console tree, double-click Services and Applications.
 * 4) Right-click Indexing Service, and then click Stop.
 * 5) Right-click Indexing Service again, and then click Start.

back to the top

<div class="references_section">