62,272
社区成员
发帖
与我相关
我的任务
分享
string sqlStr = " XXXXXXX";
DataSet exlDs = new DataSet();
exlDs = Phrase.GetDataSetOpenSQL(sqlStr);
System.IO.StringWriter sw = new System.IO.StringWriter();
sw.WriteLine("工站,处理单位");//标题
foreach (DataRow dr in exlDs.Tables[0].Rows)
{//字段名
sw.WriteLine(dr["SR_ST"].ToString() + "," + dr["SR_DPT"].ToString());
}
sw.Close();
string name = DateTime.Now.ToString("yyyyMMddHHmmss") + "-"+DS_Name+".csv";//以当前时间为excel表命名
Response.AddHeader("Content-Disposition", "attachment; filename=" + name);
Response.ContentType = "vnd.ms-excel.numberformat:yyyy-MM-dd ";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();

