Search Database using Partial Text and Display results in GridView in ASP.Net

Hi,

I need a query to fetch records from data from database based on partial text entered in textbox like search data from College table based on College Name entered in text box. I want that all record containing that College name displayed in grid view.

Thanks,

Puneet