Click here to Skip to main content
14,635,966 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hai

how to merge two columns in a single datatable and explain datatable customization..

thanks in advance
Posted
Comments
Rabbil 30-Apr-13 6:15am
   
expalin more about ur requirement....??
CHill60 30-Apr-13 6:43am
   
Your question is not clear. Please use the Improve question link to give further details of the problem you are experiencing
ZurdoDev 30-Apr-13 7:02am
   
Is this homework? If so, doesn't your text have the answer? If not please be more clear on what you need.
Rate this:
Please Sign up or sign in to vote.

Solution 2

Hi Swetha,

I hope this link would help you a bit.

Concatenating two string columns in a DataTable

Regards,
RK
   
v2
Comments
CHill60 30-Apr-13 8:47am
   
My +5 ... I learned something new today. Thank you.
♥…ЯҠ…♥ 30-Apr-13 8:49am
   
Cooooool!!!
Rate this:
Please Sign up or sign in to vote.

Solution 1

In Select Statement you can do it Like that. if not Please Improve your Question

Select Column1 + ' ' + Column2 as NewColumn from table 


result would be like
__________________________
NewColumn
--------------------------
Column1Text Column2Text
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100