Matching textbox words with results displayed in Gridview RSS

• • Reply
  

  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  

  • Moved by Mikesdotnetting on Nov 09, 2012 03:53 PM
• • Reply
  

  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".

  Programming to simplify, dont look for hard way
  Suwandi - Non Graduate Programmer
  • Edited by oned_gk on Nov 09, 2012 03:05 AM
• • Reply
  

  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

• • Reply
  

  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 ....

  Programming to simplify, dont look for hard way
  Suwandi - Non Graduate Programmer
  • Marked as answer by Mojorz on Nov 13, 2012 02:53 PM