Hi Ben,
I have created a sample as per your specifications and have
attached it here. It works fine and any changes in the DataSource is reflected in the AutoCompleteComboBox''s dropdown. Please refer to its Form Load event handler below :
private void Form1_Load(object sender, System.EventArgs e)
{
this.oleDbDataAdapter1.Fill(this.dataSet11);
this.comboBoxAutoComplete1.AutoCompleteControl.DataSource = this.dataSet11.Tables[0];
this.comboBoxAutoComplete1.DisplayMember = "FirstName";
this.comboBoxAutoComplete1.AutoCompleteControl.Columns.Add(new AutoCompleteDataColumnInfo("EmployeeID", 20, true));
this.comboBoxAutoComplete1.AutoCompleteControl.Columns.Add(new AutoCompleteDataColumnInfo("LastName", 60, true));
this.comboBoxAutoComplete1.AutoCompleteControl.Columns.Add(new AutoCompleteDataColumnInfo("FirstName", 60, true));
:
:
:
this.comboBoxAutoComplete1.AutoCompleteControl.Columns.Add(new AutoCompleteDataColumnInfo("ReportsTo", 40, true));
this.comboBoxAutoComplete1.AutoCompleteControl.Columns[2].MatchingColumn = true;
this.comboBoxAutoComplete1.DataBindings.Add("Text", this.dataSet11.Tables[0], "FirstName");
}
Let me know if this sample meets your requirements. If not, kindly modify it to show the problem that you are facing and send it back to us. We appreciate your cooperation, and thanks for choosing Syncfusion products.
Regards,
Guru Patwal
Syncfusion, Inc.