如何过滤MS-DB并在C＃中绘制图表？ [英] How to filter MS-DB and plot a chart in C#?

问题描述

我有这样的数据库：

T0 T1 T2

main_1 subcategory_1 Reason_1

main_2 subcategory_2 Reason_2

main_3 subcategory_3 Reason_3

main_4 subcategory_4 Reason_4

main_5 subcategory_2 Reason_4

main_1 subcategory_3 Reason_3

main_2 subcategory_2 Reason_2

main_1 subcategory_3 Reason_2

main_2 subcategory_3 Reason_3





我想画一个馅饼有main_1个子类别的图表。还为Main_1绘制饼图 - > subategory_1总共有原因



我尝试过：



我试过了

 foreach（在SELECT_TABLENAME中的var项目）
 {
 
 if（item.Contains（All_Red_Events））
 {
 
 foreach（EventCategories中的var iteam1）
 {
 foreach（SubEventCategories中的var iteam2）
 {
 OleDbCommand cmd6 = new OleDbCommand（ ）; 
 OleDbDataReader reader2 = null; 
 cmd6 =新的OleDbCommand（select [T2] FROM+ item.ToString（）+WHERE（[T0] ='+ iteam1.ToString（）+'+and+[T1 ] ='+ iteam2.ToString（）+'）+，connection2）; 
 reader2 = cmd6.ExecuteReader（）; 
 
 while（reader2.Read（））
 {
 
 Subcategoriesreason.Add（reader2 [T0]。ToString（））; 
} 
} 
} 
} 
 

解决方案

Power BI Desktop | Microsoft Power BI [ ^ ]

I have a database like this:
T0 T1 T2
main_1 subcategory_1 Reason_1
main_2 subcategory_2 Reason_2
main_3 subcategory_3 Reason_3
main_4 subcategory_4 Reason_4
main_5 subcategory_2 Reason_4
main_1 subcategory_3 Reason_3
main_2 subcategory_2 Reason_2
main_1 subcategory_3 Reason_2
main_2 subcategory_3 Reason_3


I want to draw a pie chart for main_1 total subcategories are there. also draw a pie chart for Main_1 -> subcategory_1 for total reasons are there

What I have tried:

I had tried with

foreach (var item in Selected_TABLENAME)
                       {

                           if (item.Contains("All_Red_Events"))
                           {

                               foreach(var iteam1 in EventCategories)
                               {
                                   foreach(var iteam2 in SubEventCategories)
                                   {
                                           OleDbCommand cmd6 = new OleDbCommand();
                                           OleDbDataReader reader2 = null;
                                           cmd6 = new OleDbCommand("select  [T2] FROM " + item.ToString() + " WHERE ( [T0]='" + iteam1.ToString() + "'" +" and" + " [T1]='" + iteam2.ToString() + "')" + "", connection2);
                                           reader2 = cmd6.ExecuteReader();

                                           while (reader2.Read())
                                           {

                                               Subcategoriesreason.Add(reader2["T0"].ToString());
                                           }
                                   }
                               }
                            }

解决方案

Power BI Desktop | Microsoft Power BI[^]

这篇关于如何过滤MS-DB并在C＃中绘制图表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！