How to display Records which is Columns as Rows in Gridview

Posted by Somasundaram under ASP.NET on 4/14/2012 | Points: 10 | Views : 1352 | Status : [Member] | Replies : 5
Hi I need to display records in Gridview such that
my input Table is as follows,

Empcode Grade Year
Temp A 2009-10
Temp B 2010-11
Temp C 2011-12

And my Output should be as

Empcode 2009-10 2010-11 2011-12
Temp A B C

Pls Give me a solution as early as possible..
Thanks in Advance...




Responses

Posted by: Hariinakoti on: 4/14/2012 [Member] Starter | Points: 25

Up
0
Down
r u stored in database?

Thanks & Regards
Hari

Somasundaram, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Hariinakoti on: 4/14/2012 [Member] Starter | Points: 25

Up
0
Down
can you provide ur code here?

Thanks & Regards
Hari

Somasundaram, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Somasundaram on: 4/14/2012 [Member] Starter | Points: 25

Up
0
Down

These are values which are stored in Database:

Empcode, Grade, Year(Column names)
(Temp, A, 2009-10)
(Temp B 2010-11 )
(Temp C 2011-12 )

I dont have Idea pls provide me code..




Somasundaram, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Akki324 on: 4/14/2012 [Member] Starter | Points: 25

Up
0
Down
U SHOULD HAVE TO FETCH THE RECORD FROM YOUR DATABASE (SQL SERVER) FROM YOUR GRID VIEW SQLDATASOUCE......

Somasundaram, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Somasundaram on: 4/14/2012 [Member] Starter | Points: 25

Up
0
Down
thats what how to fetch through sql query...

if you know pls tel me..

Somasundaram, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response