How to implement search on all the tables of the database of mssql via asp.net?

Vote count:

0

My DataBase is having hundred of tables. I want to implement an optimized search on my database via front-hand such that there is only one search text-box and any string entered in the text-box is searched in all the tables and returns the relevant results.

For example i have Tables MemberInfo, SpouseInfo, ChildrenInfo, OccupationInfo.. etc.

If in text-box a user enter a name than it checks that name in all the table and than returns all the result weather that name is of member itself or of its spouse or children . I want to implement search on all the tables of my database build in Microsoft sql-server via asp.net with c#

asked 9 secs ago

VJain

172