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

Article translations Article translations
Article ID: 820105 - View products that this article applies to.
Expand all | Collapse all

On This Page

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.

Create a test folder

  1. Create a new folder on the C drive of your computer. Name the folder myCatalogFolder.
  2. 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.
  3. Save the file as C:\myCatalogFolder\IndexText.txt.

Create an Indexing Service catalog

  1. Click Start, and then click Control Panel.
  2. Double-click Administrative Tools.
  3. Click Computer management.
  4. Expand Services and Applications.
  5. Right-click Indexing Service, point to New, and then click Catalog.
  6. In the Name text box, type TestCatalog.
  7. Click Browse, locate the folder where you want to put the catalog, and then click OK two times.
  8. Following message appears under New Catalog Created:
    Catalog will remain off-line until Indexing Service is restarted
    Click OK.
  9. Right-click Indexing Service, and then click Stop to stop the Indexing Service.
  10. Right-click Indexing Service, and then click Start to restart the Indexing Service.

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 "Create a Test Folder" 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.

Create an ASP.NET Web application

  1. Start Microsoft Visual Studio .NET.
  2. Use Visual Basic .NET to create a new ASP.NET Web Application project. Name the project IndexQueryApp. By default, WebForm1.aspx is created.
  3. In Design view, right-click WebForm1, and then click View HTML Source.
  4. Replace the existing HTML code with following sample code.
    <%@ Page Language="vb" AutoEventWireup="false" Codebehind="WebForm1.aspx.vb" Inherits="IndexQueryApp.WebForm1"%>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    <HTML>
    	<HEAD>
    		<title>Query an Indexing Service Catalog</title>
    		<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.0">
    		<meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
    		<meta name="vs_defaultClientScript" content="JavaScript">
    		<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
    	</HEAD>
    	<body MS_POSITIONING="GridLayout">
    		<form id="Form1" method="post" runat="server">
    			<asp:TextBox id="TextBox1" style="Z-INDEX: 101; LEFT: 238px; POSITION: absolute; TOP: 76px" runat="server"></asp:TextBox>
    			<asp:DataGrid id="DataGrid1" style="Z-INDEX: 102; LEFT: 153px; POSITION: absolute; TOP: 127px"
    				runat="server" AutoGenerateColumns="False">
    				<Columns>
    					<asp:BoundColumn DataField="DocTitle" HeaderText="DocTitle"></asp:BoundColumn>
    					<asp:BoundColumn DataField="filename" HeaderText="FileName"></asp:BoundColumn>
    					<asp:BoundColumn DataField="size" HeaderText="Size"></asp:BoundColumn>
    					<asp:BoundColumn DataField="path" HeaderText="PATH"></asp:BoundColumn>
    					<asp:BoundColumn DataField="url" HeaderText="URL "></asp:BoundColumn>
    				</Columns>
    			</asp:DataGrid>
    			<asp:Button id="Button1" style="Z-INDEX: 103; LEFT: 638px; POSITION: absolute; TOP: 145px" runat="server"
    				Text="Button"></asp:Button>
    		</form>
    	</body>
    </HTML>
  5. 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
    
    #Region " Web Form Designer Generated Code "
    
       '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
    
    #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 = "TestCatalog"
    
          Dim strQuery As String
          strQuery = "Select DocTitle,Filename,Size,PATH,URL from SCOPE() where FREETEXT('" & TextBox1.Text & "')"
          ' TextBox1.Text is word that you type in the text box to query by using Index Service.
          '
          Dim connString As String = "Provider=MSIDXS.1;Integrated Security .='';Data Source='" & strCatalog & "'"
    
          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
  6. On the Build menu, click Build Solution.

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.

Troubleshoot

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.

REFERENCES

For more information about Indexing Service, visit the following Microsoft Web site:
http://msdn2.microsoft.com/en-us/library/ms689644.aspx
For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
311521 How to index ASP.NET content by using Microsoft Index Server
308202 How to create and configure a catalog for indexing


Properties

Article ID: 820105 - Last Review: January 12, 2007 - Revision: 3.3
APPLIES TO
  • Microsoft ASP.NET 1.1
  • Microsoft ASP.NET 1.0
  • Microsoft Windows Indexing Service 2.0
  • Microsoft Visual Basic .NET 2002 Standard Edition
  • Microsoft Visual Basic .NET 2003 Standard Edition
Keywords: 
kbwebserver kbwebforms kbservice kbquery kbhowtomaster KB820105

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com