how to display all column values as a row

Posted 3 Jan '13 - 4:38

Member 9330747181

Edited 3 Jan '13 - 5:34

Aarti Meswania20.1K

Solution 1

Hi,
i'm not sure if this is the best approach but you can:

- fill a datatableobject in c# with a

SELECT * FROM myTable

and the DataAdapter. http://msdn.microsoft.com/de-de/library/bh8kx08z%28v=vs.80%29.aspx[^]

- then i would make a list for each column and fill them with the entrys of each row.

- Otherwise, if you want to have a DataTable as result, your can use a doubled foreach loop to handle stuff like this. Or you have a look at:

Transpose a DataTable using C#[^]

hope this helps.

Permalink

Posted 3 Jan '13 - 5:10

ChrisTopherus369

Solution 2

check it out here:
http://sql-tricks.blogspot.com/2011/04/sql-server-rows-transpose.html[^]

Permalink

Posted 3 Jan '13 - 5:32

sankasuresh472

Solution 3

Hi

You can use from bellow code:

Declare		@ID		nVarChar(500),
		@Name		nVarChar(500),
		@Department	nVarChar(500)
-------------------------------------------------------------------------------
Select	@ID		= N'',
	@Name		= N'',
	@DepartMent	= N''	
------------------------------------------------------------------------------
Select	@ID		= @ID		+ ', ' + Cast(ID As VarChar),
	@Name		= @Name		+ ', ' + Name,
	@Department	= @Department	+ ', ' + Department 
	From	[YourTableName]
-------------------------------------------------------------------------------
Select	@ID		= Substring(@ID, 2, Len(@ID)),
	@Name		= Substring(@Name, 2, Len(@Name)),
	@Department	= Substring(@Department, 2, Len(@Department))
-------------------------------------------------------------------------------
Select	N'ID', @ID
Union
Select	N'Name', @Name
Union
Select	N'Department',@Department

If you want using this action dynamically, please tell me to write dynamic version for you.

I hope it's helpful

Permalink

Posted 3 Jan '13 - 7:12

Reza Alipour Fard918

Edited 3 Jan '13 - 7:13

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

0	Sergey Alexandrovich Kryukov	496
1	Mahesh Bailwal	342
2	Maciej Los	228
3	Aarti Meswania	215
4	Arun Vasu	174

0	Sergey Alexandrovich Kryukov	9,607
1	OriginalGriff	7,214
2	CPallini	3,943
3	Rohan Leuva	3,261
4	Maciej Los	2,758

how to display all column values as a row

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

		9,888,870 members (44,463 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using

Interested
Ignored

how to display all column values as a row

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us