How to insert columns as rows?

Question

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

Suthish Nair · Answer

Am not sure where is the problem. Do you want to create the o/ from SQL server itself or from web page?

srinivas P · Answer

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 Hobbs · Answer

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 Nair · Answer

What you say about our two thread replies?

srinivas P · Answer

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 Nair · Answer

select classid, stuName, Address from classtable c inner join studenttable s on c.classid = s.classid Then, use a DataList control and set the properties RepeatDirection="Horizontal".

Benjamin Kemner · Answer

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?

How to insert columns as rows?

Answers (7)