Home
> Uncategorized > Converting a DataTable to CSV
Converting a DataTable to CSV
This is a handly little C# function to convert a DataTable to CSV. Hope it’s useful..
public string DataTableToCSV(DataTable dt)
{
string strCSV = "";
string strSeperator = "";
foreach(DataColumn dc in dt.Columns)
{
strCSV += strSeperator + dc.ColumnName;
strSeperator = ",";
}
strCSV += "rn";
foreach(DataRow dr in dt.Rows)
{
strSeperator = "";
foreach(DataColumn dc in dt.Columns)
{
strCSV += strSeperator + dr[dc.ColumnName].ToString();
strSeperator = ",";
}
strCSV += "rn";
}
return strCSV;
}
{
string strCSV = "";
string strSeperator = "";
foreach(DataColumn dc in dt.Columns)
{
strCSV += strSeperator + dc.ColumnName;
strSeperator = ",";
}
strCSV += "rn";
foreach(DataRow dr in dt.Rows)
{
strSeperator = "";
foreach(DataColumn dc in dt.Columns)
{
strCSV += strSeperator + dr[dc.ColumnName].ToString();
strSeperator = ",";
}
strCSV += "rn";
}
return strCSV;
}
Categories: Uncategorized
Comments (0)
Trackbacks (0)
Leave a comment
Trackback