ComboBoxAutoComplete data binding issue

[Subrata Das]

Hi,
In my Winform(C#) application I am using a "ComboBoxAutoComplete" control.

The problem that I am facing is that though I am binding the control with a DataTable which is residing inside a DataSet,when I run the screen the control does not show any data.But I have checked several times and found that DataTable contains data.

The code that I wrote is given below.

cmbRelationship1.AutoCompleteControl.DataSource = dsReptGrpDetl.Tables[0].DefaultView ;
cmbRelationship1.DisplayMember = "DISPLAY_NAME";
cmbRelationship1.ValueMember = "DISPLAY_ID";

Here,I want to mention one thing.I created the DataTable throgh code and added the same afterwards to the DataSet.

Can anybody pls solve my problem?

Thanks in advance.

Regards,
Subrata

[J.Nagarajan]

Hi Subrata ,

Thanks for your interest in Syncfusion products.

When the AutoCompleteCombobox is binding to the datatable it shows the data perfectly. Please refer to the attached sample that works fine in our latest version(v6.1.0.34).

http://websamples.syncfusion.com/samples/Tools.Windows/F71168/main.htm

Please refer to it and let me know if this helps.

Regards,
Nagaraj

[Subrata Das]

Hi Nagaraj,
Thanks for your reply.
I ran the small project that was provided by you.

It is showing "Ajay" as selected but the comboBox is not expanding when I click it.

Also pls let me know how to find out the version of Syncfusion in my system.

Waiting for your help!

Thanks & Regards,
Subrata Das

[J.Nagarajan]

Hi Subrata ,

The attached sample could databind the ComboBoxAutoComplete control to a database.

http://websamples.syncfusion.com/samples/Tools.Windows/F71168_Jan22/main.htm

You can know the current version of syncfusion from

Start->All Programs-> Syncfusion->Essential Studio 6.1.0.34

or

from the public assemblies folder(C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies)

Please let me know if you have any other questions.

Regards,
Nagaraj

[Subrata Das]

Hi,
Your code is working perfectly fine.But I fail to understand why my code is not running properly-the ComboBoxAutoComplete is not showing any data though there 66 records in the table are shown during debug.I am just pasting the code here:

DataTable XX = new DataTable();
DataColumn col0 = new DataColumn("Party_Id", System.Type.GetType("System.Int32"));
DataColumn col1 = new DataColumn("Display_Name", System.Type.GetType("System.String"));
DataColumn col2 = new DataColumn("Display_Id", System.Type.GetType("System.String"));
DataColumn col3 = new DataColumn("Superuser_Flag", System.Type.GetType("System.String"));

XX.Columns.Add(col0);
XX.Columns.Add(col1);
XX.Columns.Add(col2);
XX.Columns.Add(col3);

for (int i = 0; i < dsReptGrpDetl.Tables[0].Rows.Count; i++)
{
DataRow dr = null;
dr = XX.NewRow();
dr["Party_Id"] = dsReptGrpDetl.Tables[0].Rows[i]["Party_Id"];
dr["Display_Name"] = dsReptGrpDetl.Tables[0].Rows[i]["Display_Name"];
dr["Display_Id"] = dsReptGrpDetl.Tables[0].Rows[i]["Display_Id"];
dr["Superuser_Flag"] = dsReptGrpDetl.Tables[0].Rows[i]["Superuser_Flag"];
XX.Rows.Add(dr);
}
cmbRelationship1.AutoCompleteControl.DataSource = XX;
this.cmbRelationship1.AutoCompleteControl.SetAutoComplete(this.cmbRelationship1, Syncfusion.Windows.Forms.Tools.AutoCompleteModes.AutoSuggest);

Frankly,I am having very bad experience in using ComboBoxAutoComplete.

Pls let me know what my fault is.

Thanks & Regards,
Subrata Das

[Jeba S]

Hi Subtrata,

Sorry for the delay in response.

I have tested the above sample with the code snippets provided by you. It seems there is no rows in the XX Table. I have added a new Table for Table[0] and loaded the data into the XX Table from the New Table. Then I have assigned the datasource to the ComboBoxAutocomplete.

Please refer the sample and let us know if it helps.
http://websamples.syncfusion.com/samples/Tools.Windows/F71168New/main.htm

Regards,
Jeba.

[Subrata Das]

Hi Jeba,
You are correct.I was wrong.Thanks for correcting me.
Regards,
Subrata

[Jeba S]

Hi Subrata,

Thank you for your update.

Regards,
Jeba.

[dilip]

hi Subrata Das,

i think solution provided by nagrajan works fine enough. You should make use of his given source code.Hope that will help you out.

Thank you
Jitesh
[url=http://www.intelcs.com/].Net Consulting[/url]