首页 > 代码库 > Datetable Convert TO CSV
Datetable Convert TO CSV
// C# Code public static class Rfc4180Writer { public static void WriteDataTable(DataTable sourceTable, TextWriter writer, bool includeHeaders) { if (includeHeaders) { IEnumerable<String> headerValues = sourceTable.Columns .OfType<DataColumn>() .Select(column => QuoteValue(column.ColumnName)); writer.WriteLine(String.Join(",", headerValues)); } IEnumerable<String> items = null; foreach (DataRow row in sourceTable.Rows) { items = row.ItemArray.Select(o => QuoteValue(o.ToString())); writer.WriteLine(String.Join(",", items)); } writer.Flush(); } private static string QuoteValue(string value) { return String.Concat("\"", value.Replace("\"", "\"\""), "\""); } }
-------------------------------------------------------------------------------------------------------------------------------------------------------------->
// C# Code public static class Program { public static void Main() { DataTable sourceTable = new DataTable(); sourceTable.Columns.AddRange(new DataColumn[] { new DataColumn("ID", typeof(Guid)), new DataColumn("Date", typeof(DateTime)), new DataColumn("StringValue", typeof(string)), new DataColumn("NumberValue", typeof(int)), new DataColumn("BooleanValue", typeof(bool)) }); sourceTable.Rows.Add(Guid.NewGuid(), DateTime.Now, "String1", 100, true); sourceTable.Rows.Add(Guid.NewGuid(), DateTime.Now, "String2", 200, false); sourceTable.Rows.Add(Guid.NewGuid(), DateTime.Now, "String3", 300, true); using (StreamWriter writer = new StreamWriter("C:\\Temp\\dump.csv")) { Rfc4180Writer.WriteDataTable(sourceTable, writer, true); } } }
___________________________________________________________________________________________>
For the ASP.NET MVC
// C# Code
public class ReportController : Controller
{
[HttpGet()]
public ActionResult Export()
{
DataTable sourceTable = new DataTable();
sourceTable.Columns.AddRange(new DataColumn[] {
new DataColumn("ID", typeof(Guid)),
new DataColumn("Date", typeof(DateTime)),
new DataColumn("StringValue", typeof(string)),
new DataColumn("NumberValue", typeof(int)),
new DataColumn("BooleanValue", typeof(bool))
});
sourceTable.Rows.Add(Guid.NewGuid(), DateTime.Now, "String1", 100, true);
sourceTable.Rows.Add(Guid.NewGuid(), DateTime.Now, "String2", 200, false);
sourceTable.Rows.Add(Guid.NewGuid(), DateTime.Now, "String3", 300, true);
byte[] outputBuffer = null;
using (MemoryStream tempStream = new MemoryStream()) {
using (StreamWriter writer = new StreamWriter(tempStream)) {
Rfc4180Writer.WriteDataTable(sourceTable, writer, true);
}
outputBuffer = tempStream.ToArray();
}
return File(outputBuffer, "text/csv", "export.csv");
}
}
Datetable Convert TO CSV
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。