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