I have a datagrid(Windows) which is bound to a BindingSource.

The columns in the bindingsource are "Name", "Part", "Part1", "Part2".
Part will always have an entry.
If Part1 and Part2 contain anything then I need to concatenate them to Part.

Normally I would just do this in sql or loop through a datatable before binding and do it that way but alas I am not allowed to touch these.
I must either loopthrough the BindingSource and perform the concatenation there before binding OR do the checks and concatenation in the Windows grid. Sadly the windows grid does not have a rowbound event so I have no idea how to progress.

Anyone have any suggestions?