FlexReport for UWP | ComponentOne
C1.UWP.FlexReport Assembly / C1.Xaml.FlexReport Namespace / DataSource Class
Fields Properties Methods


In This Topic
    DataSource Class Members
    In This Topic

    The following tables list the members exposed by DataSource.

    Public Constructors
     NameDescription
    Public ConstructorDataSource ConstructorInitializes a new instance of the DataSource class.  
    Top
    Public Fields
     NameDescription
    Public Fieldc_DefIsolationLevelDefines default IsolationLevel for transaction used to get report data.  
    Top
    Public Properties
     NameDescription
    Public PropertyCalculatedFieldsGets the CalculatedFieldCollection collection defining list of calculated fields for the data source.  
    Public PropertyCommandTimeOutGets or sets the number of seconds to wait before the data connection times out (set to -1 to use the default value, usually 30s).  
    Public PropertyConnectionStringGets or sets the connection string used to open a database.  
    Public PropertyDataHandlerFor internal used.  
    Public PropertyDataLinkFor internal use.  
    Public PropertyDataProviderGets or sets the type of the data source. The data source type determines the syntaxes of connection string and query (record source). The default is Auto but it is recommended that you set this value to the specific type of the data source you are using, as automatic determining of the data source type may be rather slow.  
    Public PropertyDataSourceInfoFor internal use. Getting this property initially may take some time as it accesses the data source. After the first access the value is cached. You may first call the FetchDataSourceInfo method to pre-fetch the value.  
    Public PropertyEncloseParameterValuesGets or sets a value indicating whether values of parameters in resulting SQL query should be enclosed with delimiters, "#" for dates, "'" for strings, "()" for multivalue parameters. If this parameter is false when all parameters in RecordSource already should be enclosed. For example, EncloseParameterValues == true: RecordSource = "select * from customers where name = CustomerName"; actual SQL query will be: select * from customers where name = 'Some customer' EncloseParameterValues == false: RecordSource = "select * from customers where name = 'CustomerName'"; actual SQL query will be: select * from customers where name = 'Some customer'  
    Public PropertyFilterGets or sets the expression used to filter which data rows are included in the report.  
    Public PropertyFilterSyntaxGets or sets the type of syntax used in the Filter.  
    Public PropertyIsDataSourceInfoFetchedFor internal use. Gets a value indicating whether the data source info has been fetched already.  
    Public PropertyIsolationLevelGets or sets the isolation level for DbTransaction used to retrieve the report data.

    The default is IsolationLevel.ReadCommitted.

     
    Public PropertyMaxRecordsGets or sets the maximum number of data rows to be included in the report (zero includes all rows).  
    Public PropertyNameGets or sets the name of the object. (Inherited from C1.Xaml.FlexReport.ReportObject)
    Public PropertyParameterPassingModeGets or sets a value indicating how parameter values are passed to the data engine.  
    Public PropertyParentReportOverridden. Gets the report that contains this DataSource.  
    Public PropertyRecordsetSets or gets the data source object that provides data to the report.  
    Public PropertyRecordSourceGets or sets a string that specifies which table, stored procedure, or Sql command to use for retrieving the report data.  
    Public PropertyRecordSourceTypeGets or sets the type of the RecordSource (stored procedure, table, sql query etc.).  
    Public PropertySortDefinitionsGets the SortDefinitionCollection collection defining sort of the data source.  
    Public PropertyTagGets or sets arbitrary data associated with the object. (Inherited from C1.Xaml.FlexReport.ReportObject)
    Top
    Public Methods
     NameDescription
    Public MethodAssignFromOverloaded. Assigns (copies) properties from another DataSource to the current object. The name of source object is not copied.  
    Public MethodCloseFor internal used. Disposes underlying DataHandler.  
    Public MethodOpenFor internal used. Builds the DataHandler object used to access data defined by this DataSource object. Method can throw an exception if data source can not be opened: invalid connection string etc.  
    Public MethodToStringReturns the Name of the current data source.  
    Top
    See Also

    Reference

    DataSource Class
    C1.Xaml.FlexReport Namespace