Data/Profile Matching RSS

• • Reply
  

  sophia_asp

  Member

  523 Points

  485 Posts

  Data/Profile Matching

  Aug 19, 2012 07:47 AM|LINK

  Hello all,

  I have 2 tables A & B. In table A I have a description field which contains the basic description of a record and its data type is nvarchar(500).

  In Table B, I have a requirement field with nvarchar(500) datatype. 

  Now I want that as soon as I type into Requirement textbox for table B, and tab away, a popup/form must show with the mathing records which are matched from description field of Table A.

  Both Descrption and Requirement fields have values related to place, age range, and other stuff.

  Can any body please tell me how it can show that form/popup with matching records. Is there any other approach?

  Please give me sample code.

  Many thanks

• • Reply
  

  sophia_asp

  Member

  523 Points

  485 Posts

  Re: Data/Profile Matching

  Aug 19, 2012 01:10 PM|LINK

  Hello guys please reply me...

• • Reply
  

  sophia_asp

  Member

  523 Points

  485 Posts

  Re: Data/Profile Matching

  Aug 20, 2012 12:12 PM|LINK

  Please tell me, it is urgent...

• • Reply
  

  Rajesh Sawan...

  Participant

  1612 Points

  246 Posts

  Re: Data/Profile Matching

  Aug 20, 2012 01:19 PM|LINK

  Hi Friend,
  
  Below are the some of the examples with Autocomplete functionality.
  
  1 :  http://www.codeproject.com/Articles/201099/AutoComplete-With-DataBase-and-AjaxControlToolkit
  
  2 : http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/AutoComplete/AutoComplete.aspx
  
  Example 1 implements with the Database integration and this you can use in your application to
  fetch the data form second Table.
  
  Hope this will work for you.

  If this post answered your question or solved your problem, please Mark it as Answer.
  
  
  //Happy Coding
  
  Regards,
  RajeshS.
• • Reply
  

  sophia_asp

  Member

  523 Points

  485 Posts

  Re: Data/Profile Matching

  Aug 20, 2012 02:24 PM|LINK

  Rajesh Sawant

  Hi Friend,
  
  Below are the some of the examples with Autocomplete functionality.
  
  1 :  http://www.codeproject.com/Articles/201099/AutoComplete-With-DataBase-and-AjaxControlToolkit
  
  2 : http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/AutoComplete/AutoComplete.aspx
  
  Example 1 implements with the Database integration and this you can use in your application to
  fetch the data form second Table.
  
  Hope this will work for you.

  Thanks Rajesh for links but I did not meant auto complete. I want data matching such as in job portals. 

  I have two table A and B. A has a field Description with many records. Each speciality is described in a new line. Similarly in Table B with
  Requirements field I am entering details on a new line for each new requirement for one record, there are a lot of records like this. 

  Now for every new record in Table B as I click save button or tab away when finishing with Requirements field then it must show the matching records from Table A for descriptions field.

  Now for matching you may use 'Like' command but I do not want to use that because it will look for exactly  those search terms.

  So I want matching results without using Like command...

  Many thanks

• • Reply
  

  sophia_asp

  Member

  523 Points

  485 Posts

  Re: Data/Profile Matching

  Aug 20, 2012 02:27 PM|LINK

  Rajesh Sawant

  Hi Friend,
  
  Below are the some of the examples with Autocomplete functionality.
  
  1 :  http://www.codeproject.com/Articles/201099/AutoComplete-With-DataBase-and-AjaxControlToolkit
  
  2 : http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/AutoComplete/AutoComplete.aspx
  
  Example 1 implements with the Database integration and this you can use in your application to
  fetch the data form second Table.
  
  Hope this will work for you.

  Thanks Rajesh for links but I did not meant auto complete. I want data matching such as in job portals. 

  I have two table A and B. A has a field Description with many records. Each speciality is described in a new line. Similarly in Table B with
  Requirements field I am entering details on a new line for each new requirement for one record, there are a lot of records like this. 

  Now for every new record in Table B as I click save button or tab away when finishing with Requirements field then it must show the matching records from Table A for descriptions field.

  Now for matching you may use 'Like' command but I do not want to use that because it will look for exactly  those search terms.

  So I want matching results without using Like command...

  Many thanks

• • Reply
  

  Frank Jiang ...

  All-Star

  16006 Points

  1728 Posts

  Microsoft

  Re: Data/Profile Matching

  Aug 23, 2012 07:23 AM|LINK

  Please refer to the sql query below:

  select description from A where field_name in (select (field_name) from B);

  SELECT A.description FROM A, B where A.field_name = B.field_name

  or Sql join query:

  http://www.w3schools.com/sql/sql_join.asp

   

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store
  
  
  • Marked as answer by Frank Jiang - MSFT on Aug 27, 2012 02:31 AM