How can I access the current record in the ggc and/or in the underlying datatable from TableControlCurrentCellValidating?

[James Blibo]

Firstly, is this the right event to use when validating cell input and wanting to cancel if validation fails?

How can I access the GridRecord?


How can I access the DataRow of the underlying datatable?

[James Blibo]

found it... never mind

[James Blibo]

I can not get the DataRowView from the Record in the TableControlCurrentCellValidating.

Record rec = e.TableControl.Table.CurrentRecord;
DataRowView drv = rec.GetData() as DataRowView;

Please help! DataRowView is null!

[Administrator]

Hi James,

Please refer to the following sample which demonstrates the retrieving of the DataRowView of the currently edited record using your code snippet. Please check whether the editing row is being Record display kind. Which version of the grid are using?

Sample: GGC_CurrentCellValidating.zip

Kindly try it and let us know if you need any further assistance.
Have a nice day.

Best regards,
Madhan

[James Blibo]

This is the same code that I posted and said wasn't working. DataRowView is always null.

I have a flat datasource that is grouped by one column. The version of the grid is 4.4

[Administrator]

Hi James,

Thank you for being patience.

We tried using your code snippet to reproduce the issue here. The reason for the DataRowView being null is because the resultant of the rec.GetData() method is DataRow. Please try using the following code snippet to retrieve the data.

>>>>>>>>>>>>
// TableControlCurrentCellValidating event
Record rec = e.TableControl.Table.CurrentRecord;
DataRow dr = rec.GetData() as DataRow;
Console.WriteLine(dr[0]);
>>>>>>>>>>>>

Kindly let us know if you need any further assistance.

Best regards,
Madhan