Based on your code, it looks like you just need to remove the
using (var DT = new DataTable())
line, and replace each reference to
DT
with
CHAIN
:
public void EXPORT_CSV()
{
using (var textWriter = File.CreateText(@"D:\Temp\NewCsv.csv"))
using (var csv = new CsvWriter(textWriter))
{
foreach (DataColumn column in CHAIN.Columns)
{
csv.WriteField(column.ColumnName);
}
csv.NextRecord();
foreach (DataRow row in CHAIN.Rows)
{
for (var i = 0; i < CHAIN.Columns.Count; i++)
{
csv.WriteField(row[i]);
}
csv.NextRecord();
}
}
}