Documentation

Class CsvDataSource

Represents a data model, based on a textual Comma-Separated-Values data.

Inheritance
System.Object
DataSource
CsvDataSource
Inherited Members
Namespace: Telerik.Reporting
Assembly: Telerik.Reporting.dll

Syntax

public class CsvDataSource : DataSource, INamedObject, ICloneable, IEquatableDataSource, ISimpleDataSource, IDataSource

Constructors

CsvDataSource()

Initializes a new instance of the CsvDataSource class.

Declaration
public CsvDataSource()

Properties

Columns

Gets a DataColumnCollection defining each column of the CSV data source.

Declaration
public DataColumnCollection Columns { get; }
Property Value
DataColumnCollection

Remarks

When left empty, Columns are inferred from the data itself: If header row is available, it is used to infer column names; The type of each column is considered string.

CommentToken

Gets or sets the symbol used for comments in the CSV document.

Declaration
public char CommentToken { get; set; }
Property Value
System.Char

ConsecutiveFieldSeparatorsAsOne

Gets or sets a value indicating whether consecutive field separators are treated as one in the CSV document.

Declaration
public bool ConsecutiveFieldSeparatorsAsOne { get; set; }
Property Value
System.Boolean

ConsecutiveRecordSeparatorsAsOne

Gets or sets a value indicating whether consecutive record separators are treated as one in the CSV document.

Declaration
public bool ConsecutiveRecordSeparatorsAsOne { get; set; }
Property Value
System.Boolean

DateTimeFormat

Gets or sets the format used when parsing dates.

Declaration
public string DateTimeFormat { get; set; }
Property Value
System.String

DecimalSeparator

Gets or sets the decimal separator used when parsing numbers. Invariant culture's '.' separator is used by default.

Declaration
public string DecimalSeparator { get; set; }
Property Value
System.String

EscapeFormat

Gets or sets the escape format of the CSV document.

Declaration
public CsvEscapeFormat EscapeFormat { get; set; }
Property Value
CsvEscapeFormat

FieldSeparators

Gets or sets the set of characters used as field separators (delimiters).

Declaration
public char[] FieldSeparators { get; set; }
Property Value
System.Char[]

HasHeaders

Gets or sets a value indicating whether the CSV document has a header row.

Declaration
public bool HasHeaders { get; set; }
Property Value
System.Boolean

Quote

Gets or sets the symbol used for escaping.

Declaration
public char Quote { get; set; }
Property Value
System.Char

RecordSeparators

Gets or sets the character used as record separator.

Declaration
public char[] RecordSeparators { get; set; }
Property Value
System.Char[]

Source

Gets or sets the source of the CSV document.

Declaration
public object Source { get; set; }
Property Value
System.Object

Remarks

The supported sources are:

  1. System.Uri
  2. System.String
  3. System.IO.Stream
  4. System.IO.TextReader

ThousandSeparator

Gets or sets the thousand separator used when parsing numbers. Invariant culture's ',' separator is used by default.

Declaration
public string ThousandSeparator { get; set; }
Property Value
System.String