c# Code:
private static int WriteToFile(DataTable dt, string FilePath, char Delimiter)
{
int result = -1;
try
{
if (File.Exists(FilePath)) { File.Delete(FilePath); } //Always Overwrite.
var objWriter = new System.IO.StreamWriter(FilePath);
var stringBuilder = new StringBuilder();
int columnCount = dt.Columns.Count;
foreach(DataColumn myCol in dt.Columns)
{
stringBuilder.Append(myCol.ColumnName);
stringBuilder.Append(Delimiter);
}
stringBuilder.Append("\n");
foreach (DataRow row in dt.Rows)
{
foreach (DataColumn myCol in dt.Columns)
{
stringBuilder.Append(row[myCol]);
stringBuilder.Append(Delimiter);
}
stringBuilder.Append("\n");
}
stringBuilder.Append("\n");
objWriter.Write(stringBuilder.ToString());
}
catch (Exception)
{
result = 0;
}
return result;
}