Search ability is too limited in my VB 2008/ SQL Server program
Posted on 2011-10-28
Is there any thing I can do to create a search of a database table that wil look into the entire cell instaed of just the first word in the cell? Right now it will search a single column and only the first word in each cell for a perfect match.
If this question is like asking someone to write a program for me, then I would be happy if you could just point me in the right direction; like a book or video. I got the info for my current seach ability from Beth Massi (blogs.msdn), and I must admit, it works great.
Here is some VB code in the Windows form.
Private Sub Search_Item_a_descriptionToolStripButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Search_Item_a_descriptionToolStripButton.Click
Catch ex As System.Exception
This code in from the table adapter:
SQL Select statement Bla Bla Bla And at the end, I put the following:
WHERE (Item_a_description LIKE @Item_a_description + '%')
I did this for a number of columns and they all work, but this is limited and combersome. Thank you for any help.