how to write serch in database

Posted by chirivellaphaniraja-14771 under ASP.NET on 4/9/2012 | Points: 10 | Views : 839 | Status : [Member] | Replies : 2
Hi to all how to write search in database suppose if u choose the key skills in radio button it will be display only key skills

and if u choose the all the resumes in radio button then it will display only all the resumes.

please give me answer urgent

Thanks to all




Responses

Posted by: Rajni.Shekhar on: 4/9/2012 [Member] Bronze | Points: 25

Up
0
Down
Create dynamic query where criteria for that and display whatever you want.

like for first option if radio checked then string strWhere= "where keyskill";
Please your table structure to give you answer.

Thanks,
Rajni Shekhar

chirivellaphaniraja-14771, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Mani5155 on: 4/10/2012 [Member] Starter | Points: 25

Up
0
Down
SELECT resume_title FROM table_name WHERE Key_skill IN (Key_skill1,Key_skill2,...)

when radio button clicked add radio button value to the where clause

Top Forums Authors
Sun, 22-Oct-2017 Authors
All Time Authors
Jayakumars
6050
Karthikanbarasan
3455
Oswaldlily
3300

Latest members | More ...


(Statistics delayed by 5 minutes)
Advertisements