无法在 ASP.net 中显示图形

Can not display graph in ASP.net

提问人:Hussain Mahdi Farhanian 提问时间:3/21/2023 更新时间:3/21/2023 访问量:27

问:

我在显示具有 100 个值的 StackBar 3 图形时遇到问题,每当我删除第三个值时,它都会毫无问题地显示,但是使用第三个值时,它就会消失并且不显示任何内容。我正在从我的数据库中获取数据,并尝试将其显示在图表中,如下所示

因此,我正在使用 ASP.net c#

任何人都可以帮帮我吗!

if (tb != null)
        {
            // Chart Starting Point
            string chartOut = "";
            chartOut = "<script>$(document).ready(function() { ";
            chartOut += "var chartOut = new CanvasJS.Chart('chartContainer', { ";
            chartOut += "theme: 'light2', ";
            chartOut += "animationEnabled: true, ";
            chartOut += "exportEnabled: true, ";
            
           

            chartOut += "axisY: { ";
            chartOut += "title: {text: 'Staff Breakdown' },  ";
            chartOut += "titleFontSize: 5, ";
            chartOut += "includeZero: true, ";
            chartOut += "interval: 1, ";
            chartOut += "suffix: '%' }, ";
            chartOut += "legend: {";
            chartOut += "curser: 'pointer', ";
            chartOut += "fontSize: 1 ";
            chartOut += "}, ";
            chartOut += "data: [";



            // Data for (Locals)
            chartOut += "{ name: 'Locals', color: '#bcbcbc', type: 'stackedBar100',  axisYType: 'primary', yValueFormatString: '#,###.##', indexLabel: '{y}', showInLegend: true, indexLabelFontSize: 12, indexLabelPlacement: 'outside', indexLabelFontColor: 'black', ";
            chartOut += "dataPoints: [";
            var value1 = "";
            for (int i = 0; i < tb.Rows.Count; i++)
                value1 += "{ label: '" + tb.Rows[i]["Department"].ToString() + "', y: " + tb.Rows[i]["KW_PERC"].ToString() + "},";
            chartOut += value1;
            chartOut += "]},";

            // Data for (Expatriates)
            chartOut += "{ name: 'Expats', color: 'green', type: 'stackedBar100',   yValueFormatString: '#,###.##', indexLabel: '{y}', showInLegend: true, indexLabelFontSize: 12, indexLabelPlacement: 'outside', indexLabelFontColor: 'black',  ";
            chartOut += "dataPoints: [";
            var value2 = "";
            for (int i = 0; i < tb.Rows.Count; i++)
                value2 += "{ label: '" + tb.Rows[i]["Department"].ToString() + "', y: " + tb.Rows[i]["NKW_PERC"].ToString() + "},";
            chartOut += value2;
            chartOut += "]}";

            // Data for (Outsourced)
            chartOut += "{ name: 'Outsourced', color: 'green', type: 'stackedBar100',  axisYType: 'primary',  yValueFormatString: '#,###.##', indexLabel: '{y}', showInLegend: true, indexLabelFontSize: 12, indexLabelPlacement: 'outside', indexLabelFontColor: 'black',  ";
            chartOut += "dataPoints: [";
            var value3 = "";
            for (int i = 0; i < tb.Rows.Count; i++)
                value3 += "{ label: '" + tb.Rows[i]["Department"].ToString() + "', y: " + tb.Rows[i]["OUT_NKW_PERC"].ToString() + "},";
            chartOut += value3;
            chartOut += "]}";




            // Chart Closing Point
            chartOut += "]});chartOut.render();});";
            chartOut += "</script>";

            // Return Chart
            ltchart5.Text = chartOut;

C# asp.net 图形 canvasjs

评论


答: 暂无答案