public void ExporPhonelist(int taskid)
{
DataTable dt = new BLL.SMS_PhoneList().GetExportDataByTaskId(taskid).Tables[0];
string strFileName; //生成文件名: 当前年月日小时分钟秒+ 随机数
Random rd = new Random(int.Parse(DateTime.Now.ToString("MMddhhmmss")));
strFileName = DateTime.Now.ToString("yyyyMMdd")
+ DateTime.Now.Hour
+ DateTime.Now.Minute
+ DateTime.Now.Second
+ rd.Next(999999).ToString()
+ ".csv";
StringWriter sw = new StringWriter(); string title = string.Empty;
string content = string.Empty;
for (int i = 0; i < dt.Columns.Count; i++)
{
if (title == "")
{
title = dt.Columns[i].ToString();
continue;
}
title = title + "," + dt.Columns[i].ToString();
}
string[] titlearray = title.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
sw.WriteLine(title);
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < titlearray.Length; j++)
{
if (content == "")
{
content = dt.Rows[i][j].ToString();
continue;
}
content += "," + dt.Rows[i][j].ToString(); }
sw.WriteLine(content);
content = string.Empty;
} sw.Close(); Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(strFileName)); Response.ContentType = "vnd.ms-excel.numberformat:yyyy-MM-dd "; Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); Response.Write(sw); Response.End();
}/*
* 这是我一个导出数据为Execl表格的方法
*点击按钮 时导出 会自动弹出迅雷 在ie和ff里面 下载的是当前的页面 在360里面就是execl
*这个怎么解决?
*/
{
DataTable dt = new BLL.SMS_PhoneList().GetExportDataByTaskId(taskid).Tables[0];
string strFileName; //生成文件名: 当前年月日小时分钟秒+ 随机数
Random rd = new Random(int.Parse(DateTime.Now.ToString("MMddhhmmss")));
strFileName = DateTime.Now.ToString("yyyyMMdd")
+ DateTime.Now.Hour
+ DateTime.Now.Minute
+ DateTime.Now.Second
+ rd.Next(999999).ToString()
+ ".csv";
StringWriter sw = new StringWriter(); string title = string.Empty;
string content = string.Empty;
for (int i = 0; i < dt.Columns.Count; i++)
{
if (title == "")
{
title = dt.Columns[i].ToString();
continue;
}
title = title + "," + dt.Columns[i].ToString();
}
string[] titlearray = title.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
sw.WriteLine(title);
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < titlearray.Length; j++)
{
if (content == "")
{
content = dt.Rows[i][j].ToString();
continue;
}
content += "," + dt.Rows[i][j].ToString(); }
sw.WriteLine(content);
content = string.Empty;
} sw.Close(); Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(strFileName)); Response.ContentType = "vnd.ms-excel.numberformat:yyyy-MM-dd "; Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); Response.Write(sw); Response.End();
}/*
* 这是我一个导出数据为Execl表格的方法
*点击按钮 时导出 会自动弹出迅雷 在ie和ff里面 下载的是当前的页面 在360里面就是execl
*这个怎么解决?
*/
解决方案 »
- asp.net 连接mysql 使用gridview的问题
- 有谁做过心理测试题项目啊
- 软件和网站的界限是什么?
- 如何对RadioButtonList数据绑定???
- unable to start debugging on the web server
- 如果问题答案正确的话就把密码修改成新的?这样的程序是怎么写?
- 头都大了:我在程序和Webconfig中都设置了编码方式,但为什么Cookie中文输出还为乱码?
- sql server 2008有没有可以完整下载的?
- DataBinder
- visual studio.net 和visual basic.net到底是什么关系呀?
- Response弹框获取值问题
- 怎样发现在datalist中的Repeater控件?
2.点击工具
3.点击配置
4.监视设置
5.监视对象里面把监视浏览器去掉