如何在单击按钮时创建用于选择目的地的浏览窗口

Question

我有一个简单的按钮将数据库表导出从MySQL到excel文件。到目前为止，它的目的地是硬编码到C:/ drive的。当您按下导出按钮时，您会自动将excel文件导出到C：，而用户无法看到它。代码如下：

//button for Exporting to Excel (.xls)
    //hardcoded destination to C:/
    protected void Button2_Click(object sender, EventArgs e)
    {
        try
        {
            string connectionString = "server=localhost; UserId=root; database=dbcss; ";
            MySqlConnection con = new MySqlConnection(connectionString);

            con.Open();
            string getProject = ddlProjectID.SelectedValue; //get the already selected project from the dropdown menu

            //create sql command object
            string cmdText = "SELECT 'activity_id', 'activity_name', 'wbs_no', 'activity_status', 'wbs_name', 'sequence', 'pad', 'project_id', 'start_date', 'finish_date' INTO OUTFILE 'C://TASK.xls' FROM management WHERE project_id = '" + getProject + "';";

            MySqlCommand cmd = new MySqlCommand(cmdText, con);

            cmd.ExecuteNonQuery();
            con.Close();

        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.ToString());
        }

    }

如何创建窗口弹出窗口，您可以在其中浏览pc并选择目的地？

任何帮助都将受到感谢;)

Answer 1

您必须更改响应头和内容类型，并将文件发送回浏览器：

试试这些：

Send query results to Excel from ASP.NET website

One click ASP.NET export button control for Excel/CSV file