How to use the Like operator of T-SQL command query?

Hello!
I've been using LINQ for database query operations but I want to try also the T-SQL command query using the 'Like' operator which I believe same as the combination of startswith() and contains() method in linq. I tried to use the format I found online but nothing happens, it won't retrieve the data which I supposed to display on the drop-down list when the user types in the keywords on the combobox which would the same keywords stored in my records. I need some assistance if I missed some valid syntax for my select querycommand. Here is my code below for your reference. I greatly appreciate any informative response that could be shared. Thank you.
 

                SqlConnection myConnection = new SqlConnection();
                SqlCommand myCommand = new SqlCommand();
                SqlDataRea ...