DataTable导出为cvs
来源:互联网 发布:matlab2015a破解版mac 编辑:程序博客网 时间:2024/04/26 10:48
/// <summary>
/// 导出文件为csv
/// </summary>
/// <param name="table">数据表</param>
/// <param name="file">导出路径</param>
public void dataTableToCsv(DataTable table, string file)
{
string title = "";
FileStream fs = new FileStream(file, FileMode.Create);
StreamWriter sw = new StreamWriter(new BufferedStream(fs), Encoding.Default);
for (int i = 0; i < table.Columns.Count; i++)
{
title += table.Columns[i].ColumnName + ",";
}
title = title.Substring(0, title.Length - 1) + "\n";
sw.Write(title);
foreach (DataRow row in table.Rows)
{
string line = "";
for (int i = 0; i < table.Columns.Count; i++)
{
line += row[i].ToString() + ",";
}
line = line.Substring(0, line.Length - 1) + "\n";
sw.Write(line);
}
sw.Close();
fs.Close();
}
/// 导出文件为csv
/// </summary>
/// <param name="table">数据表</param>
/// <param name="file">导出路径</param>
public void dataTableToCsv(DataTable table, string file)
{
string title = "";
FileStream fs = new FileStream(file, FileMode.Create);
StreamWriter sw = new StreamWriter(new BufferedStream(fs), Encoding.Default);
for (int i = 0; i < table.Columns.Count; i++)
{
title += table.Columns[i].ColumnName + ",";
}
title = title.Substring(0, title.Length - 1) + "\n";
sw.Write(title);
foreach (DataRow row in table.Rows)
{
string line = "";
for (int i = 0; i < table.Columns.Count; i++)
{
line += row[i].ToString() + ",";
}
line = line.Substring(0, line.Length - 1) + "\n";
sw.Write(line);
}
sw.Close();
fs.Close();
}
- DataTable导出为cvs
- Datatable导出为Excel
- 将DataTable导出为excel
- DataTable 导出为csv格式文件
- 报表导出为CVS,pdf格式文件格式
- 将DataTable导出为Excel (XML Spreadsheet).
- 将DataTable导出为Excel (XML Spreadsheet)
- 将DataTable导出为Excel (XML Spreadsheet)
- DataTable的数据导出显示为报表
- 将DataTable导出为Excel (XML Spreadsheet).
- ASP.NET将DataTable导出为EXCEL
- 数据导出excel 使用将 DataTable导出为excel
- DataTable导出
- asp.net中gridview中数据保存为cvs格式,datatable中
- 服务器端实现DataTable导出为excel(终极解决方案)
- ASP.NET中将DataTable导出为Excel文件
- [原]C#操作Excel-导出DataTable为excel
- [原]C#操作Excel-导出DataTable为excel
- 华为如何通过ACL访问控制列表限制上网
- 二分法HDU2199
- Android学习系列(5)--App布局初探之简单模型
- MVC学习1-------------MVC流程
- windows创建问题
- DataTable导出为cvs
- jQuery load方法及Ajax传递中文参数值乱码问题解决
- 表格的列标题具有排序功能可便于读者查阅
- RunTime.getRunTime().addShutdownHook用法
- 虚函数实现原理
- Effective STL--3. Associating Container
- sqlcmd 了解
- Quartz 2D Programing Guide 独家经典,必须分享!
- eclipse中java项目转换为web项目