May 26, 2011 10:43 AM|WombatEd|LINK
You're using both single and double quotes. And putting user input directly into your query invites SQL Injection attacks.
I'd put the TextBox.Text into a parameter, and use something like the following:
SELECT * FROM Cables WHERE CableName LIKE '%' + @SearchText + '%'