config.scriptsExportButton_Click C# (CSharp) 메소드

    protected void scriptsExportButton_Click(object sender, EventArgs e)
    {
        //  DataSet d = OSAESql.RunSQL("SELECT * FROM osae_script");
        DataSet d = OSAESql.RunSQL("CALL osae_sp_script_export_all");
        d.DataSetName = "Scripts";
        d.Tables[0].TableName = "Script";

        //  MemoryStream s = new MemoryStream();
        // d.WriteXml(s);
        foreach (DataTable tab in d.Tables)
        {
            foreach (DataRow drow in tab.Rows)
                Response.Write(drow[0].ToString());
        }

          //  Response.BinaryWrite(s.ToArray());
        Response.ContentType = "text/sql";
        Response.AddHeader("Content-Disposition", "attachment; filename=Scripts.sql");
        Response.End();
    }