将2 gridview导出到excel

Question

我有 2 个 gridview，其作用类似于产品类别和产品目录。 每个类别都有很少的产品。

现在，在用户选择类别并查看产品目录后，我想在 Excel

示例中导出这两个： 所选产品类别：“水果” 目录是：“苹果、香蕉、橙子”

我想存储选定的产品类别以及目录。

目前，我只能导出产品目录列表。（简单地将1个gridview导出到excel）

我希望我说清楚。

我在 asp.net C# 上运行，

按钮上的当前代码单击是

 string filename = String.Format("Survey Results_{0}_{1}.xls",
    DateTime.Today.Month.ToString(), DateTime.Today.Year.ToString());

    Response.Clear();
    Response.AddHeader("Content-Disposition", "attachment;filename=" + filename);
    Response.Charset = "";

    // SetCacheability doesn't seem to make a difference (see update)
    Response.Cache.SetCacheability(System.Web.HttpCacheability.NoCache);

    Response.ContentType = "application/vnd.xls";

    System.IO.StringWriter stringWriter = new System.IO.StringWriter();
    System.Web.UI.HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);

    // Replace all gridview controls with literals
    ClearControls(GridView2);

    // Throws exception: Control 'ComputerGrid' of type 'GridView'
    // must be placed inside a form tag with runat=server.
    // ComputerGrid.RenderControl(htmlWrite);

    // Alternate to ComputerGrid.RenderControl above
    System.Web.UI.HtmlControls.HtmlForm form
        = new System.Web.UI.HtmlControls.HtmlForm();
    Controls.Add(form);

    form.Controls.Add(GridView2);
    form.RenderControl(htmlWriter);

    Response.Write(stringWriter.ToString());
    Response.End();

Answer 1

也许您可以尝试通过加入结果在代码隐藏中构建动态gridview，而不是输出gridview2，您将必须导出动态生成的<代码>gridview。