Export datatable to CSV in C#.net
How to export data from datatable to CSV, you will find the code for exporting data from datatable to CSV.
Export data from datatable to CSV
We will guide you on how to export data from datatable to CSV, please find its detail.
public void CreateCSVFile(DataTable dt, string strFilePath)
{
StreamWriter sw = new StreamWriter(strFilePath, false);
int iColCount = dt.Columns.Count;
for (int i = 0; i < iColCount; i++)
{
sw.Write(dt.Columns[i]);
if (i < iColCount - 1)
{
sw.Write(",");
}
}
sw.Write(sw.NewLine);
foreach (DataRow dr in dt.Rows)
{
for (int i = 0; i < iColCount; i++)
{
if (!Convert.IsDBNull(dr[i]))
{
sw.Write(dr[i].ToString());
}
if (i < iColCount - 1)
{
sw.Write(",");
}
}
sw.Write(sw.NewLine);
}
sw.Close();
}
hai
successfully exported...but.. i have address column...if i stored 23,delhi road in address column means,in csv 23 is display in address column,delhi road is display in next column...i want display 23,delhi road in address column in csv...how to correct it...plz help...