I’ve been playing around with hooking up the JQuery AutoComplete widget with an ASP.NET Web Service. This is a really neat idea that adds a lot of whizzbang to a standard Web-based form. In theory one could also use ASP.NET UpdatePanel controls with traditional ASP.NET/HTML form controls, but I really wanted to look further into the JQuery Ajax functionality since this fits together very neatly with the JQuery AutoComplete widget.
I found three really good articles on the topic that I am listing below:
- Mudassar Khan’s ASP Snippets Blog article - Implement jQuery Autocomplete using Web Service in ASP.Net
- Andy Marshall’s article on CodeProject - Introduction to using jQuery with Web Services
- Luca Congiu’s article on MSDN - Use Jquery Autocomplete With Web Service (ASMX) DataSource
From reading the articles I have been able to adapt the information these authors presented into the logic I am looking for.
The Desired Functionality
Specifically what I am looking to do is to have a Web form with a text entry area that will offer a user suggestions for text while a user is typing. The options should be selectable and should pass an id value.
Furthermore, the suggestion list will kick in after the user has entered a minimum of two characters and will match anywhere within the database name field text for matches to show. To reduce lag and the amount of data being transmitted I am capping the returned results to a maximum of 500. Furthermore I am using the JSON protocol to keep the transferred data lightweight.
DotNetNuke (DNN) is a good content management system that greatly simplifies the day to day administration and content management of sites. One nice feature is the file management system which allows users to upload files from their local computers to the filesystem on the DNN Web server portal root. They can then use the DNN GUI to add widgets such as the Documents module that provides a fast and simple way to give site visitors access to these files.
It is often very useful to be able to query the SQL Server system tables to find data about stored procedures. Rather than running visual searches through the GUI or scripting the stored procedures, the fastest way to find what you are looking for is a direct query via SSMS (SQL Server Management Studio).
Specifically, I sometimes want to get a list of stored procedures in a database that contain a specific line of text that I want to update. An example would be that I want to look for all stored procedures that have a ‘like’ where condition and I want to change this to an ‘=’ condition. Searching through hundreds of procedures through the GUI or scripting all of the procedures and then running a search through the text are not viable options, so a call to the system tables is definitely in order.
SQL Server 2000, 2005, and 2008 all support queries against the creation date of the procedure, the name of the procedure, and the content of the procedure. However it is important to keep in mind that the system tables of SQL Server 2000 are different from those of SQL Server 2005 and 2008, so different system tables need to be queried.
The official Web site for JQuery for mobile devices. Instead of writing unique apps for each mobile device or OS, the jQuery mobile framework allows you to design a single highly-branded web site or application that will work on all popular smartphone, tablet, and desktop platforms.
See on jquerymobile.com
If there’s one thing that’s always important to keep in mind when developing Web-based applications, then it’s the settings of the browsers running the applications.
For example, Internet Explorer through its many iterations has come with a large number of quirks and settings options that vary by browser version. The number of configuration options in IE has increased significantly in version 9, which gives more control to users but mostly ends up causing confusion and support calls.
I myself find the options somewhat confusing so I intend to write a series of articles in an effort to clear the basics up.
This article in particular will cover problems and ways of dealing with IE add-ons.
Read this First
Before starting to troubleshoot IE, I suggest skimming the Internet Explorer Microsoft support knowledge-base for relevant information.
More specifically, Microsoft offers a well written debugging article for Internet Explorer that goes in detail through steps for users to take in solving problems with IE. I found this article useful since sometimes when browsing to a Web application, users can’t even see the main page and just see an error saying “Internet Explorer cannot display the webpage”.
Although the article is specific to a single problem, the troubleshooting steps are almost universally applicable with some interesting hints as well.