Reply to Thread

ASP.NET VB.NET SQL Question?

Please can somebody help me with this.
Basically I need some VB.NET code to sort this I need some code like:
Try
Using myConnection As New SqlConnection(ConfigurationManager.ConnectionStrin gs("ConnectionString").ConnectionString)
Dim SQL As String = "SELECT * FROM [data] WHERE [title] LIKE '" & Request.QueryString("q") & "_'"
Dim myCommand As New SqlCommand(SQL, myConnection)
myConnection.Open()
Dim myReader As SqlDataReader = myCommand.ExecuteReader
If myReader.Read Then
results_found = 1
For Each result In myReader
results_found = results_found + 1
Next
End If
myReader.Close()
myConnection.Close()
End Using
Catch ex As Exception
End Try

What I want to do it be able to search the database. So I need a select command like SELECT * FROM [data] WHERE [title] LIKE '_query-here_'.
So I want to almost make it flexible so someone doesn't have to search for example "Google Mail" that could just type "Mail" and it would bring up Google Mail.
I know you can do this with a SQLDataSource but I need the VB.NET code.

Thanks for any help