Click here to Skip to main content
15,938,218 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi,

I need to display some details in detail view in that one field is Address.
Address field saved in Sql as Address1,Address2,Country,Postalcode.How do i combine all this value to detailsviews Address field.Please help.

Thanks.
Posted

You can concate those columns as single column in select query

like select Field1,Address1+' '+Address2+' '+Country+' '+Postalcode as FullAddress
 
Share this answer
 
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900