Problem conversion row to column

[hahaie]

Ok,problem not solved.thanks alot

[hahaie]

@priya

To maintain a record it is essential to take care of proper intersection of rows and columns

Your answer for me not understand

[hahaie]

please see:
http://www.c-sharpcorner.com/forums/my-procedure-not-have-output-in-c-sharp-for-datasoure-gridview

[hahaie]

I have another question about this problem.
I have this procedure:
ALTER Procedure [dbo].[test3] as Declare @Cols varchar(max), @Sql varchar(max) Set @Cols=('''''AS [a]'); print @cols Set @sql=' select 1 as[one], ' + @Cols exec (@Sql)

This procedure have records in Gridview C# but different with the above code and code below is a 'select' and code below no any record in Gridview C#!!
ALTER Procedure [dbo].[test3] as Declare @Cols varchar(max), @Sql varchar(max) Set @Cols=(Select '''''AS [a]'); print @cols Set @sql=' select 1 as[one], ' + @Cols exec (@Sql)

[hahaie]

@hahaie

ALTER Procedure [dbo].[Teeeest] As Declare @Cols varchar(max),@Sql varchar(max) Set @Cols=stuff((Select ',''''AS ' + quotename(Sec_Name) From Tb_Section Where Sec_Base = 1 For xml path('')), 1, 1, ''); Set @Sql = 'Select Sec_Name,' + @Cols + 'From Tb_Section Where Sec_Base = 0 Order by Sec_Name' exec (@Sql)

How to be above Code with 'Pivot'?

[khtan]

@hahaie

How to be above Code with 'Pivot'?

i have posted the PIVOT query 3 days ago here