This has been working for we well until I have introduced two new comboboxes which datasource is loaded during the same event QueryCellStyleInfo. Since then when I select column with this combobox the Group header formating changes to default. below is the code: if you need my project code let me know.
private void gridGroupingControlAll_QueryCellStyleInfo(object sender, GridTableCellStyleInfoEventArgs e)
{
if (e.TableCellIdentity == null)
return;
//select datasource for the Major code comboboxes
if (e.TableCellIdentity.Column != null && e.TableCellIdentity.Column.Name == "EstDataMajor"
&& e.TableCellIdentity.DisplayElement.Kind == Syncfusion.Grouping.DisplayElementKind.Record)
{
// Gets the value selected from the combobox.
string divisionID = e.TableCellIdentity.DisplayElement.GetRecord().GetValue("EstDataDivision").ToString();
string Fillquerry = "SELECT MajorID, CONCAT(RTRIM(MajorID), ' - ',RTRIM(MajorDescription)) AS Description FROM dbo.CodeMajor WHERE DivisionID='" + divisionID + "'";
DataTable MajorDT = Dbo.ReturnDataTable(Fillquerry, Properties.Settings.Default.DBConnString);
e.Style.DataSource = MajorDT;
e.Style.DisplayMember = "Description";
e.Style.ValueMember = "MajorID";
}
//select datasource for the Minor code comboboxes
if (e.TableCellIdentity.Column != null && e.TableCellIdentity.Column.Name == "EstDataMinor"
&& e.TableCellIdentity.DisplayElement.Kind == Syncfusion.Grouping.DisplayElementKind.Record)
{
// Gets the value selected from the combobox.
string majorID = e.TableCellIdentity.DisplayElement.GetRecord().GetValue("EstDataMajor").ToString();
string Fillquerry = "SELECT MinorID, CONCAT(RTRIM(MinorID), ' - ',RTRIM(MinorDecription)) AS Description FROM dbo.CodeMinor WHERE MajorID='" + majorID + "'";
DataTable MinorDT = Dbo.ReturnDataTable(Fillquerry, Properties.Settings.Default.DBConnString);
e.Style.DataSource = MinorDT;
e.Style.DisplayMember = "Description";
e.Style.ValueMember = "MinorID";
}
//Display grouping name
if (e.TableCellIdentity.TableCellType == GridTableCellType.GroupCaptionCell && e.TableCellIdentity.GroupedColumn != null)
{
var style = this.gridGroupingControlAll.TableDescriptor.Columns[e.TableCellIdentity.GroupedColumn.Name].Appearance.AnyRecordFieldCell;
if (style != null)
{
var data = style.DataSource as DataTable;
if (data != null)
{
var row = data.Select("[" + style.ValueMember + "] = '" + e.TableCellIdentity.DisplayElement.ParentGroup.Category + "'");
if (row != null && row.Length > 0)
{
string displayMember = row[0][style.DisplayMember].ToString();
e.Style.CellValue = String.Format("{0}-{1} items", displayMember, e.TableCellIdentity.DisplayElement.ParentGroup.GetChildCount());
}
}
}
}
}
