Derived Columns

[Mark H]

If I have a data source delivering columns A, B and C and I want to have the grid display two columns, the first with the contents of A and the second with some function of B & C (assume not achievable via plain SQL), do I have to create invisible gridboundcolumns for B & C and a new gridboundcolumn D and then set D = fn(B,C) etc in the grid's ItemDataBound event? Is this better than referencing the underlying data set in that event? Can anyone point me at some examples of this?

Thanks,
M

[Mark H]

Ah I now see to pull this stuff from the associated DataRowView via the DataItem property of the GridDataItem

M