ASP.NET 搜索

1、在SQL Server中配置全文检索属性和字段。
2、在ASP.NET的查询功能中，SQL语句写成“SELECT ColumnName FROM TableName Where FreeText(*,'KeyWord');
3、使用ADO.NET,查询就OK了。

数据库联接类
Imports Microsoft.VisualBasic
Imports System
Imports System.Data
Imports System.Drawing
Imports System.DBNull
Imports System.Data.SqlClient

Public Class conn
Public objDataSet As DataSet
'定义一个数据集对象
Public objDataView As DataView
'定义一个数据视图对象
Public objDataAdpter As SqlDataAdapter
'定义一个数据适配器对象
Public objSqlConnection As SqlConnection = New SqlConnection("data source=(local);initial catalog=LineChart;user id=sa;password=") '定义数据库

'定义了查询语句
Public Function GetDataFromDB(ByVal sqlstr As String) As DataSet
objDataSet = New DataSet
objDataSet.Clear()
'实例化一个数据集对象
Try
objSqlConnection.Open()
'打开数据库连接
objDataAdpter = New SqlDataAdapter(sqlstr, obj