c# – 如何将PL / SQL输出(clob)保存为XML文件？

function XML_ExportAppRestrictions() {
try {

    var data = {"action": "exportAppRestrictions"};

    var returned = AjaxLoad('Modules/Common/Common.aspx',null,data,false);

    if (returned.toString().toUpperCase().substring(0,5) == "ERROR") {
        return;
    }
    else {
        // should the file be saved here or in my aspx page using xmldoc.save?
        // Using xmldoc.save will only be able to save the file on the server yes?
    }
}
    catch (ex) {
        alert(ex.Message);
    }
}

if (Request["action"] == "exportAppRestrictions")
    {

        // Create and open DB connection
        conn.ConnectionString = SG_Common.CommonClass.NetRegUDL;
        common.OpenDBConnection(ref conn);

        // Create command and set SQL statement
        cmd.Connection = conn;
        cmd.CommandType = System.Data.CommandType.Text;
        // select text was removed below due to it's length
        cmd.CommandText = "select x as AppRestrictions from dual";

        rd = cmd.ExecuteReader();

        if (rd.HasRows)
        {
            if (rd.Read())
            {
                str = rd["AppRestrictions"].ToString();
            }
        }
        rd.Close();

        System.Xml.XmlDocument xmldoc = new System.Xml.XmlDocument();
        xmldoc.InnerXml = str;
        xmldoc.Save("c:xmltest.xml");

        goto Done;
    }

    // Done runs in a seperate try/catch statement and only returns data to the calling js function.
    Done:
        Response.Write(str);

XML应该只是UTF8纯文本.我已经使用了序列化对象.也许有人会纠正我,但我没有发现有必要对纯文本或二进制数据使用序列化.

为了将这些数据通过内存,有一个很好的StackOverflow answer here显示了如何使用MemoryStream和字节缓冲区.

因为如果你可以把它放到byte []缓冲区,你可以做something like this：

public bool SaveDocument( Byte[] docbinaryarray,string docname)
{
    string strdocPath;
    strdocPath = "C:DocumentDirectory" + docname;
    FileStream objfilestream =new FileStream(strdocPath,FileMode.Create,FileAccess.ReadWrite);
    objfilestream.Write(docbinaryarray,docbinaryarray.Length);
    objfilestream.Close();
    return true;
}

参见here for some more info on System.IO methods,例如：

StreamWriter writer = new StreamWriter("c:KBTest.txt");
writer.WriteLine("File created using StreamWriter class.");
writer.Close();
this.listbox1.Items.Clear();
addListItem("File Written to C:KBTest.txt");

更新1(Windows)：

(我以为你在寻找System.Windows.Forms.SaveFileDialog)

以下是此MSDN示例代码：

private void button2_Click(object sender,System.EventArgs e)
{
   // Displays a SaveFileDialog so the user can save the Image
   // assigned to Button2.
   SaveFileDialog saveFileDialog1 = new SaveFileDialog();
   saveFileDialog1.Filter = "JPeg Image|*.jpg|Bitmap Image|*.bmp|Gif Image|*.gif";
   saveFileDialog1.Title = "Save an Image File";
   saveFileDialog1.ShowDialog();

   // If the file name is not an empty string open it for saving.
   if(saveFileDialog1.FileName != "")
   {
      // Saves the Image via a FileStream created by the OpenFile method.
      System.IO.FileStream fs = 
         (System.IO.FileStream)saveFileDialog1.OpenFile();
      // Saves the Image in the appropriate ImageFormat based upon the
      // File type selected in the dialog box.
      // NOTE that the FilterIndex property is one-based.
      switch(saveFileDialog1.FilterIndex)
      {
         case 1 : 
             this.button2.Image.Save(fs,System.Drawing.Imaging.ImageFormat.Jpeg);
         break;

         case 2 : 
         this.button2.Image.Save(fs,System.Drawing.Imaging.ImageFormat.Bmp);
         break;

         case 3 : 
         this.button2.Image.Save(fs,System.Drawing.Imaging.ImageFormat.Gif);
         break;
      }

   fs.Close();
   }
}

并且,正如它所说,您需要注册事件处理程序：

this.button2.Click += new System.EventHandler(this.button2_Click);

更新2(网站)：

好的,我发现你实际上正在寻找一个Web解决方案.我在想Windows而不是Web. Here’s what you have to do on the Web side.这是一个VB.NET示例,但我假设您可以翻译：

string FileName = "Hello.doc";
string Filename = strFileName.Substring(0,FileName.LastIndexOf("."));                      
Response.AppendHeader("Content-Disposition","attachment; filename=" + FileName);
Response.TransmitFile(Server.MapPath("~/Folder_Name/" + FileName));
Response.End();

我已经多次对这种方法做过变种.您将XML文件发送回用户的浏览器.一旦它到达那里,用户必须决定如何处理它(通常,“打开这个文件,或保存它？”).这是在浏览者的控制之下.

您可以通过包含一个内容类型标题来帮助浏览器,该标题告诉浏览器它正在查看哪种文件,以及应该尝试打开它的内容.所以这个标题会要求它调用Excel：

Response.AppendHeader("Content-Type","application/vnd.ms-excel");

您经常会看到application / pdf,它将提升Adobe Reader或用户正在使用的任何其他PDF阅读器.在这里,您将要使用内容类型“text / xml”.这里的内容类型不太重要,因为我们打算让用户保存文件,而不是用应用程序打开它.

内容处理“附件”与“内联”存在一些问题.尝试两种方式,看看哪一个更适合你.其中一个(我不记得哪个)基本上忽略了你发送它的建议文件名,而是使用你的ASP页面的名称.很烦人. Firefox至少将此作为一个错误记录,IE显然只是认为它是另一个“功能”.