How Do I Display All Names Of Employees By Providing Partial

Question

i am using winforms(C#) for developing employee details of an organization. I have used groupbox for search criteria which has ID(textbox) and name(textbox). I am able to get the details if i provide whole of first name and search.But my problem is to get all the names displayed based on only part of name given(not whole name).For example, when i give "Da" in textbox all the names starting with Da(david,daniel etc)should be displayed. My coding is in C# and db is mysql.can anyone please suggest a solution.