how to retrive data from database to datagridview in windows application using c#.net.

Question

hi i am developing windoes application using C#.net. i have one table with colums(id,name) in my sql database.this table having so many entries. i have one textbox,datagridview,button control on my form. my requirement is once i entered a part of name in textbox(for example:ravi kiran sastri,here i entered kiran only),then it wil search all entries in database with name kiran(in any place of name i.e first,middle,last) & it will be displayed in datagridview. how to achieve this task.please help me... thank you in advance.