Showing posts with label Convert datatable. Show all posts
Showing posts with label Convert datatable. Show all posts

Friday, 17 February 2012

Convert datatable to CSV format

public void CreateCSVfile(DataTable dtable, string strFilePath)
{

StreamWriter sw = new StreamWriter(strFilePath, false);
int icolcount = dtable.Columns.Count;
for (int i = 0; i < icolcount; i++)
{
sw.Write(dtable.Columns[i]);
if (i < icolcount - 1)
{
sw.Write(",");
}
}
sw.Write(sw.NewLine);
foreach (DataRow drow in dtable.Rows)
{
for (int i = 0; i < icolcount; i++)
{
if (!Convert.IsDBNull(drow[i]))
{
sw.Write(drow[i].ToString());
}
if (i < icolcount - 1)
{
sw.Write(",");
}
}
sw.Write(sw.NewLine);
}
sw.Close();
}