如何在gridview中将行reocrds显示为列 [英] How to display row reocrds as columns in gridview

问题描述

亲爱的朋友们，



我在gridview中有小代码，从数据库中恢复数据。



现在db记录是，



EmpId EmpName EmpAddress

- ----------------------

1. Raju Ban

2. Ravi Hyd

3. Ram Ban

4. Radha Hyd

5. Rajesh妈妈





现在我要显示记录为，



Raju Ravi Ram

Ban Hyd Ban





Radha Rajesh

Hyd妈妈





请任何人帮助我。我正在使用波纹管代码。在此先感谢。



< asp：TemplateField ItemStyle-VerticalAlign =Top>



< asp：Label ID =Label1runat =serverText ='<％＃Eval（EmpName）++ Eval（EmpAddress）％>'>

Dear Friends,

I have small code in gridview, data retriving from database.

Now db records are,

EmpId EmpName EmpAddress
------------------------
1. Raju Ban
2. Ravi Hyd
3. Ram Ban
4. Radha Hyd
5. Rajesh Mum


Now i want to display records as,

Raju Ravi Ram
Ban Hyd Ban


Radha Rajesh
Hyd Mum


please can any one help me. I am using bellow code. Thanks in advance.

<asp:TemplateField ItemStyle-VerticalAlign="Top" >

<asp:Label ID="Label1" runat="server" Text='<%# Eval("EmpName")+""+Eval("EmpAddress") %>'>

推荐答案

您好，



您使用的是哪个数据库？为什么不在表上使用pivot并通过编写存储过程或其他东西从数据库本身获取所需的数据。它将满足您的需求并且更简单。



尝试以下链接：

http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot -table-examples / [ ^ ]



http://technet.microsoft.com/en-in/library/ms177410%28v=sql.105%29.aspx [ ^ ]



希望这会有所帮助。 :)



问候，

Praneet

Hi,

Which database are you using ? Why dont you use pivot on the table and get the desired data from database itself by writing a stored proc or something. It will cater your needs and will be simpler.

Try these links :
http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/[^]

http://technet.microsoft.com/en-in/library/ms177410%28v=sql.105%29.aspx[^]

Hope this helps. :)

Regards,
Praneet

这篇关于如何在gridview中将行reocrds显示为列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！