I want to show pivot query data in jquery data table

I have a query generated from pivot , and i want to show the data in jquery data table but not able to do so.

public ActionResult LoadData()
{
using (DHIFeedbackEntities2 Ms = new DHIFeedbackEntities2())
{
//var summary = Ms.FeedBacks.SqlQuery("select * from [DHIFeedback].[dbo].[FeedBack]").ToList();
var summary = Ms.FeedBacks.SqlQuery(@"SELECT *
FROM
(
SELECT
YEAR([FeedBackDate])[Year],DATENAME(MONTH, [FeedBackDate])[Month],
COUNT(1)[FeedbackID]
FROM
[DHIFeedback].[dbo].[FeedBack]
GROUP BY
YEAR([FeedBackDate]
),
DATENAME(MONTH, [FeedBackDate])) AS Monthlyupdate
PIVOT(SUM([FeedbackID]) FOR Month IN([January],[February],[March],[April],[May],
[June],[July],[August],[September],[October],[November],[December])) AS MNamePivot
order by 1,2").ToList();
//foreach(var summ in data)
return Json(new { data = summary }, JsonRequestBehavior.AllowGet);
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

sunny kumar7y ago
Bro the problem arises in the query, It shows error
System.Data.Entity.Core.EntityCommandExecutionException: 'The data reader is incompatible with the specified 'DHIFeedbackModel.FeedBack'. A member of the type, 'FeedbackUserName', does not have a corresponding column in the data reader with the same name.'
0
Faisal Pathan7y ago
1. $('#tblTemplates').dataTable({
2. "destroy": true,
3. "bServerSide": true,
4. "lengthMenu": [[10, 25, 50, 100], [10, 25, 50, 100]],
5. "sAjaxSource": "/Controller/Action",
6. "bProcessing": true,
7. "autoWidth": false,
8. "aoColumns": [
9. { "sName": "Col1", "bSearchable": true, "bSortable": true }
10. , { "sName": "Col2", "bSearchable": true, "bSortable": true }
11. , { "sName": "Col3", "bSearchable": true, "bSortable": true }
12. , { "sName": "Col4", "bSearchable": true, "bSortable": true }
13. ] });
Try this, and if still problem please check/share your console it will help you.
0