vb.net - textbox matching pattern from database table -

i have name textbox , want find names included in typed text in database table patient details name column. know how use operator if know letters want search start/end etc. time want textbox. think issue quotations; tried play around didn't work!

from x in patientdetails ( x.patient_name  '%" textbox1.text "%' ) 

for example: if patient name in database is: john matt

and user typed matt, above record john matt should returned.

p.s tried looking in google discuss characters not entered text box thank all.

something

c#

var query = (from x in patientdetails              x.patient_name.contains(textbox1.text)              select x).tolist(); 

vb.net - converted using codeconverter

dim query = (from x in patientdetails               x.patient_name.contains(textbox1.text)x).tolist()