Product search page
Button clieck event
Code:
protected void btnSearch_Click(object sender, EventArgs e)
{
string stradd = txtProduct.Text;
SqlHelper hlp = new SqlHelper();
stradd=hlp.chkStr(stradd);
System.Data.SqlClient.SqlParameter[] Param = new System.Data.SqlClient.SqlParameter[1];
Param[0] = new System.Data.SqlClient.SqlParameter("search_string", SqlDbType.VarChar, 255);
Code:
searchProducts -StoredProcedure
CREATE procedure searchProducts
@search_string varchar(255)
AS
select * from x_products as FT_TBL INNER JOIN
CONTAINSTABLE(x_products, *, @search_string) as KEY_TBL
ON FT_TBL.tbl_IDX = KEY_TBL.[Key]
GO
i am usgin Ms SQL Fulltext search on my application
its working fine with single world but when i try to search with multiple work ie.(hello word) its give error message
yntax error occurred near 'hello'''. Expected ''''' in search condition hello world''
Please help me
shailesh kavathiya
Full Text Search using MSSQL 2000 + ASP.net 2.0
