Class DataInfo

DatabaInfo stores information about a dataset, a Report have a collection of dataset definitions. Each dataset is related to one connection (DatabaseInfo)Report DataInfos

Inheritance

object

ReportItem

DataInfo

Implements

IDisposable

ICloneable

Inherited Members

ReportItem.SetReport(BaseReport)

ReportItem.Name

ReportItem.Report

ReportItem.ClassName

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Namespace: Reportman.Reporting

Assembly: Reportman.Reporting.dll

Syntax

public class DataInfo : ReportItem, IDisposable, ICloneable

Constructors

DataInfo()

Constructor

Declaration

public DataInfo()

Fields

Command

Current IDbCommand

Declaration

public IDbCommand Command

Field Value

Type	Description
IDbCommand

Data

Current in memory two record buffer table

Declaration

public ReportDataset Data

Field Value

Type	Description
ReportDataset

DataReader

Current IDataReader

Declaration

public IDataReader DataReader

Field Value

Type	Description
IDataReader

DataViewOverride

Declaration

public DataView DataViewOverride

Field Value

Type	Description
DataView

SQLOverride

Set this property to override the sql sentence at runtime, set is before executing the report

Declaration

public string SQLOverride

Field Value

Type	Description
string

Properties

Alias

DataInfo name (alias)

Declaration

public string Alias { get; set; }

Property Value

Type	Description
string

BDEFilter

BDE filter BDE driver is selected

Declaration

public string BDEFilter { get; set; }

Property Value

Type	Description
string

BDEFirstRange

BDE first range filter BDE driver is selected

Declaration

public string BDEFirstRange { get; set; }

Property Value

Type	Description
string

BDEIndexFields

Index fields when BDE driver is selected

Declaration

public string BDEIndexFields { get; set; }

Property Value

Type	Description
string

BDEIndexName

Index name when BDE driver is selected

Declaration

public string BDEIndexName { get; set; }

Property Value

Type	Description
string

BDELastRange

BDE last range filter BDE driver is selected

Declaration

public string BDELastRange { get; set; }

Property Value

Type	Description
string

BDEMasterFields

BDE master fields BDE driver is selected

Declaration

public string BDEMasterFields { get; set; }

Property Value

Type	Description
string

BDETable

Index table name when BDE driver is selected and BDEType is Table

Declaration

public string BDETable { get; set; }

Property Value

Type	Description
string

BDEType

BDE dataset type (table,query) when BDE driver is selected

Declaration

public DatasetType BDEType { get; set; }

Property Value

Type	Description
DatasetType

DataSource

A master dataset can be assigned so the query is executed each time the parameters of the query change, the parameters with the same name as master dataset fields will be checked

Declaration

public string DataSource { get; set; }

Property Value

Type	Description
string

DataUnions

When Mybase driver is selected, you can fill the dataset (in memory dataset) with other datasets

Declaration

public Strings DataUnions { get; set; }

Property Value

Type	Description
Strings

DatabaseAlias

DatabaseInfo alias related to this dataset

Declaration

public string DatabaseAlias { get; set; }

Property Value

Type	Description
string

GroupUnion

When Mybase driver is selected, you can fill the dataset (in memory dataset) with other datasets, with grouping option

Declaration

public bool GroupUnion { get; set; }

Property Value

Type	Description
bool

MyBaseFields

Field definition file when Mybase driver is selected

Declaration

public string MyBaseFields { get; set; }

Property Value

Type	Description
string

MyBaseFilename

Filename to loadwhen MyBase driver is selected

Declaration

public string MyBaseFilename { get; set; }

Property Value

Type	Description
string

MyBaseIndexFields

Index fields when MyBase driver is selected

Declaration

public string MyBaseIndexFields { get; set; }

Property Value

Type	Description
string

MyBaseMasterFields

Master fields when MyBase driver is selected

Declaration

public string MyBaseMasterFields { get; set; }

Property Value

Type	Description
string

OpenOnStart

By default all datasets are open on start, set this property to false when you want to open the dataset at runtime manually

Declaration

public bool OpenOnStart { get; set; }

Property Value

Type	Description
bool

ParallelUnion

When Mybase driver is selected, and union is performed,

Declaration

public bool ParallelUnion { get; set; }

Property Value

Type	Description
bool

SQL

Sql sentence, for parameters precede them by double quotes in native drivers or by @ symbol in .Net drivers

Declaration

public string SQL { get; set; }

Property Value

Type	Description
string

Methods

Clone()

Clone the DataInfo item

Declaration

public object Clone()

Returns

Type	Description
object	A new DataInfo item

Clone(Report)

Clone the DataInfo item

Declaration

public DataInfo Clone(Report areport)

Parameters

Type	Name	Description
Report	areport	The new owner of the DataInfo

Returns

Type	Description
DataInfo	A new DataInfo item

Connect()

Open the dataset and read the first record into the data variable

Declaration

public void Connect()

DisConnect()

Close the dataset, and free the datareader

Declaration

public void DisConnect()

DisConnectMem()

Declaration

public void DisConnectMem()

Dispose()

Free resources

Declaration

public override void Dispose()

Overrides

ReportItem.Dispose()

GetClassName()

Internal function to determine the object type name

Declaration

protected override string GetClassName()

Returns

Type	Description
string	Object type name

Overrides

ReportItem.GetClassName()

GetDbItem()

Obtain the related DatabaseInfoItem, searching by DatabaseAlias

Declaration

public DatabaseInfo GetDbItem()

Returns

Type	Description
DatabaseInfo	The DatabaseInfo or throws an exception

GetFieldsInfo(Stream)

Obtain field information from the dataset, useful for the designer

Declaration

public void GetFieldsInfo(Stream astream)

Parameters

Type	Name	Description
Stream	astream	Stream to fill with the information

GoFirstMem()

Declaration

public void GoFirstMem()

UpdateParams(ReportDataset, IDbCommand)

Update the parameters inside the command, the master dataset will be used to fill the parameters with matching names

Declaration

public bool UpdateParams(ReportDataset master, IDbCommand ncommand)

Parameters

Type	Name	Description
ReportDataset	master	Master dataset
IDbCommand	ncommand	Command

Returns

Type	Description
bool

Implements

IDisposable

ICloneable