Emailing Software News

    [WebMethod()]
    [ScriptMethod()]
    public string StateSuggest(string tryValue, string[] additionalParams) {
        SqlCommand sqlCommand = new SqlCommand();
        //SQL Query to load cities
        string loadCitySQL = @" 
        SELECT distinct top 7 State.StateId as StateId, State.Name as StateName FROM State 
        WHERE (State.Name like @tryValue OR State.Name like @tryValue1) ";
        //bind query parameters
        sqlCommand.Parameters.AddWithValue("tryValue", "% " + tryValue + "%");
        sqlCommand.Parameters.AddWithValue("tryValue1", tryValue + "%");
        List<SuggestionItem> items = new List<SuggestionItem>();
        //load data from DataBase
        using (SqlConnection sqlConnection = new SqlConnection(_SQLConnectionString)) {
            sqlConnection.Open(); //open connection
            sqlCommand.CommandText = loadCitySQL;//set command SQL
            sqlCommand.Connection = sqlConnection;//set command Connection
            using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader()) {
                while (sqlDataReader.Read()) {
                    //parce data from DataReader
                    string state = string.Empty;
                    string stateId = string.Empty;
                    if (sqlDataReader["StateName"] != null 
&& sqlDataReader["StateName"] != DBNull.Value) {
                        state = sqlDataReader["StateName"].ToString();
                    }
                    if (sqlDataReader["StateId"] != null 
&& sqlDataReader["StateId"] != DBNull.Value) {
                        stateId = sqlDataReader["StateId"].ToString();
                    }
                    //create SuggestionItem
                    SuggestionItem suggestionItem = new SuggestionItem();
                    suggestionItem.Title = state;
                    suggestionItem.Id = stateId;
                    //add item to the list
                    items.Add(suggestionItem);
                }
            }
            sqlConnection.Close();
        }
        
        //OLD WAY (before the x.x.2.3 version)
        //return SuggestionItem.SuggestionArrayToJSON(items.ToArray(), tryValue);
        SuggestionResult suggestionResult = new SuggestionResult();
        suggestionResult.Items = items.ToArray();
        suggestionResult.Header = new BasicSuggestionTemplate("Please select your city.");
        suggestionResult.Footer = new BasicSuggestionTemplate("Powered by ConvincingMail");
        return suggestionResult.ToJSON(tryValue);
    }

• ASP.NET 2.0
• AJAX Control Toolkit
• Prototype Javascript Framework

• Step 1: Add ConvincingMail AutoComplete dll refference to your project.
• Step 2: Declare control refference on your page. e.g.:
  <%@ Register Assembly="ConvincingMail.AdvancedAutoSuggest" Namespace="ConvincingMail.AdvancedAutoSuggest" TagPrefix="cc1" %>
• Step 3: Add Prototype JS Framework reference to your page.
• Step 4: Add the control to your page and set properties. e.g.:
  <cc1:AdvancedAutoSuggestExtender TargetControlID="CountyTextBox" AdditionalFields="StateIdTextBox" UpdateField="CountyIdTextBox" TitleTdCss="titleTd-green" TitleTrCss="titleTr-green" CommentsTdCss="commentsTd-green" CommentsTrCss="commentsTr-green" HilightedTrCss="suggestionsHilightedTr-green" ServiceUrl="~/Suggestions.asmx/CountySuggest" ID="AdvancedAutoSuggestExtender1" runat="server" /%>
  TargetControlID -- Required. The TextBox control where the user types content to be automatically completed.
  ServiceUrl -- Required. URL of the webservice which returns suggestions.
  
  View Optional Fields
  
  AdditionalFields -- Optional. Comma separated list of controls which should be used to filter results.
  UpdateField -- Optional. The TextBox (HiddenTextBox) control where the ID value of selected item is set.
  TitleTdCss -- Optional. CSS style of the suggestion item title cell.
  TitleTrCss -- Optional. CSS style of the suggestion item title row.
  CommentsTdCss -- Optional. CSS style of the suggestion item comments title cell.
  CommentsTrCss -- Optional. CSS style of the suggestion item comments title row.
  LoadingDivCss -- Optional. CSS style of the loading message (default is:suggestionsLoadingDiv).
  HilightedTrCss -- Optional (v2.1). CSS style of the suggestion hilighted item (mouse over).
  SuggestOnEmptyField -- Optional. When true the control makes a server call for suggestions when the text box is empty. (default: false).
  OnClientItemSelected -- Optional, (v2.1). ClientSide Javascript function to call when an item is selected from the suggestions list. The function accepts two params: sender and item. The item param is the selected suggestion item has the following properties:

  • Id - An ID value of the selected item.
  • Title - A highlighted title of the selected item. (like it appeares in the suggestion list)
  • Description - Selected item description. (like it appeares in the suggestion list)
  • TitleValue - Original title of the item. (no hilighting tags)

         Starting from v2.2 you can specify your own properties.
  OnClientPopulating -- Optional, (v2.3). ClientSide Javascript function to call when the webrequest started. (Use this event to show "loading icon")
  OnClientPopulated -- Optional, (v2.3). ClientSide Javascript function to call when the webrequest completed but before the suggestion list is shown. (Use this event to hide "loading icon").
  OnClientShowing -- Optional, (v2.3). ClientSide Javascript function to call before the suggestion list is shown.
  OnClientShown -- Optional, (v2.3). ClientSide Javascript function to call after the suggestion list is shown.
  OnClientHiding -- Optional, (v2.3). ClientSide Javascript function to call before the suggestion list is hidden.
  OnClientHidden -- Optional, (v2.3). ClientSide Javascript function to call after the suggestion list is hidden.
  OnClientItemOver -- Optional, (v2.3). ClientSide Javascript function to call when mouse hovers the item in the list.
  OnClientItemOut -- Optional, (v2.3). ClientSide Javascript function to call when mouse leaves from the item in the list.
  Template -- Optional, (v2.2). An HTML Prototypejs Template to render the listing item.
  HeaderTemplate -- Optional, (v2.3). An HTML Prototypejs Template to render the header of the suggested items list.
  FooterTemplate -- Optional, (v2.3). An HTML Prototypejs Template to render the footer of the suggested items list.
  LoadingText -- Optional, (v2.3). The text message to show when the content is loading from the server. (Note: you can use the OnClientPopulated and OnClientPopulating events to customize the "loading" behavior. For example you can toggle a "loading" icon like in the state field example above.)

• Step 1: -- Create new webservice (.asmx) in your project. e.g.: Suggestions.asmx
• Step 2: -- Create the method to return a JSON list of items. View Code Example

Try Online

Free Edition

Email Validation

Discussion Forum