How to add search facility in the database - driven web site.

Question

Thankx for showing interest in my subject.
Lets get to the point.
How to add search facility in database driven web site and link the results with their respective .aspx pages ?

EXAMPLE:

Search: sam Go

RESULT     TYPE             VIEW   EDIT
sam.j        customer     view    edit  ---------------> open customer.aspx for view or edit
sam.j        Group          view    edit  ---------------> open Group.aspx for view or edit
.
.
.

plz don't get confused with the indexing search service with this one because it searches for pages and databased driven web site searches in the data base and link the searched info with their respective pages.