65.9K
CodeProject is changing. Read more.
Home

Creating a Full Text Service and Searching items from Code behind

emptyStarIconemptyStarIconemptyStarIconemptyStarIconemptyStarIcon

0/5 (0 vote)

Oct 11, 2013

CPOL
viewsIcon

6032

Open SQL Server and open a database (Already created) . On the Storage section find the Full Text Catalog. Right click and create a New

  1. Open SQL Server and open a database (Already created) . On the Storage section find the Full Text Catalog. Right click and create a New Catalog.
  2. Create SP like this 

CREATE PROCEDURE [dbo].[spSelectBusinessInfoByKeyword]

    @Keyword nvarchar (50)
AS

SELECT BusinessInfoID,BusinessName,Description
FROM [BusinessInfo]
WHERE FREETEXT (*,@Keyword)

 

 In the code behind

 public DataSet PopulateResultGrid()
        {

    try

    {         
           
    Database db = DatabaseFactory.CreateDatabase(DATABASE_CONNECTIONTSRING);
    DbCommand dbPopCommand = db.GetStoredProcCommand(ULCommon.SP_SELECT_BUSINESSINFOBYKEYWORD);
    db.AddInParameter(dbPopCommand, "@Keyword", DbType.String,this.Keywords);
    DataSet dSet = new DataSet();
    dSet = db.ExecuteDataSet(dbPopCommand);
    return dSet;
    }
    catch (Exception ex)
    {
            throw ex;
    }

 }