DropDownAutocomplete in grid grouping

[jorge durban]

I cant make this work!
In page load:

this.GridGroupingControl1.TableDescriptor.Columns[2].Appearance.AnyRecordFieldCell.CellType = GridCellTypeName.ComboBox;
this.GridGroupingControl1.TableDescriptor.Columns[2].Appearance.AnyRecordFieldCell.ShowButtons = GridShowButtons.ShowCurrentCell;
this.GridGroupingControl1.TableDescriptor.Columns[2].Appearance.AnyRecordFieldCell.DataSource = this.VVenuesDataSource1;
// this.GridGroupingControl1.TableDescriptor.Columns[2].Appearance.AnyRecordFieldCell.ChoiceList = this.VVenuesDataSource1;

this.GridGroupingControl1.TableDescriptor.Columns[2].Appearance.AnyRecordFieldCell.DisplayMember = "Name";
this.GridGroupingControl1.TableDescriptor.Columns[2].Appearance.AnyRecordFieldCell.ValueMember = "VenueId";
this.GridGroupingControl1.TableDescriptor.Columns[2].Appearance.AnyRecordFieldCell.DropDownStyle = GridDropDownStyle.AutoComplete;

Drop down isnt editable! autocomplete doesnt work! PLEASE HELP Im in hurry

[Ranjithkumar R G]

Hi Jorge,

Thanks for using Syncfusion products.

We are sorry for inconvenience caused. We are unable to reproduce the issue. We have prepared a simple sample and the same can be downloaded from the following link.

http://www.syncfusion.com/uploads/redirect.aspx?&team=support&file=sample-combo-401667857.zip

Could you please try the above sample and get back to us whether you are able to reproduce the issue? If not, could you please give more information or by reproducing the issue in the above sample so that we could sort out the issue and provide you with solution.The information provided would be of great help in resolving the issue.

Please let us know if any concerns.

Regards,
Ranjithkumar.

[jorge durban]

Sorry In your sample combobox is not editable too. Like in mine...
Thanks in advance.

[jorge durban]

I need a cell that:

[jorge durban]

I need a cell that: allow user to edit, shows a drop down, and autocompletes when user type text...
Is this not possible? Thanks in advance

[jorge durban]

I need a cell that: allow user to edit, shows a drop down, and autocompletes when user type text...
Is this not possible? Thanks in advance

[Ranjithkumar R G]

Hi Jorge,


Thanks for using Syncfusion products.

Your requirement of displaying autocomplete dropdown can be achieved by adding the autocompletetextbox as a itemtemplate of a column.Please refer to the code-snippet below.

[ASPX]

                        
                            
                                            IntiallyShown="false" 
            onprovidechoicelistoncallback="AutoCompleteTextBox1_ProvideChoiceListOnCallback" >
                            
                        




The Autocomplete textbox can be binded to a SqlDataSource in the ProvideChoiceListOnCallback event of the AutocompleteTextbox. An ArrayList can be populated with autocomplete suggestions got from the returned DataView as a result of executing Select() method. The ArrayList can be used as a ChoiceList to populate the Autocomplete Suggestions. Kindly refer the code snippet below to achieve this.

[C#]

 protected void AutoCompleteTextBox1_ProvideChoiceListOnCallback(object sender, Syncfusion.Web.UI.WebControls.Tools.ACUserChoiceListEventArgs e)
    {
        ArrayList userChoiceList = new ArrayList(); 
         SqlDataSource SQLds = new SqlDataSource();
         SQLds.ID = "SqlDataSource2";
          SQLds.ConnectionString = ConfigurationManager.ConnectionStrings["HierarchyDataConnectionString"].ConnectionString;
          SQLds.SelectCommand = "SELECT [Controls] FROM [AutoComplete]";
          DataView dv = (DataView)SQLds.Select(DataSourceSelectArguments.Empty);
          foreach (DataRow myRow in dv.Table.Rows)
          {
              userChoiceList.Add(myRow["Controls"].ToString());
          }
          e.ChoiceList = userChoiceList;
    }


Also I have created a simple sample to test this and it can be downloaded from the link below.

http://www.syncfusion.com/uploads/redirect.aspx?&team=support&file=sample-combo (2)-1332887567.zip

Kindly try the above sample and please let me know if you have any other queries.

Regards,
Ranjithkumar.