i used a stored procedure to search all data in my tables as: USE [PROC1] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <author,,name> -- Create date: <create> -- Description: <description,,> -- ============================================= ALTER PROCEDURE [dbo].[sp_SearchArPages] @prmWordSearch nvarchar(150) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; DECLARE @sqlart nvarchar(MAX) SET @sqlart ='select ID,ArticleTitle,ArticleText from Articles where ArticleTitle like ''%' + @prmWordSearch + '%'' OR ' + ' ArticleText like ''%' + @prmWordSearch + '%''' EXEC sp_executesql @sqlart END ''''''''''''''''''''''' my code in aspx.vb page: <pre lang="vb">If Request.QueryString("srcKeyWord") <> "" Then lblcontent.Text = cls.searchOnArPages(Request.QueryString("srcKeyWord")) End If</pre> '''''''''''''''''' searchOnArPages function: <pre lang="vb">Function searchOnArPages(ByVal strKeyWord As String) As String Dim strResults As String = "" Dim sqlAdp As New SqlDataAdapter Dim sqlCmd As New SqlCommand Dim ds As New DataSet sqlCmd.CommandText = "sp_SearchArPages" sqlCmd.CommandType = CommandType.StoredProcedure sqlCmd.Connection = sqlCN sqlCmd.Parameters.Add(New SqlParameter("@prmWordSearch", SqlDbType.NVarChar)).Value = strKeyWord sqlAdp.SelectCommand = sqlCmd sqlAdp.Fill(ds) Dim intResultsCount As Integer = CInt(ds.Tables(0).Rows.Count + ds.Tables(1).Rows.Count + ds.Tables(2).Rows.Count + ds.Tables(3).Rows.Count + ds.Tables(4).Rows.Count + ds.Tables(5).Rows.Count + ds.Tables(6).Rows.Count + ds.Tables(7).Rows.Count) If intResultsCount > 0 Then For i As Integer = 0 To ds.Tables(0).Rows.Count - 1 strResults = strResults & "<tr><td><a class='cssSRC' href='ARCont.aspx?ArticleId=" & ds.Tables(0).Rows(i).Item(0) & "'>" & ds.Tables(0).Rows(i).Item(1) & ": " & ClearHTMLTags(Left(ds.Tables(0).Rows(i).Item(2), 100) & "....Read more", 0) & "</a></td></tr>" Next Else strResults = strResults.Insert(0, "<table boder="0" width="70%"><tr><td><i> no results <font style="font-size:12px;color:red;"> ' " & strKeyWord & " '</font> please try again.</i></td></tr>") strResults = strResults & "</table>" End If Return strResults End Function</pre></create>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)