Hi David,
While adding new row through the addnewrow in griddataboundgrid, you can set the hidden column value by handling the RowLeave event through the following code.
if (e.IsAddNew)
{
GridDataBoundGrid grid = sender as GridDataBoundGrid;
CurrencyManager cm = grid.BindingContext[grid.DataSource, grid.DataMember] as CurrencyManager;
int pos = grid.Binder.RowIndexToPosition(e.RowIndex);
DataRowView drv = cm.List[pos] as DataRowView;
drv["Department"] = "MECHANICAL";
}
This event get triggerred before RowSaved event get fired.
Here is the modified sample in which the above mentioned code has been implemented.
http://files.syncfusion.com/support/samples/Grid.Windows/7.4.0.15/F91165a.zipRegards,
Rajadurai