Building Pie Chart LinQ C#

Esther Marks

5y968LINQ

Hello everybody,

I've surfed a lot to find an awnser but failed every time, so hopefully anybody can help me.

I'm using LinQ in combi with C# and i want to build a pie chart.

Normall a Report will be like this:

There will be 2 columns (Name test,Total Test and Amount)

There will be a lot of data in the rows.

How can I transfer these columns into a pie chart.

Kind Regards,

Esther

Name Test

Total Tests

Total Amount

from record in Tests

where

record.TestId >= 1 &&

record.TestTasks.Count==0

group record by new {record.Name,record.Status} into sg

select new

{

sg.Key.Status,

c=sg.Count(),

c2=sg.Count() * 16,

sg.Key.Name,

};

]]>

3 Replies

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

Amit Gupta5y ago
Accepted answer
Linq is not used to create graphics like charts, it is used to manipulate data. You can use RDLC report to build variety of charts including pie chart too. Surf the net for it to know more.
Rijwan Ansari5y ago
Linq is used for data manupulation and getting data from reports. However, chatjs or chart helper can used for graph and reports.

Check this link:
https://docs.microsoft.com/en-us/aspnet/web-pages/overview/data/7-displaying-data-in-a-chart

Also
Chart.js | Open source HTML5 Charts for your website

Regards
Rijwan
Esther Marks5y ago
Thank you! that's why a can't find anythink about it. I'll search for RDLC. Thanks!