.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Autocomplete Colors

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :ASP.Net


I have a question about the colors of the text in the drop down list of Autocomplete box. I'm trying to categorize them into 2 differents colors. For example, the autocomplete box will display the list of soft drink in the store and the color will identify them as "sold out" or "available".

The data in my database is seperated into 2 columns. The first one is the names of the soft drink, and the second columns identify them as "sold out" or "available.

The autocomplete box was implemented in my website using page method. There is a function in the code behind page, calling data from the web services.

Please let me know if there is any suggestion, guideline or any reference link to the answer of my problems.

Thank you.

View Complete Post

More Related Resource Links

jquery autocomplete multiple values


i got some samples and i did autocomplete using jquery , its working well for single input values

but i need to pass multiples values after one by one in the textbox. Is it possible to pass multiple

values in the textbox for autocomplete in jquery in asp.net?


build repository from SQL 2005? for a Linq, Jquery autocomplete



  I have the a question am going about his correctly I have a database for categories, it has many fields and about 4000 records,  but with a Jquery autocomplete needing speed and the fact that I only need to return a key and category name. I did the following:  (oh just to note, MVC2, Ajax project)


    public class categorySearch
        public Guid Category_GUID { get; set; }
        public string Category_Name { get; set; }


and now for the repository

    public class categoryRepository
        internal List<categorySearch> FindCategory(string searchText, int maxResults)
            List<categorySearch> category = new List<categorySearch>();
            dbWebEntities storedb = new dbWebEntities(); 

            var getcat = storedb.Categories.ToList();

            foreach (var item in getcat)
                category.Add(new categorySearch { Category_GUID = item.Cat_GUID, Category_Name = item.Category_Name});

            var result = from c in category
                         where c.Category_Name.Contains(searchText)
                         orderby c.Category_Name

Autocomplete extender not firing


Hello. I have a ajax autocomplete extender and when I enter something to textbox nothing happened. Why is that?

Here is my codes.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Configuration;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;

/// <summary>
/// Summary description for WebService
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
// [System.Web.Script.Services.ScriptService]
public class WebService : System.Web.Services.WebService {

    string[] arr;

    public WebService () {

        //Uncomment the following line if using designed components 

    public string[] testing(string prefixText)
        if (prefixText.Length > 0)
            string sql = "Select * From titles Where title like @title";

            SqlDataAdapter da = new SqlDataAdapter(sql, "Data Source=****; Database=****; uid=****; pwd=****; Persist Security Info=False; Pooling=True;");

Autocomplete with multiple word suggestions, How can we do in Asp.Net with Ajax?


Hi All,

Could you please let me know the process to get multiple word suggesions for a text box in asp.net using Ajax.  

Actually I got a solution for that,


But it used Atlas. When I am running with this code in my application, it is conflicting with Script Manager that is already there in Masterpage.

How can I overcome that problem. Is there any built-in solution in latest versions of Ajax?


Thanks in Advance,

Sateesh Nagalla,



jquery autocomplete selected value



Iam using jquery autocomplete to search data and i have button to get the detail value of employee and

display in label , what i need is that , i don't want to put button to get detail , instead i need to select the from\

auto search and press enter key  and show the detail in the lablel example(empname,address, emailid).

Looking forward valuable suggestions

Visual Studio 2010 and Autocomplete Extender


The AutoComplete Extender control from the AJAX Control Toolkit does not work. It uses a webservice to retrieve data for the Autocomplete functionality.

The problem seems to be that the event to call the webservice does not fire

I just created a new website in VS 2010 and copied and pasted the AJAX Controltookit Example code for the Autocomplete extender. This works in VS 2008 but not VS 2010

Any ideas? suggestions? Some setting in VS 2010 that has to be tweeked.



AutoComplete using Page Method HELP!



My site has 2 web service, one connects to the database, the second one calling the data from the first web service. I try to make a web application with AutoComplete Extender using Page Method from existing search.

This is the search code:

Imports App.svcNewApp

Imports System.Web.Services

Partial Public Class AppSearch

    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        Dim aService As NewApp = New NewApp()

        Dim aDataSet As DataSet = Nothing

        Dim cityZip As String = Request.Form("cityZip")

        Dim city As String = ""

        Dim aTable As DataTable

        Dim aRow As DataRow

        If (cityZip <> Nothing) Then

            Dim n As Integer



Autocomplete display multiple columns


 Hi --

I have an autocomplete extender working great returning one column and I can also retrieve multiple columns just fine from my stored procedure, but here's what I really need to do:

1. Format the data in the autocomplete extender in the following format:

Location Number
City, State, Zip

2. When the user makes a selection I want only the Location Number to populate the textbox.

I've looked quite a bit on this site and others on how to do #2 and I can't seem to find exactly how this should be done. Is there some javascript that needs to be involved in order accomplish this?

If anyone has done this I would really appreciate an example.




Ajax AutoComplete VB Code HELP!


hey guysim new to the site so bare with me. Im not sure if this has been asked before and sorry if it has.

ive been trying to figure out some code for autocomplete and everything I seem to do comes up blank.

my DataBase is called ReviewDB

the table I want to access is called Game

the Colum Name I want to retrevie is GameTitle

Dataset is call ReviewDataSet

ConnectionString is Called ReviewDBConnectionString

Webservice is called AutoComp.asmx

Im trying to get a search TextBox to Autocomplete a list of GameTitles From my DataBase. that onced send will postback to my viewGames.aspx page to display the information about that game.

Im not sure if this is even the best way todo it if you guys have better suggestions on how to search and retrive my games from the database then all ideas welcome.

thanks dave

Giving Custom Colors for Graph values in SSRS2000


Hi All,

        I am stuck here with the color for the graph values i want to give custom colors for each values present in the graph, is it possible in SSRS2000.

 Problem Statement : Suppose if i want to display two data fields as bar graph

                                 Data Fields are : Vegetable Count and Fruits Count

                                          I want Vegetable count to be in Blue Colour and I want Fruits count to be in green colour.

Any help would be appreciated.

Thanks in advance.

Anish Shenoy

Class member autocomplete


Is there in C# such feature as in VB when you create some class which inherits some interface and after clicking Enter after line Inherits SomeInterfaceHere all properties and functions which you need to inherit appear?

Can't change Gridview row colors or styles in the DataBound event


I was highlighting certain rows in my gridview using code like this in the DataBound event:

        if (e.Row.RowType == DataControlRowType.DataRow)
            int vendorCheck = 0;
            //TODO make this shorter
            if (DataBinder.Eval(e.Row.DataItem, "vendorId") != System.DBNull.Value)

jQuery UI Autocomplete, Web Services and JSON

Hi guys, this is my first post, I´m desperate after wasting 2 days in google and reading forums ans sites. I can´t make it work. I just want to provide the name of cities to show in the autocomplete plugin. Let´s go part by part:WEB SERVICE: I use the Json.Net component to serialize a datasetpublic string ConsultTable(string data) { SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["SqlServerConnection"].ToString()); SqlCommand command = new SqlCommand("SELECT name FROM cities",connection); connection.Open(); DataSet dataset = ToDataSet(command.ExecuteReader()); Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer(); json.NullValueHandling = NullValueHandling.Ignore; json.ObjectCreationHandling = Newtonsoft.Json.ObjectCreationHandling.Replace; json.MissingMemberHandling = Newtonsoft.Json.MissingMemberHandling.Ignore; json.ReferenceLoopHandling = ReferenceLoopHandling.Ignore; json.Converters.Add(new DataSetConverter()); StringWriter sw = new StringWriter(); Newtonsoft.Json.JsonTextWriter writer = new JsonTextWriter(sw); writer.Formatting = Formatting.None; writer.QuoteChar = '"'; json.Se

Create Colors for columns in Chart , WPF

Hi, How can i dynamically create colors , which i want to asigned to the Columns in a WPF toolkit Chart control. i want the colors, which are suitable to the chart control (like the ones which are by default generated). thanks Naresh

Search Autocomplete: The given key was not present in the dictionary

Hello there! I am having difficulty with my search autocomplete. Below is all the code and error logs. Why am i getting "The given key is not present in the dictionary" when i try accessing the ashx file / searching? Can't seem to find the answer....   AutoCompletePeople.ashx (placed in the _layouts) folder <%@ WebHandler Language="C#" Class="GenericHandler1" %> <%@ Assembly Name="Microsoft.SharePoint, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Assembly Name="Microsoft.Office.Server.Search, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Assembly Name="Microsoft.Office.Server, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> using System; using System.Web; using System.Data; using Microsoft.SharePoint; using Microsoft.Office.Server.Search.Query; public class GenericHandler1 : IHttpHandler { public void ProcessRequest (HttpContext context) { context.Response.ContentType = "text/plain"; string prefixText = context.Request["q"]; using (SPSite siteCollection = SPContext.Current.Site) { // create a new FullTextSqlQuery class FullTextSqlQuery query = new FullTextSqlQuery(siteCollection); query.QueryText = "SELECT Title FROM SCOPE() WHERE
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend