Convert DataSet to CSV
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();
}
Alternatively Refer:
http://forums.asp.net/t/1500560.aspx/1?How+To+Convert+A+DataSet+To+CSV
No comments:
Post a Comment
Thank You for Your Comments. We will get back to you soon.