mapping 2 datatable columns to one datagrid column

[Guest]

Is this possible? I want to concatenate two columns in my table and display
them in one datagrid column. I have a TableStyle where I create
DataGridColumnStyle's. I'd like to set the MappingName to two columns but I
dont see how this can be done.

Thanks.

 

[Sahil Malik]

You can add a column, and set the expression on it to get the value you
need.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

 

[Guest]

Im not sure I follow you. I want to know if I can do this with TableStyles
and DataGridColumnStyles.
I use a DataAdapter to fill my DataSet then set the TableStyle as follows:
I dont see how I can set the MappingName to 2 column names.
DataGridTableStyle ts1 = new DataGridTableStyle();

ts1.MappingName= "table";

DataGridColumnStyle textColName = new DataGridTextBoxColumn();
textColName.MappingName = ???????
textColName.HeaderText = "Work";
textColName.Width = 50;
textColName.NullText = "";
ts1.GridColumnStyles.Add(textColName);