/* CSVReader - a simple open source C# class library to read CSV data
* by Andrew Stellman - http://www.stellman-greene.com/CSVReader
*
* CSVReader.cs - Class to read CSV data from a string, file or stream
*
* download the latest version: http://svn.stellman-greene.com/CSVReader
*
* (c) 2008, Stellman & Greene Consulting
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
* * Redistributions of source code must retain the above copyright
* notice, this list of conditions and the following disclaimer.
* * Redistributions in binary form must reproduce the above copyright
* notice, this list of conditions and the following disclaimer in the
* documentation and/or other materials provided with the distribution.
* * Neither the name of Stellman & Greene Consulting nor the
* names of its contributors may be used to endorse or promote products
* derived from this software without specific prior written permission.
*
* THIS SOFTWARE IS PROVIDED BY STELLMAN & GREENE CONSULTING ''AS IS'' AND ANY
* EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
* WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
* DISCLAIMED. IN NO EVENT SHALL STELLMAN & GREENE CONSULTING BE LIABLE FOR ANY
* DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
* (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*
*/
using System;
using System.Collections.Generic;
using System.IO;
using System.Data;
namespace Com.StellmanGreene.CSVReader
{
///
/// Read CSV-formatted data from a file or TextReader
///
public class CSVReader : IDisposable
{
///
/// This reader will read all of the CSV data
///
private TextReader reader;
///
/// The number of rows to scan for types when building a DataTable (0 to scan the whole file)
///
public int ScanRows = 0;
#region Constructors
///
/// Read CSV-formatted data from a file
///
/// Name of the CSV file
public CSVReader(FileInfo csvFileInfo)
{
if (csvFileInfo == null)
throw new ArgumentNullException("Null FileInfo passed to CSVReader");
this.reader = new StreamReader(csvFileInfo.FullName);
}
///
/// Read CSV-formatted data from a string
///
/// String containing CSV data
public CSVReader(string csvData)
{
if (csvData == null)
throw new ArgumentNullException("Null string passed to CSVReader");
this.reader = new StringReader(csvData);
}
///
/// Read CSV-formatted data from a TextReader
///
/// TextReader that's reading CSV-formatted data
public CSVReader(TextReader reader)
{
if (reader == null)
throw new ArgumentNullException("Null TextReader passed to CSVReader");
this.reader = reader;
}
#endregion
string currentLine = "";
///
/// Read the next row from the CSV data
///
/// A list of objects read from the row, or null if there is no next row
public List