Reference > DBUtil Class > GetIntegers Method

GetIntegers Method

Get one or more Integer columns from a Selection, with optional missing value filler.

Example

 sp.Reset(240,160);
 sp.SetMargins(24,18,24,4);
 
 mytable = new DataTable(); // Get some real data here!;
 myselection = mytable.Select("year>2006 AND symb='BP'");
 DbUtil.GetIntegers(myselection,"SharePrice");
 
 sp.Heading = "BP";
 sp.HeadingStyle = HeadingStyles.Right;
 sp.DrawLineGraph(BP);

Overloads

• public static int[][] GetIntegers(DataRow[] sel,int nullFiller,string[] cols);
• public static int[][] GetIntegers(DataRow[] sel,string[] cols);
• public static int[] GetIntegers(DataRow[] sel,int nullFiller,string cols);
• public static int[] GetIntegers(DataRow[] sel,string cols);

Description

This example retrieves a single column of data as a simple array of integers, with any missing data (DBNull values) replaced with zero. You can also retrieve multiple columns in a single call which is ideal as a way of plotting several parallel series. Floating point data is rounded to the nearest integer.

See also ...

Working with Databases

Send comments on this topic
© Dyalog Ltd 2013