Adding 'Google Suggest' functionality to an ASP.NET application

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

using System.Configuration;
using System.Data.OleDb;


namespace ASB
{
	public class GetAutoSuggestData : System.Web.UI.Page
	{
		//Generate menu and return it
		private void Page_Load(object sender, System.EventArgs e)
		{
			string sKeyword		=Request.QueryString["Keyword"];
			string sTextBoxID	=Request.QueryString["TextBoxID"];
			string sDivID		=Request.QueryString["DivID"];
			string sDataType	=Request.QueryString["DataType"];

			//Get menu item labels and values
			ArrayList aMenuItems=LoadMenuItems(sDataType, sKeyword);
						
			ASBMenuItem oMenuItem;
			string sHtml;

			//Output menu items to the web page
			for (int nCount=0; nCount < aMenuItems.Count; nCount++)
			{
				oMenuItem=(ASBMenuItem)aMenuItems[nCount];
				sHtml=oMenuItem.GenHtml(nCount+1, sTextBoxID, sDivID);

				Response.Write(sHtml + "\n\r");
			}
		}


		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);
		}
		#endregion



		/// <summary>Get all cities that contain specified keyword</summary>
		/// <param name="sKeyword">Keyword to use in a query</param>
		/// <returns></returns>
		private ArrayList LoadCities(string sKeyword)
		{
			ArrayList aOut=new ArrayList();

			string sConnString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\databases\\AutoSuggestBox_Demo.mdb;User Id=admin;Password=;";
			OleDbConnection oCn=new OleDbConnection(sConnString);

			string sSql="SELECT TOP 10 tblCity.Name as CityName, " +
				"tblCity.Code as CityCode, " +
				"tblCountry.Name as CountryName, " +
				"tblState.Name as StateName " + 
				" FROM (tblCity INNER JOIN tblCountry ON tblCity.CountryID=tblCountry.ID) " +
				"		LEFT OUTER JOIN tblState ON tblCity.StateID=tblState.ID " + 
				" WHERE (tblCity.Name LIKE '" + sKeyword.Replace("'", "''") + "%') " +
				" ORDER BY tblCity.Name";
		
			OleDbCommand oCmd = new OleDbCommand(sSql, oCn);
			oCn.Open();

			OleDbDataReader oReader = oCmd.ExecuteReader();

			string sCity;
			string sCityCode;
			string sState;
			string sCountry;
			
			string sLabel;

			ASBMenuItem oMenuItem;

			while (oReader.Read())
			{
				//Build label using City, Country & State
				sCity		=oReader.GetString(0);
				sCityCode	=oReader.GetString(1);
				sCountry	=oReader.GetString(2);

				if (oReader.GetValue(3)==System.DBNull.Value)
					sState="";
				else
					sState=oReader.GetString(3);
				

				sLabel=sCity;
                
				//Append either city or country
				if (sState != "")
					sLabel+=", " + sState;
				else
					sLabel+=", " + sCountry;
				
				oMenuItem=new ASBMenuItem();
				oMenuItem.Label=sLabel;
				oMenuItem.Value=sCityCode;
				
				aOut.Add(oMenuItem);
			} 

			oReader.Close();
			oCn.Close();
		
			return aOut;
		}



		/// <summary>Load array of ASBMenuItems for a specific data type</summary>
		/// <param name="sDataType"></param>
		/// <param name="sKeyword"></param>
		/// <returns></returns>
		private ArrayList LoadMenuItems(string sDataType, string sKeyword) 
		{
			ArrayList aMenuItems;

			switch(sDataType)
			{
				case "City":
					aMenuItems=LoadCities(sKeyword);
					break;
				default:
					throw new Exception("GetAutoSuggestData  Type '" + sDataType + "' is not supported.");
			}


			return aMenuItems;
		}	

	}
}