如何导出从搜索查询返回的结果 [英] How do I also export result returned from my search query

问题描述

我的asp.net Web应用程序中有一个gridview。我想将此gridview上的记录导出为ex​​cel。当我将所有记录导出到excel时，它完美地工作。我现在的问题是，我有一个下拉列表（从gridview中的名称搜索），文本框和一个提交按钮，只是关于gridview。我根据从数据库返回的结果填充了gridview。我也想将这些记录导出到excel。每次我点击进行搜索并点击我的导出到Excel按钮，导出保存到我​​的数据库中的所有记录。我只希望从我的搜索按钮返回的记录也被导出



我尝试过：



这是我导出到excel的代码。就像我说的那样，当我想将gridview上的所有记录导出为ex​​cel时，它完美地说话

private void ExportGridToExcel（）

{



Response.Clear（）;



Response.ClearContent（）;

Response.ClearHeaders（）;



string FileName =Example+ DateTime.Now +。xls;

StringWriter writter = new StringWriter（）;

HtmlTextWriter html = new HtmlTextWriter（writter）;

Response.ContentType =application / vnd.ms-excel;

Response.AddHeader（ Content-Disposition，附件，文件名+ FileName;

GridView1.HeaderStyle.Font.Bold = true;

GridView1.AllowPaging = false;



search.BindData（）;

GridView1.DataSource = sear ch.table;

GridView1.DataBind（）;

GridView1.RenderControl（html）;

Response.Write（writter.ToString（） ）;

Response.End（）;

}

protected void Bexcel_Click（object sender，EventArgs e）

{

ExportGridToExcel（）;

}

我如何修改它以导出从我的搜索查询返回的记录

i have a gridview in my asp.net web application. i want to export records on this gridview to excel. It works perfectly when i export all the records to excel. the issue i'm having now is that, i have a dropdown list(to search from names inside the gridview ), textbox and a submit button just about the gridview. I populated the gridview based on the result returned from the database. i also want to export this records to excel. each time i click do the search and click my "export to excel" button, all the records saved into my db are exported. i only want the records returned from my search button to be exported also

What I have tried:

here is my code for exporting to excel. Like i said, it words perfectly when i want to export all the records on the gridview to excel
private void ExportGridToExcel()
{

Response.Clear();

Response.ClearContent();
Response.ClearHeaders();

string FileName = "Example" + DateTime.Now + ".xls";
StringWriter writter = new StringWriter();
HtmlTextWriter html = new HtmlTextWriter(writter);
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment,filename" + FileName);
GridView1.HeaderStyle.Font.Bold = true;
GridView1.AllowPaging = false;

search.BindData();
GridView1.DataSource = search.table;
GridView1.DataBind();
GridView1.RenderControl(html);
Response.Write(writter.ToString());
Response.End();
}
protected void Bexcel_Click(object sender, EventArgs e)
{
ExportGridToExcel();
}
How do i modify this to also export records returned from my search query

推荐答案

获取搜索到的数据表并将其用于导出

Get your searched datatable and use it for exporting

protected void Bexcel_Click(object sender, EventArgs e)
{
    DataTable table = GetSearchedData();
    ExportGridToExcel(table);
}

private void ExportGridToExcel(DataTable table)
{

    Response.Clear();
    Response.ClearContent();
    Response.ClearHeaders();

    string FileName = "Example" + DateTime.Now + ".xls";
    StringWriter writter = new StringWriter();
    HtmlTextWriter html = new HtmlTextWriter(writter);
    Response.ContentType = "application/vnd.ms-excel";
    Response.AddHeader("Content-Disposition", "attachment,filename" + FileName);
    GridView1.HeaderStyle.Font.Bold = true;
    GridView1.AllowPaging = false;

    GridView1.DataSource = table;
    GridView1.DataBind();
    GridView1.RenderControl(html);
    Response.Write(writter.ToString());
    Response.End();
}

这篇关于如何导出从搜索查询返回的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！