|
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. |
|
