Look, your question is not clear. The way I understood your question
Given a customer name get all the records that match for that name? Is that right? if so
Select * from table where name = 'name'
gives you all the records. If you want close matches then
select * from table where name like 'name'
gives you all the records that closely match your name.
Once you get the query result, you need to traverse through all the values to show them in your UI.
There are plenty of tutorial here at CP, look for example this one
Using ADO.NET for beginners[
^]