I am using SQL Server 2012 and VS 2012 C# I have designed database table Roll_No, Attend_Date, Attend_Status while storing data i store like this But I have to show in grid-view like this Can you Help me please… How can I achieve this result.. Answer You can do this by listing each date as column name while doing PIVOT
Tag: c#-4.0
How to use the group join result to join another tables using LINQ?
I am not able to use the result of group join and then further applying the join with other tables. My SQL query is : and what I have done so far is: but now this result is not at all further used by me to create a join with other tables. I want to ask how to join further?