How do I also export result returned from my search query

Question

1.00/5 (1 vote)

See more:

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

Posted 7-Oct-16 4:52am

Mcbaloo

Updated 7-Oct-16 9:36am

Add a Solution

Comments

Vincent Maverick Durano 7-Oct-16 13:27pm

You just need to change the datasource of your GridView with the search result set.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

manu_dhobale · Accepted Answer · 2016-10-07T09:36:00

Get your searched datatable and use it for exporting

C#

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

C#

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();
}