Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET
Hai
 
how to merge two columns in a single datatable and explain datatable customization..
 
thanks in advance
Posted 30-Apr-13 0:45am
Comments
Rabbil at 30-Apr-13 6:15am
   
expalin more about ur requirement....??
CHill60 at 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
ryanb31 at 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: bad
good
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
  Permalink  
v2
Comments
CHill60 at 30-Apr-13 8:47am
   
My +5 ... I learned something new today. Thank you.
rk_prabakar at 30-Apr-13 8:49am
   
Cooooool!!!
Rate this: bad
good
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
  Permalink  

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



Advertise | Privacy | Mobile
Web01 | 2.8.1411022.1 | Last Updated 30 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

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