Microsoft KB Archive/820105

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

Article ID: 820105

Article Last Modified on 1/12/2007

-

APPLIES TO


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

-



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. It 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 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, and then click Control Panel. Double-click Administrative Tools. Click Computer management.</li> 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> Following message appears under New Catalog Created:

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 included in the scope of the catalog. The scope is the set of folders that is included in and excluded from the catalog. The scope defines the content that is included 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 Basic .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;vb&quot; AutoEventWireup=&quot;false&quot; Codebehind=&quot;WebForm1.aspx.vb&quot; Inherits=&quot;IndexQueryApp.WebForm1&quot;%> <!DOCTYPE HTML PUBLIC &quot;-//W3C//DTD HTML 4.0 Transitional//EN&quot;> <HTML> <HEAD> Query an Indexing Service Catalog <meta name=&quot;GENERATOR&quot; content=&quot;Microsoft Visual Studio .NET 7.0&quot;> <meta name=&quot;CODE_LANGUAGE&quot; content=&quot;Visual Basic 7.0&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;Form1&quot; method=&quot;post&quot; runat=&quot;server&quot;> <asp:TextBox id=&quot;TextBox1&quot; style=&quot;Z-INDEX: 101; LEFT: 238px; POSITION: absolute; TOP: 76px&quot; runat=&quot;server&quot;></asp:TextBox> <asp:DataGrid id=&quot;DataGrid1&quot; style=&quot;Z-INDEX: 102; LEFT: 153px; POSITION: absolute; TOP: 127px&quot; runat=&quot;server&quot; AutoGenerateColumns=&quot;False&quot;> <Columns> <asp:BoundColumn DataField=&quot;DocTitle&quot; HeaderText=&quot;DocTitle&quot;></asp:BoundColumn> <asp:BoundColumn DataField=&quot;filename&quot; HeaderText=&quot;FileName&quot;></asp:BoundColumn> <asp:BoundColumn DataField=&quot;size&quot; HeaderText=&quot;Size&quot;></asp:BoundColumn> <asp:BoundColumn DataField=&quot;path&quot; HeaderText=&quot;PATH&quot;></asp:BoundColumn> <asp:BoundColumn DataField=&quot;url&quot; HeaderText=&quot;URL &quot;></asp:BoundColumn> </Columns> </asp:DataGrid> <asp:Button id=&quot;Button1&quot; style=&quot;Z-INDEX: 103; LEFT: 638px; POSITION: absolute; TOP: 145px&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. Public Class WebForm1 Inherits System.Web.UI.Page Protected WithEvents TextBox1 As System.Web.UI.WebControls.TextBox Protected WithEvents Button1 As System.Web.UI.WebControls.Button Protected WithEvents OleDbConnection1 As System.Data.OleDb.OleDbConnection Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid


 * 1) Region &quot; Web Form Designer Generated Code &quot;

'Web Form Designer requires this call. <System.Diagnostics.DebuggerStepThrough> Private Sub InitializeComponent Me.OleDbConnection1 = New System.Data.OleDb.OleDbConnection

End Sub

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init 'CODEGEN: Web Form Designer requires this method call. 'Do not modify it by using the code editor. InitializeComponent End Sub


 * 1) End Region

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim strCatalog As String

' Catalog Name strCatalog = &quot;TestCatalog&quot;

Dim strQuery As String strQuery = &quot;Select DocTitle,Filename,Size,PATH,URL from SCOPE where FREETEXT('&quot; & TextBox1.Text & &quot;')&quot; ' TextBox1.Text is word that you type in the text box to query by using Index Service. '     Dim connString As String = &quot;Provider=MSIDXS.1;Integrated Security .='';Data Source='&quot; & strCatalog & &quot;'&quot;

Dim cn As New System.Data.OleDb.OleDbConnection(connString) Dim cmd As New System.Data.OleDb.OleDbDataAdapter(strQuery, cn) Dim testDataSet As New DataSet

cmd.Fill(testDataSet)

' Bind DataGrid to the DataSet. DataGrid is the ID for the ' DataGrid control in the HTML section. Dim source As New DataView(testDataSet.Tables(0)) DataGrid1.DataSource = source DataGrid1.DataBind End Sub End Class </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 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 expected because Indexing Service requires some time to build the index. To verify the state of the index, 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 restart Indexing Service to re-index all documents. 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, and then click Start.

back to the top

<div class="references_section">