Connecting the CsvDataSource Component to a CSV Source

When you configure the CsvDataSource component the settings below are obligatory to avoid runtime error due to failed data retrieval:

• Source - Specifies the CSV document which will be used by using the Uri class or an inline string. If set to null an exception is thrown;
• Field separators - Configures the list of separators by which the document will be split to fields (columns) based on a delimiter;
• Record separators - Configures the list of separators by which the document will be split to records (rows) based on a delimiter.

Optional settings for the proper functioning of the CsvDataSource you need to consider:

• Has headers - configures if the CSV source has a header row, by default is false;
• Escape format - for more information please check CsvDataSource Escape Formats; default value is None;
• Quote - if the Escape format is Quotes or Quotes Mixed then the Quote property must be set.

C#

            var csvDataSource = new CsvDataSource();
            csvDataSource.Source = new Uri(@"C:\temp\MyCsvDocument.csv");
            csvDataSource.FieldSeparators = new[] { ',' };
            csvDataSource.RecordSeparators = new[] { '\r', '\n' };
            csvDataSource.HasHeaders = false;
            csvDataSource.EscapeFormat = CsvEscapeFormat.Quotes;
            csvDataSource.Quote = '"';

VB.NET

        Dim csvDataSource = New CsvDataSource()
        csvDataSource.Source = New Uri("C:\temp\MyCsvDocument.csv")
        csvDataSource.FieldSeparators = New Char() {","c}
        csvDataSource.RecordSeparators = New Char() {ControlChars.Cr, ControlChars.Lf}
        csvDataSource.HasHeaders = False
        csvDataSource.EscapeFormat = CsvEscapeFormat.Quotes
        csvDataSource.Quote = """"c

Optional setting:

C#

            csvDataSource.ConsecutiveFieldSeparatorsAsOne = false;
            csvDataSource.ConsecutiveRecordSeparatorsAsOne = true;
            csvDataSource.CommentToken = '#';
            csvDataSource.DecimalSeparator = ".";
            csvDataSource.ThousandSeparator = " ";
            csvDataSource.DateTimeFormat = "MM/dd/yyyy hh:mm";

VB.NET

        csvDataSource.ConsecutiveFieldSeparatorsAsOne = False
        csvDataSource.ConsecutiveRecordSeparatorsAsOne = True
        csvDataSource.CommentToken = "#"c
        csvDataSource.DecimalSeparator = "."
        csvDataSource.ThousandSeparator = " "
        csvDataSource.DateTimeFormat = "MM/dd/yyyy hh:mm"