auto complete in data gridview??

Question

hai friends is it possible to keep autocompletion for a textbox in data gridview in ado.net??If possible please suggest the solution. thanks& regards divya

Shankar M · Answer

Hi Divya Try this using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace AutoCompleteTextBoxinDG { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender EventArgs e) { dataGridView1.ColumnCount = 2; dataGridView1.Columns[0].Name = No.; dataGridView1.Columns[1].Name = Name; } private void bt_close_Click(object sender EventArgs e) { this.Close(); } public AutoCompleteStringCollection AutoCompleteLoad() { AutoCompleteStringCollection str = new AutoCompleteStringCollection(); for (int i = 0; i str.Add(Name  + i.ToString()); return str; } private void dataGridView1_EditingControlShowing(object sender DataGridViewEditingControlShowingEventArgs e) { int column = dataGridView1.CurrentCell.ColumnIndex; string headerText = dataGridView1.Columns[column].HeaderText; if (headerText.Equals(Name)) { TextBox tb = e.Control as TextBox; if (tb != null) { tb.AutoCompleteMode = AutoCompleteMode.SuggestAppend; tb.AutoCompleteCustomSource = AutoCompleteLoad(); tb.AutoCompleteSource = AutoCompleteSource.CustomSource; } } } } }