aspx导出数据方法

导出的按钮位置不能再ajax的控件范围内

 前面既然说到了Ajax不能操作用户机的底层，那还怎么优雅的起来？

引入第三方包：

fileDownload.js

 fileDownload.js的用法

 最后达到如下效果：

 $.fileDownload('/url/to/download.pdf', {

    successCallback: function (url) {
 
        alert('You just got a file download dialog or ribbon for this URL :' + url);
    },
    failCallback: function (html, url) {
 
        alert('Your file download just failed for this URL:' + url + '\r\n' +
                'Here was the resulting error HTML: \r\n' + html
                );
    }
}); 

1、导出txt

private static void Export(DataTable tb, string fileName)
{
HttpContext.Current.Response.Clear();
string FileName = fileName + ".txt";
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.Charset = "GB2312";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
HttpContext.Current.Response.ContentType = "application/ms-text";
System.IO.StringWriter sw = new System.IO.StringWriter();
for (int i = 0; i < tb.Rows.Count; i++)
{
for (int j = 0; j < tb.Columns.Count; j++)
{
sw.WriteLine(tb.Rows[i][j].ToString().Trim() +"\t");
}
sw.WriteLine("\r\n");
}
HttpContext.Current.Response.Write(sw.ToString());
sw.Close();
HttpContext.Current.Response.End();

}

2、导出excel

private void PutExcel2Client()
{
string exportFile = _exportReportFileName;

System.IO.FileInfo file = new System.IO.FileInfo(exportFile);
HttpResponse contextResponse = HttpContext.Current.Response;
contextResponse.Redirect(string.Format("~/UploadFile/ExportExcelFile/{0}", Path.GetFileNameWithoutExtension(TemplateName)
+ "_" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls"), false);
HttpContext.Current.Response.Clear();
// HttpContext.Current.Response.Charset = "GB2312";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
// 添加头信息，为"文件下载/另存为"对话框指定默认文件名
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpContext.Current.Server.UrlEncode(file.Name));
// 添加头信息，指定文件大小，让浏览器能够显示下载进度
HttpContext.Current.Response.AddHeader("Content-Length", file.Length.ToString());

// 指定返回的是一个不能被客户端读取的流，必须被下载
HttpContext.Current.Response.ContentType = "application/ms-excel";

// 把文件流发送到客户端
HttpContext.Current.Response.WriteFile(file.FullName);
// 停止页面的执行

HttpContext.Current.Response.End();
}

 

asp.net 文件下载的五种方式

前端HTML代码部分：
<div>
1.通过超链接下载：<a href="../DownLoadFiles/logo.zip">点击下载</a><br />
<!-- 一样的效果 -->
1.通过超链接下载：<a href="/DownLoadFiles/logo.zip">点击下载</a><br />
2.通过Response对象的TransmitFile方法（这个方法下载下来的是整个网页：DownLoadFile.aspx）：<asp:Button runat="server" ID="btnDownload" Text="点击下载" OnClick="btnDownload_Click" /><br />
3.WriteFile实现下载：<asp:Button runat="server" ID="btnDownload2" Text="点击下载" OnClick="btnDownload_Click2" /><br />
4.WriteFile分块下载：<asp:Button runat="server" ID="btnDownload3" Text="点击下载" OnClick="btnDownload_Click3" /><br />
5.字符流方式下载文件：<asp:Button runat="server" ID="btnDownload4" Text="点击下载" OnClick="btnDownload_Click4" />
</div>

后端类部分：
第一种方法：
超链接的形式下载：html代码中已实现

第二种方法：
protected void btnDownload_Click(object sender, EventArgs e)
{
//这种方法会把整个网页下载下来
//TransmitFile实现下载
/*
微软为Response对象提供了一个新的方法TransmitFile来解决使用Response.BinaryWrite
下载超过400mb的文件时导致Aspnet_wp.exe进程回收而无法成功下载的问题。
代码如下：
*/

//文件下载，所以文件头也含有zip
Response.ContentType = "application/x-zip-compressed";
Response.AddHeader("Content-Disposition", "attachment:filename=logo.zip");
//找到文件的绝对路径
string filename = Server.MapPath(".") + "/DownLoadFiles/logo.zip";
Response.TransmitFile(filename);

}

第三种方法：
protected void btnDownload_Click2(object sender, EventArgs e)
{
//WriteFile实现下载
string fileName = "logo.zip";//客户端保存的文件名
string filePath = Server.MapPath(".") + "/DownLoadFiles/logo.zip";//路径
FileInfo fileInfo = new FileInfo(filePath);
Response.Clear();
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("Content-Disposition", "attachment;filename=" + fileName);
Response.AddHeader("Content-Length", fileInfo.Length.ToString());
Response.AddHeader("Content-Transfer-Encoding", "binary");
Response.ContentType = "application/octet-stream";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
Response.WriteFile(fileInfo.FullName);
Response.Flush();
Response.End();
}

第四种方法：
protected void btnDownload_Click3(object sender, EventArgs e)
{
//WriteFile分块下载
string fileName = "logo.zip";//客户端保存的文件名
string filePath = Server.MapPath(".") + "/DownLoadFiles/logo.zip";//路径
System.IO.FileInfo fileInfo = new System.IO.FileInfo(filePath);
if (fileInfo.Exists == true)
{
const long ChunkSize = 409600;//100K 每次读取文件，只读取100Ｋ，这样可以缓解服务器的压力
byte[] buffer = new byte[ChunkSize];
Response.Clear();
System.IO.FileStream iStream = System.IO.File.OpenRead(filePath);
long dataLengthToRead = iStream.Length;//获取下载的文件总大小
//Response.ContentType = "application/x-zip-compressed"; //可以改成zip哦
Response.ContentType = "application/octet-stream"; //也可以不改哦
Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(fileName));
while (dataLengthToRead > 0 && Response.IsClientConnected)
{
int lengthRead = iStream.Read(buffer, 0, Convert.ToInt32(ChunkSize));//读取的大小
Response.OutputStream.Write(buffer, 0, lengthRead);
Response.Flush();
dataLengthToRead = dataLengthToRead - lengthRead;
}
Response.Close();
}
}

第五种方法：
protected void btnDownload_Click4(object sender, EventArgs e)
{
//字符流方式下载文件
string fileName = "logo.zip";//客户端保存的文件名
string filePath = Server.MapPath(".") + "/DownLoadFiles/logo.zip";//路径

//以字符流的形式下载文件
FileStream fs = new FileStream(filePath, FileMode.Open);
byte[] bytes = new byte[(int)fs.Length];
fs.Read(bytes, 0, bytes.Length);
fs.Close();
Response.ContentType = "application/octet-stream";//通知浏览器下载文件而不是打开
Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8));
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
}

若是要在网页直接打开话，要设置对应的ContentType,若下这样既可

//以字节流方式

 

FileStream fs = new FileStream(fileName, FileMode.Open);
byte[] bytes = new byte[(int)fs.Length];
fs.Read(bytes, 0, bytes.Length);
fs.Close();

 

  Response.ContentType= "image/jpg";

Response.BinaryWrite(bytes);

Response.Flush();
Response.End();

 //以文件方式

  Response.ContentType= "image/jpg";

Response.WriteFile(fileName);