AJAX and SQL - Articles,Opinons ?

  • We are tossing around the idea of using AJAX for our new application and I was looking for some opinions and articles to read about it.

    I'm am interested in performance capabilities and how it will alter the way I code procedures etc.?

    For example:

    I was thinking about an AutoComplete text box that filled in the Customer Name as the user typed. How would I code a proc for that. On the page load I could just return the whole customer list or I could return the record set after doing a like search with the letters that the user typed. i.e. select name from customer_list where name like 'ABC%'

  • I think like is slow why not create a select list or JOIN query which can be used by with a genericlist, another option is to use the readxml method of a dataset.  Try the link below for some code to get started.  Hope this helps.

    http://blogs.msdn.com/delay/archive/2007/03/30/autocomplete-how-to-create-a-multi-word-auto-complete-text-box.aspx

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply