Code
1 protected void Page_Load(object sender, EventArgs e)
2 {
3 string FileId = Request["FileId"].ToString();
4
5 string valstr = "";
6
7 System.IO.StreamReader sr = new System.IO.StreamReader(Server.MapPath("~/xml/" + FileId + ".xml"));
8
9 //将流转成结果集
10 DataSet ds = new DataSet();
11 ds.ReadXml(sr);
12
13
14 for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
15 {
16 valstr += "\"" + ds.Tables[0].Columns[i].ColumnName + "\",";
17 }
18 valstr += "\n";
19
20 for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
21 {
22 for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
23 {
24 valstr += "\""+ds.Tables[0].Rows[i][j].ToString() + "\",";
25 }
26 valstr += "\n";
27 }
28
29 Response.ClearHeaders();
30 Response.AppendHeader("Content-disposition", "attachment;filename=test.csv");
31 Response.BinaryWrite(System.Text.Encoding.GetEncoding("gb2312").GetBytes(valstr));
32 Response.End();
33 }
1 protected void Page_Load(object sender, EventArgs e)
2 {
3 string FileId = Request["FileId"].ToString();
4
5 string valstr = "";
6
7 System.IO.StreamReader sr = new System.IO.StreamReader(Server.MapPath("~/xml/" + FileId + ".xml"));
8
9 //将流转成结果集
10 DataSet ds = new DataSet();
11 ds.ReadXml(sr);
12
13
14 for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
15 {
16 valstr += "\"" + ds.Tables[0].Columns[i].ColumnName + "\",";
17 }
18 valstr += "\n";
19
20 for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
21 {
22 for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
23 {
24 valstr += "\""+ds.Tables[0].Rows[i][j].ToString() + "\",";
25 }
26 valstr += "\n";
27 }
28
29 Response.ClearHeaders();
30 Response.AppendHeader("Content-disposition", "attachment;filename=test.csv");
31 Response.BinaryWrite(System.Text.Encoding.GetEncoding("gb2312").GetBytes(valstr));
32 Response.End();
33 }