GridGroupingControl: Unhandled exception in control.

[Administrator]

Hello.

This can be simply repeated by samples provided with suite.

Using Essential Grid Samples
Custom Summary sample.
Start to fill new row and specify values only for first 2 columns, then press header (as to resort by column), message about NULLs not alowed appears, then press column second time. Exception occures:

************** Exception Text **************
System.InvalidCastException: Object cannot be cast from DBNull to other types.
at System.DBNull.System.IConvertible.ToDouble(IFormatProvider provider)
at System.Convert.ToDouble(Object value)
at CustomSummary.Form1.Table_QueryCustomCount(Object sender, CustomCountEventArgs e)
at Syncfusion.Grouping.Table.OnQueryCustomCount(CustomCountEventArgs e)
at Syncfusion.Grouping.Record.GetCustomCount()

[Administrator]

By the way, how to disable the feature (header sorting) for whole control.

[Administrator]

Hi Vadim,

thanks for reporting the problem with the exception when clicking twice on the column header. This is a bug and we''ll get that fixed.

Regarding the question how to disable clicking on the column header try this:

this.gridGroupingControl1.TableControlCellClick += new GridTableControlCellClickEventHandler(gridGroupingControl1_TableControlCellClick);

private void gridGroupingControl1_TableControlCellClick(object sender, GridTableControlCellClickEventArgs e)
{
	Element el = e.TableControl.Table.DisplayElements[e.Inner.RowIndex];
	if (el is ColumnHeaderRow)
		e.Inner.Cancel = true;
}