Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
convert rows to clumns
well, the query takes a bit long to execute, so I have been told by my manager to try LINQ[surprise]- Nihir
- Post #10
- Forum: Microsoft: ASP.NET
-
convert rows to clumns
@jmeckley: Using your method I can do this and it works fine. Can you by any chance please help me use Linq doing exact samething as below var variableHeaders = data.Tables[0].AsEnumerable() .Select(row => row["RelevantPeriod"].ToString()) .Distinct()...- Nihir
- Post #8
- Forum: Microsoft: ASP.NET
-
convert rows to clumns
this does help me a bit. But I dont have new created columns. var found = pivot.Select("[fixed_column_1]=" + row["the_fixed_column"]).FirstOrDefault(); fails as my pivot table is empty. so how will i have my all columns..- Nihir
- Post #7
- Forum: Microsoft: ASP.NET
-
convert rows to clumns
I cannot use sql server for this. @jmickey: can you please give me some sample code..- Nihir
- Post #4
- Forum: Microsoft: ASP.NET
-
convert rows to clumns
I have a grid in dataset as following UserPatientStatusID RelevantPeriod TotalCount ProviderSpecialtyServiceName a OUT November2008 1 Not Available a ER September2008 1986 Not Available a ER April2009 1837 Not Available a ER...- Nihir
- Thread
- Replies: 10
- Forum: Microsoft: ASP.NET
