创建全文服务并从代码隐藏搜索项目

1. 打开 SQL Server 并打开一个数据库（已创建）。在存储部分找到全文目录。右键单击并创建新的目录。
2. 创建存储过程如下：
   

CREATE PROCEDURE [dbo].[spSelectBusinessInfoByKeyword]

    @Keyword nvarchar (50)
AS

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

 在代码后台

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

 }