Creating a Full Text Service and Searching items from Code behind

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;
    }

 }

You must Login to comment.