| Automated charting and reporting |
SharpPlot Tutorials
General Tutorials
Chart Samples
Style Examples
SharpLeaf Tutorials
Document Layout Tutorials
Text Flow Tutorials
Table Tutorials
Visual Glossaries
SharpPlot Reference
SharpPlot Class
SharpPlot Properties
SharpPlot Methods
SharpPlot Structures
SharpPlot Enumerations
PageMap Class
SharpLeaf Reference
SharpLeaf Class
SharpLeaf Properties
SharpLeaf Methods
Table Class
Table Properties
Table Methods
SharpLeaf Structures
FontType Structure
ParagraphStyle Structure
BoxStyle Structure
SharpLeaf Enumerations
DocumentLayout Classes
DocumentLayout Class
PageLayout Class
PageElement Abstract Class
Frame : PageElement Class
TextBlock : PageElement Class
ImageBlock : PageElement Class
Box : PageElement Class
Rule : PageElement Class
Document Class
VectorMath Class
Download
Release Notes
Licensing
Common Reference > DbUtil Class > GetDoubles Method
DbUtil.GetDoubles Method
Get one or more Double columns from a Selection, with optional missing value filler.
Example
sp.Reset(240,160); sp.SetMargins(24,18,24,4); filler = sp.MissingValue; mytable = new DataTable(); // Get some real data here!; myselection = mytable.Select("year>2006 AND symb='BP'"); DbUtil.GetDoubles(myselection,filler,"SharePrice"); sp.Heading = "BP"; sp.HeadingStyle = HeadingStyles.Right; sp.DrawLineGraph(BP);
Overloads
- public static double[][] GetDoubles(DataRow[] sel,double nullFiller,string[] cols);
- public static double[][] GetDoubles(DataRow[] sel,string[] cols);
- public static double[] GetDoubles(DataRow[] sel,double nullFiller,string cols);
- public static double[] GetDoubles(DataRow[] sel,string cols);
Description
This example retrieves a single column of data as a simple array of doubles, with any missing data (DBNull values) replaced with the current SharpPlot missing value property. You can also retrieve multiple columns in a single call which is ideal as a way of plotting several parallel series.