How to Auto complete textbox control in C# to most rcent values from a database?

Question

3.50/5 (2 votes)

See more:

SQL-Server-2005

, +

i am trying to auto complete text box control in C# which uses SQLServer 2005 ,I want to set AutoCompleteCustomSource to a collection which holds the retrieved values from database.I am little confusing about this ,say i am retrieving all values from a column of a table ,my question is particular column have 10000records , will it make my application to very slow?if it makes my application slow,how can i retrieve most recent values from that column, for a example last 20 records from that column.
Please can any one give a solution ?

Posted 24-May-11 8:40am

Thabo@Codeproject

Updated 24-May-11 8:42am

v3

Add a Solution

Comments

Orcun Iyigun 24-May-11 15:13pm

Well maybe you can add another column to your table indicating the recent value(s). When someone uses the corresponding record, you increment the value of the column on that record which you created for the recent value. Next time you sort the columns depending to this column getting the top 20 records. But I dont know how useful this is going to be.

Thabo@Codeproject 25-May-11 3:44am

Thanks ....that is good idea!..Thanks again..

sairam.bhat 25-May-11 2:39am

good qstn

Thabo@Codeproject 25-May-11 3:52am

@sairam.bhat:Thanks

2 solutions

Solution 2

Add this on form load
private AutoCompleteStringCollection AutoComplete1 = new AutoCompleteStringCollection();
private AutoCompleteStringCollection AutoComplete2 = new AutoCompleteStringCollection();

Create a function for Autocomplete.

C#

private void setAutoComplete()
        {
            DataTable dt = new DataTable();
            dt = GetData();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                scAutoComplete.Add(dt.Rows[i]["Auto"].ToString());
                scAutoComplete.Add(dt.Rows[i]["Code"].ToString());
            }
        }

GetData is a another function for Get Data from SQL Server and save in record in DataTable.
Happy coding :)

Posted 24-May-11 10:18am

divesh12

Updated 24-May-11 10:22am

v2

Comments

sairam.bhat 25-May-11 2:39am

good ans

divesh12 31-May-11 10:00am

thanks sairam

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RaviGupta7986 · Accepted Answer · 2011-05-24T09:37:00

Solution 1

just updating reply from orc_orc_orc : add a identity column to your database table and then retrieve top 20 columns by firing a simple query somewhat like
"SELECT TOP 20 <column_name> FROM <table_name> ORDER BY <identity_column_name> "

Posted 24-May-11 9:37am

RaviGupta7986

Comments

sairam.bhat 25-May-11 2:40am

good ans

Thabo@Codeproject 25-May-11 3:48am

@ Ravi Gupta :Thanks i am accepting your and orc_orc_orc answer..Thanks again