Last post Mar 02, 2018 08:25 AM by Fei Han - MSFT
Mar 01, 2018 02:50 PM|Chait|LINK
Am working on asp.net - C# web application(VS2012, Jquery, SQL 2012). Where I need to display charts like pie chart/bar chart using 10k or 20k database (SQL) rows.
These charts values will be changed based on the list box check/uncheck events. My question may be in broader sense but what should be my approach like Asp.net charts or Jquery charts or Angular/webapi or anything else.
Mar 01, 2018 02:55 PM|mgebhard|LINK
There is no answer to this question. Do a bit of research and pick a solution that fits your project. Perhaps make a few proof of concepts which is a fairly common thing to do in this situation.
Mar 02, 2018 08:25 AM|Fei Han - MSFT|LINK
My question may be in broader sense but what should be my approach like Asp.net charts or Jquery charts or Angular/webapi or anything else.
The answers to your question would be opinion-based, It is difficult to generate or share you a best or correct solution. To achieve your requirement: display data in charts with filter functionality, all of asp.net chart, jquery chart plugin or angular+webapi
(dynamically generate html for chart) are ok. As mgebhard mentioned, you can do some search & study and then choose a solution that fits your project and preference.
using 10k or 20k database (SQL) rows.
Besides, if you need to process large data set in your application, if possible, you can cache the data set instead of querying them from database every time.