Description
This is a sample project made to help ASP.net developers. This projects highlights how to add search facility to your asp.net page using ADO.net to browse index server search catalogs. To be able to understand this , developer should have knowledge of using ADO.net to show the data on the Asp.net Page.
Introduction
This code is developed to enable search facilities to ASP.net applications. This is a easy to use as only with few lines of code you will be able provide dynamism to your applications. It works like accessing a query from database. Before starting this project , you must create a catalog using the Index Server. To read more details how to create and configure catalogs
Table Format
| Heading |
Heading |
| using Index Server Search in ASP.net |
This is a sample project made to help ASP.net developers. This projects highlights how to add search facility to your asp.net page using ADO.net to browse index server search catalogs. To be able to understand this , developer should have knowlege of using ADO.net to show the data on the Asp.net Page. |
Create Catalog :
To create a catalog
- In the MMC, select Index Server.
- From the Action menu, select Stop.
You must stop the Content Index service before you can add a catalog.
- From the Action menu, select Create New and then Catalog.
- In the Add Catalog dialog box, type the name of the catalog.
- Click the Browse button and select a directory where you want this new catalog to be located.
- When you have selected the catalog location, click the OK button.
- With Index Server selected, from the Action menu, select Start.
Restarting Index Server makes the new catalog available for the indexing process.
Note : Before you can add a new catalog, you must stop Index Server. After you create a new catalog, you must restart Index Server to bring the new catalog online. But before bringing it online, you may want to add directories and modify catalog properties.
Summary using catalog in asp.net
This project is development using following packages in the ASP.net Application with Csharp.
using System.Data;
using System.Data.OleDb;
ASPX page contains one textbox , Button and label on the page
<form id="search" method="post" runat="server">
<TABLE id="Table3" cellSpacing="1" cellPadding="1" width="95%" align="right" border="0">
<TR>
<TD>
<P> </P>
<P>
<asp:Label id="Label1" runat="server">Search Site</asp:Label>
<asp:TextBox id="txtSearch" runat="server"></asp:TextBox>
<asp:Button id="btnSearch" runat="server" Text="Search"></asp:Button><BR>
<BR>
<asp:Label id="lbl" runat="server"></asp:Label></P>
</TD>
</TR>
</TABLE>
</form>
protected System.Web.UI.WebControls.TextBox txtSearch; protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Button btnSearch;
protected System.Web.UI.WebControls.Label lbl;
public int cnt;
/// <SUMMARY>
/// On the click of button, search for the keyword in the index catalog , and show the matching result on the page /// </SUMMARY>
/// <PARAM name="sender"></PARAM>
/// <PARAM name="e"></PARAM>
private void btnSearch_Click(object sender, System.EventArgs e)
{
// connecting string for connecting index server, In this provider name is MSIDXS ; DataSource is name of the catalog name in the index server.
// create a connection object and command object, to connect the Index Server
System.Data.OleDb.OleDbConnection odbSearch = new System.Data.OleDb.OleDbConnection(); System.Data.OleDb.OleDbCommand cmdSearch = new System.Data.OleDb.OleDbCommand();
//assign the connecting string to the oledb connection object , replace Catalog Name with the name of index catalog created earlier
odbSearch.ConnectionString = "Provider=\"MSIDXS\";Data Source=\"[Catalog name]\";";
//assign connection to command object cmdSearch
cmdSearch.Connection = odbSearch;
//Query to search a free text string in the catalog in the contents of the indexed documents in the catalog
try
{
// Make freetext search in the contents and retreive document titles , path , rank from the index catalog
cmdSearch.CommandText = "select doctitle, filename, vpath, rank, characterization from scope() where FREETEXT(Contents, '"+txtSearch.Text +"') and filename <> 'search.aspx' order by rank desc ";
odbSearch.Open();
try
{
OleDbDataReader rdrSearch = cmdSearch.ExecuteReader(); //dg1.DataSource=rdrSearch; //dg1.DataBind(); cnt=1;
lbl.Text="";
// your databinding or display code here
while( rdrSearch.Read())
{
// Call method get pagelink to write process and show the valid link on the page , here we have used getpagelink to show the file name searched
getpagelink(rdrSearch[1].ToString());
}
}
catch(Exception ex)
{
lbl.Text=ex.Message ;
}
odbSearch.Close();
}
catch( SqlException ex)
{
lbl.Text=ex.Message.ToString();
odbSearch.Close();
}
}
/// <SUMMARY>
/// This function creates the link of the searched document in the predefined template.
/// </SUMMARY>
/// <PARAM name="srcfile">This Function is </PARAM>
public void getpagelink(string srcfile)
{
string temp= (cnt).ToString() +".) " + srcfile;
}
To customize your pages , you can put several Headers and other HTML Tags to make it familiar to your pages, In case you have already fixed your templates you can make a user control instead of making a ASPX page and then add User control to any of webforms and load them, using this technique.
To test this page type keyword in the text box and click the button given on the page and wait for the page response.