How to implement AutoComplete in TextBoxes n C#

Question

4.00/5 (1 vote)

See more:

I have a textbox and a database.Everytime the user types something in the textbox,data with string matching textbox's string is loaded from the database.

Now,how can i show this data in the AutoComplete Mode as it appears in Search Engines?

The database i'm using is SQL.

Posted 27-Dec-12 0:29am

Husain Sabir

Updated 27-Dec-12 0:35am

v3

Add a Solution

Comments

Asa code 11-Feb-14 23:10pm

also I want to know when select one item in text box and load to other column in table to another text box .... can some one help this ?

CHill60 1-Apr-14 19:53pm

Use the "Ask a question" link or search through CodeProject answers

4 solutions

Solution 4

This way...

C#

private void Form1_Load(object sender, EventArgs e)
{
    // declare custom source.
    var source = new AutoCompleteStringCollection();
    // fetch record from database
    datatable dt = getdatafromsql("select name from tbl");
    // fill database records to custome sorurce
    for (i=0;i<dt.rows.count;i++)>
    {
         source.Add(dt.rows[i][0].tostring(););
    }
    // Create and initialize the text box.
    var textBox = new TextBox
                  {
                      AutoCompleteCustomSource = source,
                      AutoCompleteMode =
                          AutoCompleteMode.SuggestAppend,
                      AutoCompleteSource =
                          AutoCompleteSource.CustomSource,
                      Location = new Point(20, 20),
                      Width = ClientRectangle.Width - 40,
                      Visible = true
                  };

    // Add the text box to the form.
    Controls.Add(textBox);
}

Happy Coding!
:)

Posted 27-Dec-12 0:57am

Aarti Meswania

Comments

Husain Sabir 27-Dec-12 7:09am

Got it.But i also want to scroll through the suggestions and then select a value.

Aarti Meswania 27-Dec-12 7:13am

okay then use an Auto complete Suggestion Combobox
visit...
http://www.codeproject.com/Articles/11899/Auto-Complete-Multi-Column-ComboBox

Husain Sabir 27-Dec-12 7:16am

I know that.But i don't want to use a combobox.I want to implement it in a text box.

Aarti Meswania 27-Dec-12 7:21am

then you have to create your own control because as i found solution on internet I have not seen this control with scroll for winform

and if want scroll then you need a button to popup suggesstion and that button at right hand side makes your textbox like combo
:)

Husain Sabir 27-Dec-12 7:31am

no no.ur not getting me.
i want it to be as in google search.where u get suggestions based on ur query and u can select ur relevant result from the suggestions.

Aarti Meswania 27-Dec-12 7:34am

I got you dear
see properly google suggestion will not show scroll!!! :)

Husain Sabir 27-Dec-12 7:40am

i didn't actually mean scroll.
but i just want that when i press the down key,the suggestion should be highlighted and when i press enter,the highlighted suggestion should be selected in the text box.

Aarti Meswania 27-Dec-12 7:44am

that will possible if done after write some char in textbox
winform auto suggestion textbox is having same behavior as google search textbox provides

so only way is using combobox

Husain Sabir 27-Dec-12 8:00am

ok.thank you!

Aarti Meswania 27-Dec-12 8:00am

Welcome! :)
Glad to help you! :)

Solution 1

http://www.aspdotnet-suresh.com/2012/08/using-jquery-autocomplete-with-aspnet.html[^]

see this link..

http://www.aspdotnet-suresh.com/2012/03/jquery-ui-autocomplete-textbox-with.html[^]

Posted 27-Dec-12 0:41am

Manohar_manu

Updated 27-Dec-12 0:42am

v2

Solution 3

Please refer:
AutoComplete TextBox in C#[^]
AutoComplete TextBox In WinForms Windows Forms Application[^]

Posted 27-Dec-12 0:50am

Prasad_Kulkarni

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)

Bala4 . V · Accepted Answer · 2012-12-27T00:43:00

Solution 2

Try this

C#

public void AutoComplete() 
{
AutoCompleteStringCollection AutoItem = new AutoCompleteStringCollection();
foreach (DataRow rw in Dt.rows)
{
AutoItem.Add(Rw["columnname"].ToString());

}
texbox.AutoCompleteMode = AutoCompleteMode.Suggest;
texbox.AutoCompleteSource = AutoCompleteSource.CustomSource;
texbox.AutoCompleteCustomSource = AutoItem;
}

Posted 27-Dec-12 0:43am

Bala4 . V

Updated 27-Dec-12 0:46am

v2

Comments

Husain Sabir 27-Dec-12 6:55am

This works.But i also want to select from the suggestions.

Soner Gönül 27-Aug-14 8:36am

Then you can assing AutoCompleteMode property as well.