Reference > DBUtil Class > GetDoubles Method

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.

See also ...

Working with Databases

Send comments on this topic
© Dyalog Ltd 2013