Add/Edit Columns in DataBound DataGridView

Question

I've got a datagridview that is databound from a database table. How do I:

a) Edit the displayed value for a column using the values from other columns in the row? (For example, display a URL like:

    <a href="/url?param=columnA">columnB</a>

where columnA is the value from column A and columnB is the value from columnB)

b) Add an additional column using values from the other columns (similar to a.)

Answer 1

You could add a DataColumn that uses an Expression to the DataTable.

Answer 2

You didn't mention what you've already tried, but for a) you could try DataGridView.CellFormatting event, for b) How to: Add an Unbound Column to a Data-Bound Windows Forms DataGridView Control