Getting user edited Text of sfDataGrid GridComboBoxColumn

[T]

Hi,

I have a SfDataGrid with GridComboBoxColumn, DropDownStyle.DropDown and AutoCompleteMode.Suggest. If user enters some text that is not in the list currently, I want to be able to save the new text, preferrably in sfDataGrid.CurrentCellValidating.

I'm sorry if I miss the obvious, but how it is possible to access the user entered text? The only way I found is using custom cell renderer and passing data using TableControl.Text property, but this property seems to be empty on CurrentCellValidating event. Is there a better way?

private void sfDataGrid_CurrentCellEndEdit(object sender, CurrentCellEndEditEventArgs e)

{

if (e.DataColumn.GridColumn.MappingName == "MyColumn")

{

var userText = (e.OriginalSender as SfDataGrid)?.TableControl.Text;

}

}

public class MyGridComboBoxCellRenderer : GridComboBoxCellRenderer

{

protected override void OnEditingComplete(DataColumnBase column, SfComboBox currentRendererElement)

{ 

if (column.GridColumn.MappingName == "MyColumn")

{

var userText = column?.GridColumn?.Renderer?.CurrentCellRendererElement?.Text.Trim();

if (userText?.Length > 0)

TableControl.Text = userText;

}

base.OnEditingComplete(column, currentRendererElement);

}

}

[Mohanram Anbukkarasu]

Hi Tipal, 

Thanks for contacting Syncfusion support. 

You can get the text entered in the ComboBox column by using the CurrentCellRendererElement within the CurrentCellValidating event. Please refer to the below code example and sample from the given location. 

 

Code Example: 

this.sfDataGrid1.CurrentCellValidating += sfDataGrid1_CurrentCellValidating; 

 

void sfDataGrid1_CurrentCellValidating(object sender, CurrentCellValidatingEventArgs e) 

{ 

    var userText = string.Empty; 

    if (e.Column.MappingName == "ShipCityID" && this.sfDataGrid1.CurrentCell.CellRenderer.CurrentCellRendererElement != null) 

        userText = this.sfDataGrid1.CurrentCell.CellRenderer.CurrentCellRendererElement.Text; 

} 

Sample Location: http://www.syncfusion.com/downloads/support/directtrac/general/ze/ComboBoxColumn_CurrentCellValidating1598774164  

 

Regards, 

Mohanram A. 

[T]

Thank you very much, that's really helpful!

[Mohanram Anbukkarasu]

Hi Tipal,  

Thanks for your update. 

We are glad to know that the given solution has resolved your query. Please let us know, If you need any further assistance. 

Regards, 

Mohanram A.