Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 10, 2012 12:57 AM by oned_gk
Member
3 Points
22 Posts
Nov 09, 2012 02:26 AM|LINK
Hi
I have a textbox to search within a gridview I need to match the words entered with the gridview results,
when the all the words match, the results are displayed in the grid by number of matches .
Any help will be appreciated
All-Star
36200 Points
7374 Posts
Nov 09, 2012 03:04 AM|LINK
Use autopostback textbox
Use gridview and sqldatasource
Use WHERE [yourField] LIKE '%' & @Search & '%' in youe sqldatasource select command
Use textboxt text as control parameter your sqldatasource select parameter "Search".
Nov 09, 2012 05:20 PM|LINK
HI
I did just what you say and I´m getting the records in the gridview w
I didn´t understand the last part
"use textboxt text as control parameter your sqldatasource select parameter "Search"."
Just need to somehow match the records Inserted in textbox with the gridview results and count the matches...
Thanks in advance
Nov 10, 2012 12:57 AM|LINK
Use detailview and sqldatasourc2
Sqldatasource2 Select command where condition similar with sqldatasource1
SELECT Count(*) as Total from yourtable WHERE ....
Mojorz
Member
3 Points
22 Posts
Matching textbox words with results displayed in Gridview
Nov 09, 2012 02:26 AM|LINK
Hi
I have a textbox to search within a gridview I need to match the words entered with the gridview results,
when the all the words match, the results are displayed in the grid by number of matches .
Any help will be appreciated
oned_gk
All-Star
36200 Points
7374 Posts
Re: Matching textbox words with results displayed in Gridview
Nov 09, 2012 03:04 AM|LINK
Use autopostback textbox
Use gridview and sqldatasource
Use WHERE [yourField] LIKE '%' & @Search & '%' in youe sqldatasource select command
Use textboxt text as control parameter your sqldatasource select parameter "Search".
Suwandi - Non Graduate Programmer
Mojorz
Member
3 Points
22 Posts
Re: Matching textbox words with results displayed in Gridview
Nov 09, 2012 05:20 PM|LINK
HI
I did just what you say and I´m getting the records in the gridview w
I didn´t understand the last part
"use textboxt text as control parameter your sqldatasource select parameter "Search"."
Just need to somehow match the records Inserted in textbox with the gridview results and count the matches...
Thanks in advance
oned_gk
All-Star
36200 Points
7374 Posts
Re: Matching textbox words with results displayed in Gridview
Nov 10, 2012 12:57 AM|LINK
Use detailview and sqldatasourc2
Sqldatasource2 Select command where condition similar with sqldatasource1
SELECT Count(*) as Total from yourtable WHERE ....
Suwandi - Non Graduate Programmer