How to convert Data table into this csv format

Hi Aman

 

https://www.codeproject.com/Tips/665519/Writing-a-DataTable-to-a-CSV-File 

 

Or with the help of extenstion method you can use this that will be reusable as well:

 

public static class DataTableExtensionsClass   
{  
    public static void ConvertToCsvFile(this DataTable dataTable, string filePath)   
    {  
        StringBuilder fileContent = new StringBuilder();  
  
        foreach (var col in dataTable.Columns)   
        {  
            fileContent.Append(col.ToString() + ",");  
        }  
  
        fileContent.Replace(",", System.Environment.NewLine, fileContent.Length - 1, 1);  
  
        foreach (DataRow dr in dataTable.Rows)   
        {  
            foreach (var column in dr.ItemArray)   
            {  
                fileContent.Append("\"" + column.ToString() + "\",");  
            }  
  
            fileContent.Replace(",", System.Environment.NewLine, fileContent.Length - 1, 1);  
        }  
  
        System.IO.File.WriteAllText(filePath, fileContent.ToString());  
    }  
}  

 

 You can install Free Spire.XLS API via nuget and use the below code to simply convert data table to csv.

 

Please refer to link

https://stackoverflow.com/questions/4959722/c-sharp-datatable-to-csv

 

One article from C# corner itself 

https://www.c-sharpcorner.com/UploadFile/deveshomar/export-datatable-to-csv-using-extension-method/