Hi rani,

Refer the below articles. Using the first two link you can display the data in pivoted format and using the result you can display the result in gridview with the third link.

• Rotate GridView records using SQL Pivot in Query in ASP.Net
• Display dynamic Columns in GridView using Pivot function in ASP.Net
• GridView (Grid) with Paging in ASP.Net MVC

You can refer the below article to use storedprocedure in entity framework.

Entity Framework: Call Stored Procedure with Parameters using C# and VB.Net