Gallery

Gallery > Data Manipulation

Selective Defaults Inclusive

Demonstrates applying element settings to a set of elements of a series that meet a specific criteria.

Download Show C# Code Show VB Code

<%@ Page Language="C#" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING" %>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Drawing.Drawing2D" %>

<script runat="server">

void Page_Load(Object sender, EventArgs e)
{
// Demonstrates applying element settings to a set of elements of a series that meet a specific criteria.

Chart.TempDirectory = "temp";
Chart.Debug = true;
//Chart.TitleBox.Position = TitleBoxPosition.FullWithLegend;
Chart.ChartArea.Label.Text = "Applies the orange style to elements with \nyValues within the 30-50 range.";
Chart.LegendBox.Position = LegendBoxPosition.ChartArea;

Chart.Size = "600x350";
Chart.DefaultElement.Outline.Width = 4;
Chart.DefaultElement.Outline.Color =Color.FromArgb(30,Color.LightGray);
// *DYNAMIC DATA NOTE*
// This sample uses random data to populate the chart. To populate
// a chart with database data see the following resources:
// - Use the getLiveData() method using the dataEngine to query a database.
// - Help File > Getting Started > Data Tutorials
// - DataEngine Class in the help file
// - Sample: features/DataEngine.aspx

SeriesCollection mySC = getRandomData();

Element myDefaultElement = new Element();
myDefaultElement.Color = Color.Orange;
myDefaultElement.ShowValue = true;
myDefaultElement.Outline.Color = Color.White;
myDefaultElement.HatchStyle = HatchStyle.BackwardDiagonal;

myDefaultElement.HatchColor = Color.Azure;
myDefaultElement.SmartLabel.Font = new Font("Arial", 28,FontStyle.Bold);
myDefaultElement.SmartLabel.GlowColor = Color.White;

mySC[0].SelectiveElementDefaults(new ScaleRange(10, 20), ElementValue.YValue, myDefaultElement, true);

// Add the random data.
Chart.SeriesCollection.Add(mySC);
}

SeriesCollection getRandomData()
{
Random myR = new Random(4);
SeriesCollection SC = new SeriesCollection();
int a = 0;
int b = 0;
for (a = 1; a < 2; a++)
{
Series s = new Series("Series " + a.ToString());
for (b = 1; b < 45; b++)
{
Element e = new Element("Element " + b.ToString());
e.YValue = b;// myR.Next(50);
s.Elements.Add(e);
}
SC.Add(s);
}
return SC;
}

SeriesCollection getLiveData()
{
DataEngine de = new DataEngine("ConnectionString goes here");
de.ChartObject = Chart; // Necessary to view any errors the dataEngine may throw.
de.SqlStatement = "SELECT XAxisColumn, YAxisColumn FROM ....";
return de.GetSeries();
}

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>.netCHARTING Sample</title>
</head>
<body>
<div align="center">
<dotnet:Chart ID="Chart" runat="server" />
</div>
</body>
</html>

<%@ Page Language="vb" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING" %>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Drawing.Drawing2D" %>

<script runat="server">

Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
' Demonstrates applying element settings to a set of elements of a series that meet a specific criteria.

Chart.TempDirectory = "temp"
Chart.Debug = True
'Chart.TitleBox.Position = TitleBoxPosition.FullWithLegend;
Chart.ChartArea.Label.Text = "Applies the orange style to elements with " & Constants.vbLf & "yValues within the 30-50 range."
Chart.LegendBox.Position = LegendBoxPosition.ChartArea

Chart.Size = "600x350"
Chart.DefaultElement.Outline.Width = 4
Chart.DefaultElement.Outline.Color =Color.FromArgb(30,Color.LightGray)
' *DYNAMIC DATA NOTE*
' This sample uses random data to populate the chart. To populate
' a chart with database data see the following resources:
' - Use the getLiveData() method using the dataEngine to query a database.
' - Help File > Getting Started > Data Tutorials
' - DataEngine Class in the help file
' - Sample: features/DataEngine.aspx

Dim mySC As SeriesCollection = getRandomData()

Dim myDefaultElement As Element = New Element()
myDefaultElement.Color = Color.Orange
myDefaultElement.ShowValue = True
myDefaultElement.Outline.Color = Color.White
myDefaultElement.HatchStyle = HatchStyle.BackwardDiagonal

myDefaultElement.HatchColor = Color.Azure
myDefaultElement.SmartLabel.Font = New Font("Arial", 28,FontStyle.Bold)
myDefaultElement.SmartLabel.GlowColor = Color.White

mySC(0).SelectiveElementDefaults(New ScaleRange(10, 20), ElementValue.YValue, myDefaultElement, True)

' Add the random data.
Chart.SeriesCollection.Add(mySC)
End Sub

Function getRandomData() As SeriesCollection
Dim myR As Random = New Random(4)
Dim SC As SeriesCollection = New SeriesCollection()
Dim a As Integer = 0
Dim b As Integer = 0
For a = 1 To 1
Dim s As Series = New Series("Series " & a.ToString())
For b = 1 To 44
Dim e As Element = New Element("Element " & b.ToString())
e.YValue = b ' myR.Next(50);
s.Elements.Add(e)
Next b
SC.Add(s)
Next a
Return SC
End Function

Function getLiveData() As SeriesCollection
Dim de As DataEngine = New DataEngine("ConnectionString goes here")
de.ChartObject = Chart ' Necessary to view any errors the dataEngine may throw.
de.SqlStatement = "SELECT XAxisColumn, YAxisColumn FROM ...."
Return de.GetSeries()
End Function

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>.netCHARTING Sample</title>
</head>
<body>
<div align="center">
<dotnet:Chart ID="Chart" runat="server" />
</div>
</body>
</html>

Sample FilenameSelectiveDefaultsInclusive.aspx
Version5.0
Uses DatabaseNo

JS Charting

Gallery

Selective Defaults Inclusive