|
Group: Forum Members
Last Active: 13 Years Ago
Posts: 3,
Visits: 1
|
I'm evaluating the Nevron Chart components for winform, and I ran into the following.
I bind a line series to an sqlDataAdapter returning two columns (a datetime column and a 'double' column). Now whenever this 'double' column contains normal values it works like a charm. But when there's a null value somewhere, the chart freezes at startup when onPaint is called and the CPU usage jumps to the ceiling. Debug shows it seems to hang somewhere in the GetNextChunk function.
I have emptydatapoints set to skip. Has anyone experienced something similar before? constructor: sqlConnection = new SqlConnection(ConnectString);
sqlSelectCommand = new SqlCommand(SELECT * FROM tv_TotalMDUCurrent PIVOT( MAX(TotalCurrent) FOR ID IN ([_200],[_4])) AS P ORDER BY tDateTime, sqlConnection);
sqlDataAdapter = new SqlDataAdapter(sqlSelectCommand);
form OnLoad foreach (column in table, eg _200 and _4)
{ test = new NLineSeries();
test.DataLabelStyle.Visible = false;
test.UseXValues = true;
test.BorderStyle = new NStrokeStyle(Color.OrangeRed);
test.SamplingMode = SeriesSamplingMode.Enabled;
test.InflateMargins = true;
test.DataLabelStyle.Visible = false;
test.MarkerStyle.Visible = false;
test.SamplingMode = SeriesSamplingMode.Enabled;
test.Values.EmptyDataPoints.ValueMode = EmptyDataPointsValueMode.Skip;
nChart.Charts[0].Series.Add(test);
nChart.DataBindingManager.AddBinding(0, 0, "XValues", sqlDataAdapter,XAxisDataColumn);
nChart.DataBindingManager.AddBinding(0, 0, "Values", sqlDataAdapter, "_200");
nChart.DataBindingManager.AddBinding(0, 0, "Labels", sqlDataAdapter, "_4");} Table looks like: tDateTime _200 _4
----------------------- ------------------------ ------------------------
2010-12-23 14:57:37.000 0.90000000000000002 NULL
2010-12-23 15:02:37.000 0.90000000000000002 NULL
2010-12-23 15:07:43.000 0.90000000000000002 NULL
2010-12-23 15:12:38.000 0.90000000000000002 NULL
2010-12-23 15:17:38.000 0.80000000000000004 NULL
2010-12-23 15:25:59.000 0.80000000000000004 NULL
2010-12-23 15:30:59.000 0.90000000000000002 NULL
2010-12-23 15:35:59.000 0.90000000000000002 NULL
2010-12-23 15:40:59.000 0.90000000000000002 NULL
2010-12-23 15:46:00.000 0.90000000000000002 NULL
|
|
Group: Forum Members
Last Active: 13 Years Ago
Posts: 3,
Visits: 1
|
where it says:
nChart.DataBindingManager.AddBinding(0, 0, "Values", sqlDataAdapter, "_200"); it's actually: nChart.DataBindingManager.AddBinding(0, seriesindex, "Values", sqlDataAdapter, "_200");
|
|
Group: Forum Members
Last Active: Last Week
Posts: 3,054,
Visits: 4,009
|
Hi Geert, Thank you for reporting this problem - it generally caused when the current chunk begins contains no valid values which prevents the data point scan code to advance to next one. This issue is currently fixed and the SP will appear on our website until the end of this week. Let us know if you have any questions or meet any problems.
Best Regards,
Nevron Support Team
|
|
Group: Forum Members
Last Active: 13 Years Ago
Posts: 3,
Visits: 1
|
Thank you!
Looking forward to the SP. Best regards, Geert
|