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 tableall 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 tablesRegistration and partydetails. in Registration table i have one row for particular Id.But for the same Id having multiple partycodes. soi want to show all registrationpartydetails 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 xyzhydabchydpqrhyd Ist this a way for you?

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