如何在GridView上将多个列合并为一个列？ [英] How to Merge Multiple columns into a single column on GridView?

问题描述

如何将多列合并为单个列绑定到GridView？

< asp：BoundField DataField =Address1HeaderText =Address1>

< ; asp：BoundField DataField =Address2HeaderText =Address2>

< asp：BoundField DataField =Address3HeaderText =Address3>



我希望将这三个字段显示为网格视图上的单个（地址1）字段

我将如何显示



ID名称地址1

1 xxx美国，

英国，

阿联酋

2 yyy印度，

UK，

US





请任何人帮我解决这个问题。 。

解决方案

我只是改变select语句并将所有列别名化为一个连接。



它看起来像这样：

选择[column1 ++ column2 ++ column3]作为columnHeader From Tab le_Name 

How to Merge Multiple columns into a single column bind to GridView?
<asp:BoundField DataField="Address1" HeaderText="Address1">
<asp:BoundField DataField="Address2" HeaderText="Address2">
<asp:BoundField DataField="Address3" HeaderText="Address3">

Iwant to show these three fields as single(Address1) field on Grid view
how will i show

ID Name Address1
1 xxx US,
UK,
UAE
2 yyy India,
UK,
US


Please Can any one Help me How to solve this..

解决方案

I would just alter the select statement and alias all the columns into one with concatenation.

It would look something like this:

Select [column1 + " " + column2 + " " + column3] as columnHeader From Table_Name

这篇关于如何在GridView上将多个列合并为一个列？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！