Searching two fields

4 posts, 0 answers
  1. dhlennon
    dhlennon avatar
    32 posts
    Member since:
    Oct 2006

    Posted 16 Aug 2013 Link to this post

    I am using radsearchbox against a database of town or city names, and that works great.

    I have an additional field in my database of 'alternative spellings' of these town names  (anglicised versions, ones without special accent characters, etc)

    Is it possible to get my searchbox to match against not just the field specified in my datatextfield but against both fields?

    Should I be using the DataSourceSelect server side event to modify the query?

    Thanks
  2. Plamen
    Admin
    Plamen avatar
    2731 posts

    Posted 21 Aug 2013 Link to this post

    Hello,

    Thank you for contacting Telerik support.

    You can achieve such behavior by using OnDataSourceSelect server event and setting the correct select statement. I am attaching a sample web page where similar behavior is implemented.

    Please review it and let me know if you have further questions.

    Regards,
    Plamen
    Telerik
    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 the blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. christof
    christof avatar
    1 posts
    Member since:
    Mar 2014

    Posted 31 Mar 2014 Link to this post

    Hi,

    Is this also possible using DataTables instead of SQLDataSource?
    Thanks!
  5. Plamen
    Admin
    Plamen avatar
    2731 posts

    Posted 02 Apr 2014 Link to this post

    Hi,

    Yes, in cases when DataSource property is used as in this help topic you could use again the OnDataSourceSelect event and set the DataSource again to the filtered according to your scenario DataTable.

    Hope this will be helpful.

    Regards,
    Plamen
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top