AutoComplete TextBox Control

Question

I want to have a textbox control that suggests and append values from a database in a Windows application with C  2008 and LINQ   I do it with a combobox but I can t do it with a textbox   How do I do it

User · Answer

To AutoComplete TextBox Control in C  net windows application using  wamp mysql database     here is my code    AutoComplete     write this   AutoComplete      text in form-load event    private void Autocomplete                 try                       MySqlConnection cn   new MySqlConnection  server localhost  database databasename user id root password  charset utf8                 cn Open                MySqlCommand cmd   new MySqlCommand  SELECT distinct Column Name      FROM table Name   cn               DataSet ds   new DataSet                MySqlDataAdapter da   new MySqlDataAdapter cmd               da Fill ds   table Name                AutoCompleteStringCollection col   new                AutoCompleteStringCollection                int i   0              for  i   0  i  lt   ds Tables 0  Rows Count - 1  i                                  col Add ds Tables 0  Rows i   Column Name   ToString                                textBox1 AutoCompleteSource   AutoCompleteSource CustomSource              textBox1 AutoCompleteCustomSource   col              textBox1 AutoCompleteMode   AutoCompleteMode Suggest              cn Close                      catch  Exception ex                        MessageBox Show ex Message   Error   MessageBoxButtons OK         MessageBoxIcon Error

User · Answer

You could attach to the KeyDown event and then query the database for that portion of the text that the user has already entered  For example  if the user enters  T   search for things that start with  T   Then  when they enter the next letter  for example  e   search for things in the table that start with  Te    The available items could be displayed in a  floating  ListBox  for example  You would need to place the ListBox just beneath the TextBox so that they can see the entries available  then remove the ListBox when they re done typing

User · Answer

of course it depends on how you implement it but perhaps this is a good start   using System Windows Forms   public class AutoCompleteTextBox   TextBox        private string   database   put here the strings of the candidates of autocomplete     private bool changingText   false       protected override void OnTextChanged  EventArgs e            if  changingText  amp  amp  database    null                  searching the first candidate             string typed   this Text Substring 0 this SelectionStart               string candidate   null              for int i   0  i  lt  database Length  i                    if database i  Substring 0 this SelectionStart     typed                        candidate   database i  Substring this SelectionStart database i  Length                       break                                if candidate    null                    changingText   true                  this Text   typed candidate                  this SelectionStart   typed Length                  this SelectionLength   candidate Length                                  else if changingText              changingText   false          base OnTextChanged e              I m not sure this is working very well  but I think the base of this code is good enough

User · Answer

You can add a parameter in the query like  emailadd to be added in the aspx cs file where the Stored Procedure is called with cmd Parameter AddWithValue      The trick is that the  emailadd parameter doesn t exist in the table design of the select query  but being added and inserted in the table       USE  DRDOULATINSTITUTE      GO             Object   StoredProcedure  dbo   ReikiInsertRow     Script Date  5 18 2016 11 12 33 AM             SET ANSI NULLS ON     GO     SET QUOTED IDENTIFIER ON     GO     ALTER procedure  dbo   ReikiInsertRow       Reiki varchar 100        emailadd varchar 50      as     insert into dbo ReikiPowerDisplay     select Reiki ReikiDescription   emailadd from ReikiPower     where Reiki  Reiki   Posted By  Aneel Goplani  CIS  2002  USA

User · Answer

private void TurnOnAutocomplete                 textBox AutoCompleteMode   AutoCompleteMode SuggestAppend          textBox AutoCompleteSource   AutoCompleteSource CustomSource          AutoCompleteStringCollection collection   new AutoCompleteStringCollection            string   arrayOfWowrds   new string             try                         Read in data Autocomplete list to a string               string   arrayOfWowrds   new string                      catch  Exception err                        MessageBox Show err Message   File Missing   MessageBoxButtons OK  MessageBoxIcon Error                      collection AddRange arrayOFWords           textBox AutoCompleteCustomSource   collection          You only need to call this once after you have your data needed for the autocomplete list  Once bound it stays with the textBox  You do not need to or want to call it every time the text is changed in the textBox  that will kill your program

User · Answer

There are two ways to accomplish this textbox effect     Either using the graphic user interface  GUI   or with code   Using the Graphic User Interface  Go to   Properties  Tab  then set the following properties     However  the best way is to create this by code  See example below   AutoCompleteStringCollection sourceName   new AutoCompleteStringCollection     foreach  string name in listNames            sourceName Add name      txtName AutoCompleteCustomSource   sourceName  txtName AutoCompleteMode   AutoCompleteMode Suggest  txtName AutoCompleteSource   AutoCompleteSource CustomSource

User · Answer

This might not be the best way to do things  but should work    this textBox1 AutoCompleteMode   AutoCompleteMode SuggestAppend   this textBox1 AutoCompleteSource   AutoCompleteSource CustomSource   private void textBox1 TextChanged object sender  EventArgs e        TextBox t   sender as TextBox      if  t    null                  say you want to do a search when user types 3 or more chars         if  t Text Length  gt   3                          SuggestStrings will have the logic to return array of strings either from cache db             string   arr   SuggestStrings t Text                AutoCompleteStringCollection collection   new AutoCompleteStringCollection                collection AddRange arr                this textBox1 AutoCompleteCustomSource   collection

User · Answer

Check out the AutoCompleteSource  AutoCompleteCustomSource and AutoCompleteMode properties   textBox1 AutoCompleteMode   AutoCompleteMode Suggest  textBox1 AutoCompleteSource   AutoCompleteSource CustomSource  AutoCompleteStringCollection col   new AutoCompleteStringCollection    col Add  Foo    col Add  Bar    textBox1 AutoCompleteCustomSource   col    Note that the designer allows you to do that without writing any code

User · Answer

private void textBox1 TextChanged object sender  EventArgs e                try                       textBox1 AutoCompleteMode   AutoCompleteMode Suggest              textBox1 AutoCompleteSource   AutoCompleteSource CustomSource              AutoCompleteStringCollection col   new AutoCompleteStringCollection                con Open                sql    select  from Table Name              cmd   new SqlCommand sql  con               SqlDataReader sdr   null              sdr   cmd ExecuteReader                while  sdr Read                                  col Add sdr  Column Name   ToString                               sdr Close                  textBox1 AutoCompleteCustomSource   col              con Close                      catch

[c#] AutoComplete TextBox Control

Examples related to c#

Examples related to winforms

Examples related to autocomplete