Here is our C# code to generate CSV file.
1: StringBuilder sb = new StringBuilder();
2: string strDelimiter = ",";
3:
4: foreach (DataRow dr in table.Rows)
5: {
6: string[] arr = Array.ConvertAll(dr.ItemArray, new Converter<object, string>(delegate(object obj)
7: { return obj.ToString().Trim(); }));
8:
9: sb.AppendLine(string.Join(strDelimiter , arr));
10: }
11:
12: File.WriteAllText(outputFile, sb.ToString());
Please feel free to leave any comments. Thanks.