auto complete in data gridview??

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 <= 10; 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;

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Shankar M13y ago
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 <= 10; 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;
}

}

}
}
}