New to Telerik Reporting? Start a free 30-day trial

CsvDataSource

Class

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

Definition

Assembly:Telerik.Reporting.dll

Syntax:

public class CsvDataSource : DataSource, IDataSource

Inheritance: objectMarshalByRefObjectComponentDataSourceCsvDataSource

Implements: IDataSource

Inherited Members DataSource.NameDataSource.DescriptionDataSource.CalculatedFields

Constructors

CsvDataSource()

Initializes a new instance of the CsvDataSource class.

public CsvDataSource()

Properties

Columns

DataColumnCollection

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

public DataColumnCollection Columns { get; }

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

char

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

public char CommentToken { get; set; }

ConsecutiveFieldSeparatorsAsOne

bool

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

public bool ConsecutiveFieldSeparatorsAsOne { get; set; }

ConsecutiveRecordSeparatorsAsOne

bool

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

public bool ConsecutiveRecordSeparatorsAsOne { get; set; }

DateTimeFormat

string

Gets or sets the format used when parsing dates.

public string DateTimeFormat { get; set; }

DecimalSeparator

string

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

public string DecimalSeparator { get; set; }

EscapeFormat

CsvEscapeFormat

Gets or sets the escape format of the CSV document.

public CsvEscapeFormat EscapeFormat { get; set; }

FieldSeparators

char[]

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

public char[] FieldSeparators { get; set; }

HasHeaders

bool

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

public bool HasHeaders { get; set; }

Quote

char

Gets or sets the symbol used for escaping.

public char Quote { get; set; }

RecordSeparators

char[]

Gets or sets the character used as record separator.

public char[] RecordSeparators { get; set; }

Source

object

Gets or sets the source of the CSV document.

public object Source { get; set; }

Remarks:

The supported sources are:

Uri
string
Stream
TextReader

ThousandSeparator

string

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

public string ThousandSeparator { get; set; }