How to insert columns as rows?

srinivas P

15y1.9k

Hi, to all

I have two tables

Example: class table

ClassId	Cassname
1	10th class

student table

classid	stuName	Address
1	xyz	hyd
1	abc	hyd
1	pqr	hyd

Now my requirement is i want to insert data following way

classid	stName	Address	stuName	address		stuname		address
1	xyz	hyd	abc	hyd		pqr		hyd

i want to display multiple columns data in single row
please help me

Thanks inadvance

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
Am not sure where is the problem. Do you want to create the o/ from SQL server itself or from web page?
srinivas P15y ago
Thanks for your reply, when i was used the datalist.in this data displied columns as rows.but my requirement is add the 'student' table to Class table,all these will insert as single row.
Sam Hobbs15y ago
Did you get Suthish's point? I am not sure, but it is very probable that Suthish understands and his suggestion to use a DataList control will work. If you need help with that, then ask about it instead of assuming it won't work. Or another way of saying it is that if you think it won't work then explain why you think it won't.
Suthish Nair15y ago
What you say about our two thread replies?
srinivas P15y ago
Actually i have two tables,Registration and partydetails. in Registration table i have one row for particular Id.But for the same Id having multiple partycodes. so,i want to show all registration,partydetails in one Row.

Partydetailes are in partydetais table

Are you got my point?
Suthish Nair15y ago
select
classid, stuName, Address
from classtablec inner join studenttable s
on c.classid = s.classid

Then, use a DataList control and set the properties RepeatDirection="Horizontal".
Benjamin Kemner15y ago
What's the reason to produce the data "column based" and not in rows like a SQL database do?

I think you can not do it exactly in that way you want. But there is the possibility to create a list procedure to create one column with the row data like this:

classid
stunameAndAdress
1
xyz,hyd,abc,hyd,pqr,hyd

Ist this a way for you?

classid	stunameAndAdress
1	xyz,hyd,abc,hyd,pqr,hyd