how to export data from datatable into .csv format

Hello ,
CSV Files are used for Excel Data.To Give The No Of Heading or show Seperate Data comma is being used for SHowing in seperate Cells.
Add a namespace System.IO
Kindly have a look at the Code Below

using (StreamWriter streamWriter = new StreamWriter("Report.CSV"))
                {
                  
                    streamWriter.WriteLine("Sr No,Column/Heading 1,Column/Heading 2");
//Loop Through your Table Example
//for(int i=0;i<dt.rows.count,i++)>
//{
//  streamWriter.WriteLine(string.Format("{0},{1},{2}",i+1,
//dt.Rows[i]["ColumnName"],dt.Rows[i]["ColumnName"]));
//}
//To Open a Excel File
  System.Diagnostics.Process.Start("Excel.exe", "Report.CSV");
}//Close Of Using Tag

Hope It Helps You
Happy Coding
:-)