Example #1
0
    protected void btnExport_Click(object sender, EventArgs e)
    {
        DataSet ds = DoQuery();
        DvsManager dm = new DvsManager();
        if (dm.Export(ds.Tables[0], Server.MapPath("~/Tmp/") + hlkExportFile.Text))
        {

            Response.Clear();
            Response.Charset = "GB2312";
            Response.Buffer = true;
            Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            Response.AppendHeader("Content-Disposition", "attachment;filename=" + hlkExportFile.Text);
            Response.ContentType = "application/ms-excel";
            Response.WriteFile(Server.MapPath("~/Tmp/") + hlkExportFile.Text);
            Response.Flush();
            Response.Close();
            Response.End();
        }
        else
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), "失败", "<script>alert('查询结果导出失败,请联系管理员!')</script>");
        }
    }
Example #2
0
    protected void btnExport_Click(object sender, EventArgs e)
    {
        DataSet    ds = DoQuery();
        DvsManager dm = new DvsManager();

        if (dm.Export(ds.Tables[0], Server.MapPath("~/Tmp/") + hlkExportFile.Text))
        {
            Response.Clear();
            Response.Charset         = "GB2312";
            Response.Buffer          = true;
            Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            Response.AppendHeader("Content-Disposition", "attachment;filename=" + hlkExportFile.Text);
            Response.ContentType = "application/ms-excel";
            Response.WriteFile(Server.MapPath("~/Tmp/") + hlkExportFile.Text);
            Response.Flush();
            Response.Close();
            Response.End();
        }
        else
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), "失败", "<script>alert('查询结果导出失败,请联系管理员!')</script>");
        }
    }