public static int WriteBody(StreamWriter sw, DbDataReader r, string separator, string dateTimeFormat, int?roundFloatsTo)
{
int linesWritten = 0;
while (r.Read())
{
//write values
for (int i = 0; i < r.FieldCount; i++)
{
//clean string
sw.Write(CSVOutputFormat.CleanString(r[i], separator, out _, dateTimeFormat, roundFloatsTo));
if (i < r.FieldCount - 1)
{
sw.Write(separator); //if not the last element add a ','
}
else
{
sw.WriteLine();
}
}
linesWritten++;
}
return(linesWritten);
}
public static void WriteHeader(StreamWriter sw, DbDataReader r, string separator, string dateTimeFormat)
{
//write headers
for (int i = 0; i < r.FieldCount; i++)
{
sw.Write(CSVOutputFormat.CleanString(r.GetName(i), separator, out _, dateTimeFormat, null));
if (i < r.FieldCount - 1)
{
sw.Write(separator);
}
else
{
sw.WriteLine();
}
}
}