concatenate two columns in a DataTable

[Guest]

Hi
I have a DataTable and I would lika to concatenate two columns so that can
dispaly this new column in a DropDown box. (Firstname and Lastname). How can
I do this?

Thanks
Julia

 

[Cor Ligthert [MVP]]

Julia,

Just add a new column with an expression to your table and use that one..

http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx

I hope this helps,

Cor

 

[Guest]

Hi
and thanks for the answer. I have been looking at this page alreadey but I
dont understand how to do to concatenate two columns of strings? At this page
I only see example of how to add numbers together. If you have an example it
would be really helpful to me.

Thanks
Julia

 

[Cor Ligthert [MVP]]

Julia,

It is so simple that I forgot that we have a sample for this on our website.

http://www.vb-tips.com/default.aspx?ID=e8fee3e3-3ca7-4bb0-81dc-f0b560f43e7c

I hope this helps,

Cor