HI
I have tree table in database
1-House_info Table
|
Id
|
Name
|
Date
|
Behcode
|
Discription
|
|
1
|
Sara
|
2012
|
1111
|
This is test
|
|
2
|
Jack
|
2013
|
2222
|
Here is paris
|
2-House_P Table
|
Id
|
Name
|
Model
|
Behcode
|
Date
|
discription
|
|
1
|
TV
|
LG
|
1111
|
2013
|
this is book
|
|
2
|
Iron
|
XX3
|
1111
|
2013
|
This is economy
|
3-House_S Table
|
Id
|
Name
|
Discription
|
Behcode
|
|
1
|
News
|
Today is economy day
|
2222
|
|
2
|
Events
|
Tomorrow is my birthday
|
11111
|
in Search .aspx page I have button -BtnSearch and datalist1
I want when I click on Btnsearch it search in
House_info table in (Name and Discription Columns )AND House_p (Name-Mode-Discription columns)
and House_s (Name and discription Columns )and if in these Columns be below words
Economy or LG or Paris it shows Behcode and the column that words are on it
Generally I want define some words in database and when I click on button it search in some Columns from different table and if there was that words it shows in datalist
How I can do it?
Thanks alot
Neda
