add Functionnality AutocompleteBox : search in multi column

9 posts, 0 answers
  1. Olivier
    Olivier avatar
    146 posts
    Member since:
    Nov 2010

    Posted 14 Nov 2012 Link to this post

    Hello

    Can you add this functionnality in AutoCompleteBox.

    We can only search on the property  " DataTextField " of the AutoComplete

    it's wil be useful if you add an attribute property  " SearchDataColumn " and we can add a separate column of sql with ","
    if i put  SearchDataColumn="Column1, Column2, Column3" your query can search in this column.

    Thanks in advance,

    Olivier
  2. Nencho
    Admin
    Nencho avatar
    1457 posts

    Posted 19 Nov 2012 Link to this post

    Hi Oliver,

    Thank you for your suggestion. I will forward it to our development team for further consideration.

    Kind regards,
    Nencho
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. tony
    tony avatar
    5 posts
    Member since:
    Jul 2011

    Posted 19 Nov 2012 Link to this post

    +1 i wait this functionnality
  5. Olivier
    Olivier avatar
    146 posts
    Member since:
    Nov 2010

    Posted 19 Nov 2012 Link to this post

    Thanks Nencho for your help !

    i appreciate that !

    Olivier
  6. Olivier
    Olivier avatar
    146 posts
    Member since:
    Nov 2010

    Posted 08 Dec 2012 Link to this post

    Hello Nencho

    You have a web form to add functionnality to the telerik team ? a web page : New idea ! ?

    Thanks
  7. Calleigh
    Calleigh avatar
    9 posts
    Member since:
    Sep 2010

    Posted 10 Dec 2012 Link to this post

    There is no ASP.NET control that exposes such "search data columns" property.
    If you want to search in some columns of a database table  - you can simply modify your SQL "Select" statement.
  8. Olivier
    Olivier avatar
    146 posts
    Member since:
    Nov 2010

    Posted 10 Dec 2012 Link to this post

    hello Calleigh

    With asp.net ajax we can search in data columns, with telerik we don't cause , we don't access of the sql statement
    the "where statement".


    We want modify the where to search city name, zip code or department code , you have only search on 1 column
    in your web application ?


    Olivier
  9. Calleigh
    Calleigh avatar
    9 posts
    Member since:
    Sep 2010

    Posted 10 Dec 2012 Link to this post


    I probably misunderstood your concept.
    How exactly do you search in many datatable columns using the ASP.NET controls properties? What controls do you use?
  10. Olivier
    Olivier avatar
    146 posts
    Member since:
    Nov 2010

    Posted 10 Dec 2012 Link to this post

    Voilà a website which represent my concept : http://www.century21.com/property-search

    you can search on the autocompleteBox  : "los angeles" ,"90210" , "Michigan" or "California"
    This value are store in the different column of the select , and the display is also different.

    it's exactly that i would make with telerik.

    I use today Autocomplete from asp.net
    http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/AutoComplete/AutoComplete.aspx

    And i change in the sql my filter in the where , but the webservice is too Slow ,

    Telerik is more fast and i ask to nencho to ask to add this functonnality. , Column Display="Col1, Col3 " and Column Filter= "Col4, Col1,Col2,Col3"

    Please if you can test on century21 to search a location, you ll understand my concept.

    Olivier,
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017