public override string ToString()
{
string result = null;
if (CsvTable != null)
{
result = GetCsvRawData(CsvTable.CreateDataReader(), ColumnList, true);
}
return(result);
}
/// <summary>
/// write the data table content into a csv file at the specified location.
/// </summary>
/// <param name="csvLocation">csv file output location</param>
/// <param name="hasHeader"></param>
/// <param name="encoding"></param>
public void Write(string csvLocation, bool hasHeader, Encoding encoding = null)
{
if (encoding == null)
{
encoding = Encoding.UTF8;
}
if (CsvTable != null)
{
Write(CsvTable.CreateDataReader(), csvLocation, ColumnList, hasHeader);
}
}
public byte[] ToBinary()
{
byte[] result = null;
if (CsvTable != null)
{
var rawData = GetCsvRawData(CsvTable.CreateDataReader(), ColumnList, true);
var encoder = new ASCIIEncoding();
result = encoder.GetBytes(rawData);
}
return(result);
}
public void Append(string csvLocation)
{
if (CsvTable != null)
{
//Gets the existing data in the csv file
var data = File.ReadAllText(csvLocation);
//Add the data to string builder
var sb = new StringBuilder(data);
//Gets the data from the actual datareader
var dataToAppend = GetCsvRawData(CsvTable.CreateDataReader(), ColumnList, false);
//Appends the new data to string builder
sb.Append(dataToAppend);
//Writes the file
File.WriteAllText(csvLocation, sb.ToString());
}
}
public string GetCsvData(bool includeHeaders = true)
{
return(GetCsvRawData(CsvTable.CreateDataReader(), ColumnList, includeHeaders));
}