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();
        }
        return SuggestionItem.SuggestionArrayToJSON(items.ToArray(), 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.
  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.
  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)
  
  

• 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

Special Offer

Try Online

Free Demo

Email Validation

Discussion Forum