How do i allow the user to search records that has a
certain 'name' or certain 'address' or certain 'age' in below fields.

Table1 fields:
CompanyID, company, status, shares, datejoined <- CompanyID unique

Table2 fields:
CompanyID, name, address, age, salary <- multiple's CompanyID valid

DataRelation = Table1Table2 ; Common Key: CompanyID

-
datadapterTable1.fill(dsCompany)
datadapterTable2.fill(dsCompany)
-

From here, how do i list in a datagrid fields:
CompanyID, name, address, age, salary
eg:
001 JOHN 12 SMITH RD 23 1300
001 SHARON 13 SMITH RD 24 1700
003 JOE 14 SMITH RD 25 2000
003 JIM 15 SMITH RD 26 2500

For example above, the user searched for 'SMITH' keyword
for address 'field', and how do i choose the sorting order?

Thanks