如何以矩阵形式生成csv文件 [英] how to generate csv file in matrix form

问题描述

我想从服务器中以SQL 2005中创建的表table1(A，B，C)AND table(D，E，F)之类的表格的格式从服务器生成csv文件.
它应该像
创建
日期A B C
D
E
F

日期列由csv生成器选择.

I want to generate csv file from server in matrix form from the tables like table1(A,B,C) AND table(D,E,F) which are created in sql 2005.
It should be created like

DATE A B C
D
E
F

date column is selected by csv generator.

推荐答案

逐行！

从表中读取记录/行，然后将数据写出到文件中
写入row1-col1，col2，.....，coln
写row2-col1，col2，.....，coln

这是一个非常简单的过程，您不了解什么?
您尝试了什么?
您的问题在哪里?

Line by line!

Read records/rows from table then write the data out to file
write row1 - col1,col2,.....,coln
write row2 - col1,col2,.....,coln

It is a very simple process what do you not understand?
What have you tried?
Where is your problem?

受保护的void Button2_Click(对象发送者，EventArgs e)
{
试试
{
con.Open();
DataTable dt = new DataTable();
SqlDataAdapter da =新的SqlDataAdapter(从出席者中选择*"，con);
da.Fill(dt);
ExportToText(dt，"Attendence");

}
捕获(SqlException ex)
{
}
终于
{
con.Close();
}
}
受保护的void ExportToText(DataTable dataTable，字符串fileName)
{
HttpContext context = HttpContext.Current;
context.Response.Clear();
foreach(dataTable.Columns中的DataColumn列)
{
context.Response.Write(column.ColumnName +，");
}
context.Response.Write(Environment.NewLine);
foreach(dataTable.Rows中的DataRow行)
{
for(int i = 0; i< dataTable.Columns.Count; i ++)
{
context.Response.Write(row [i] .ToString()+，");
}
context.Response.Write(Environment.NewLine);
}
context.Response.ContentType ="text/csv";
context.Response.AppendHeader("Content-Disposition"，"attachment; filename =" + fileName +".csv");
context.Response.End();
}

protected void Button2_Click(object sender, EventArgs e)
{
try
{
con.Open();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("select * from Attendence", con);
da.Fill(dt);
ExportToText(dt, "Attendence");

}
catch (SqlException ex)
{
}
finally
{
con.Close();
}
}
protected void ExportToText(DataTable dataTable, string fileName)
{
HttpContext context = HttpContext.Current;
context.Response.Clear();
foreach (DataColumn column in dataTable.Columns)
{
context.Response.Write(column.ColumnName + ",");
}
context.Response.Write(Environment.NewLine);
foreach (DataRow row in dataTable.Rows)
{
for (int i = 0; i < dataTable.Columns.Count; i++)
{
context.Response.Write(row[i].ToString() + ",");
}
context.Response.Write(Environment.NewLine);
}
context.Response.ContentType = "text/csv";
context.Response.AppendHeader("Content-Disposition", "attachment; filename=" + fileName + ".csv");
context.Response.End();
}

这篇关于如何以矩阵形式生成csv文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！