Merge two columns

[Alberto del Barrio]

Hi all,

Is there a way I can merge two columns from my datasource into a single column in a databound grid?

TIA

[Administrator]

You can override QueryCellInfo and there provide the cell information for that specific column. If QueryCellInfo does not fit your needs then try DataProviderQueryCellInfo and don't forget to set e.Handled =true;

The difference betwen those two events is:

DataProviderQueryCellInfo is called before GridModelDataBinder.QueryCellInfo gets the data from the underlying datasource and initializes the style object.

QueryCellInfo is called after that. So depending on your situation one or the other might fit better.

If you need to hide the other column you can do that with Model.HideCols.

Stefan

[Alberto del Barrio]

But you mean I override that methods or just add an event handler to the corresponding event?

[Administrator]

Event handler is fine.
Stefan

[Gene Gorokhovsky]

You can also dynamically add an expression column to your table (DataTable.Columns.Add) and bind grid column to it. Of course the resulting data will be read-only.

Gene
> Hi all,
>
> Is there a way I can merge two columns from my datasource into a single column in a databound grid?
>
> TIA
>