Visit Gigasoft's Web Site
ProEssentials v8 Help

Chapter 2: .NET and SQL Data

 

This topic discusses SQL methods of passing data. We've already discussed property arrays as a mechanism to pass data.  In a later section, we'll show a third mechanism via DLL calls.

 

ProEssentials has several features to ease loading data via SQL.  Most of these methods assume a specific structure of data in columns and/or rows. So the SQL statement preparing the data should be carefully constructed to match what's expected.

 

Pego.PeData.BindPointLabelPlusYData ( IEnumerable source )

Loads PointLabels from first column and loads multiple subsets of YData in remaining columns. Since this method loads all subset data, source must be a multi-column source such as a DataReader or DataView. This method will set PeData.SubsetByPoint, PeData.Subsets and PeData.Points, clear existing data, and copy data from source. For a DataReader, SubsetByPoint will be set to false, else, SubsetByPoint is set to true.

Pego.PeData.BindYData ( IEnumerable source )

Loads YData for multiple subsets in the order of their columns. Since this method loads all subset data, source must be a multi-column source such as a DataReader or DataView. This method will set PeData.SubsetByPoint, PeData.Subsets and PeData.Points, clear existing data, and copy data from source. For a DataReader, SubsetByPoint will be set to false, else, SubsetByPoint is set to true. The Pesgo class also contains this member.

Pesgo.PeData.BindXandYData( IEnumerable source )

Loads both XData and YData for multiple subsets.  The source must have two columns per subset.  XData is loaded from the first set of columns and YData is loaded from the remaining columns. For example, if your chart has 4 subsets, then the data source must have 8 columns/fields. The first 4 columns set XData, and last 4 columns set YData. This method will set PeData.SubsetByPoint, PeData.Subsets and PeData.Points, clear existing data, and copy data from source. For a DataReader, SubsetByPoint will be set to false, else, SubsetByPoint is set to true. The Pepso class also contains this member.

Pe3do.PeData.BindXYandZData( IEnumerable source )

Loads XData, YData and ZData for multiple subsets.  The source must have three columns per subset.  XData is loaded from the first set of columns, YData is loaded from the second set of columns, and ZData loaded from the remaining columns.  For example, if your chart has 4 subsets, then the data source must have 12 columns/fields.  The first 4 columns set XData, the next 4 columns set YData, and last 4 columns set ZData. This method will set PeData.SubsetByPoint, PeData.Subsets and PeData.Points, clear existing data, and copy data from source.  For a DataReader, SubsetByPoint will be set to false, else, SubsetByPoint is set to true.  

Pepco.PeData.BindPointLabelPlusXData( IEnumerable source )

Loads PointLabels from first column and loads multiple subsets of XData in remaining columns. Since this method loads all subset data, source must be a multi-column source such as a DataReader or DataView. This method will set PeData.SubsetByPoint, PeData.Subsets and PeData.Points, clear existing data, and copy data from source. For a DataReader, SubsetByPoint will be set to false, else, SubsetByPoint is set to true.

 

Note, the following BindData method is a member of PeData.Y  There's a similar method for PeData.X, and other members of PeData.  These methods can load data for an individual subset(s) whereas the above members are mostly for loading all the charts data.

int PeData.Y.BindData( IEnumerable source,  int startingSubsetIndex,   int startingPointIndex )

Loads data from a DataReader or DataView source. This method does not clear existing data or alter PeData.Subsets and PeData.Points. This method will fill this array with data up-to an amount defined by PeData.Subsets and PeData.Points.  Data is loaded at indices starting with startingSubsetIndex and startingPointIndex.  Multiple subsets of data are read in and allocated by their sequence in column. The return value is the number of records set.

 

 

There's an example project installed with ProEssentials which demonstrates SQL data transfer..

Start / All Programs / ProEssentials v8 / VB.NET SQL Example Project

 

This following example code is taken from this project..