I have a table "Employees" with 3 Rows: Name, Age, Salary.
I have one text box: text1
One listbox: list1
I am trying to write a program that will search names by the name insered in the textbox
For example if i'll insert the name John it will return me all of John's data, but if there isn't John in the table, it will search names starting with Joh.....Jo.......J and return all the names and data relevant (print it in the listbox)
I've tried to use the "Like" option in the SQL statement but it seems to have problems with variables.