Kristian Kretschmer
Top achievements
Rank 1
Rank 1
Kristian Kretschmer
asked on 23 May 2011, 02:28 PM
Hi,
I get via LINQ this data structur from a SQL Server:
Count Product Date
As you can see I want to group my products by the the same date to visualize how many different products are counted on this day.
I want this to show as a line chart.
I attached a file with a image of what i mean.
How can I do this programmatically?
I get via LINQ this data structur from a SQL Server:
Count Product Date
| 1 | Product1 | 03.11.2009 |
| 2 | Product1 | 04.11.2009 |
| 1 | Product2 | 04.11.2009 |
| 3 | Product1 | 05.11.2009 |
| 1 | Product2 | 05.11.2009 |
| 1 | Product3 | 05.11.2009 |
| 3 | Product1 | 06.11.2009 |
As you can see I want to group my products by the the same date to visualize how many different products are counted on this day.
I want this to show as a line chart.
I attached a file with a image of what i mean.
How can I do this programmatically?
1 Answer, 1 is accepted
0
Hi Kristian,
You can find attached a small example, showing how to achieve this chart. It is based on this help article. Note that RadChart does not support directly DateTime values, but their OLEAutomation equivalents. You can use the DateTime.ToOADate() method to calculate these values as shown in the example.
Best regards,
Ves
the Telerik team
You can find attached a small example, showing how to achieve this chart. It is based on this help article. Note that RadChart does not support directly DateTime values, but their OLEAutomation equivalents. You can use the DateTime.ToOADate() method to calculate these values as shown in the example.
Best regards,
Ves
the Telerik team
Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.