将数据集转换为XML

本文关键字：XML 转换 数据集 | 更新日期: 2023-09-27 18:16:36

我已经被这个问题困扰了几个小时了，似乎不能弄清楚，所以我在这里问一下:)

好的，我有了这个函数:

private void XmlDump()
{
    XDocument doc = new XDocument(new XDeclaration("1.0", "utf-8", "yes"));
    XElement rootElement = new XElement("dump");
    rootElement.Add(TableToX("Support"));
    string connectionString = ConfigurationManager.ConnectionStrings["MyDb"].ConnectionString;
    SqlConnection con = new SqlConnection(connectionString);
    string sql = "select * from support";
    SqlDataAdapter da = new SqlDataAdapter(sql, con);
    DataSet ds = new DataSet("Test");
    da.Fill(ds, "support");
    // Convert dataset to XML here
    var docresult = // Converted XML
    Response.Write(docResult);
    Response.ContentType = "text/xml; charset=utf-8";
    Response.AddHeader("Content-Disposition", "attachment; filename=test.xml");
    Response.End();
}

我一直在尝试各种不同的东西，但我一直得到错误，所以我离开了如何将数据集转换为XML部分空白。

另外，这个查询包含有特殊字符的列

将数据集转换为XML

您可以使用ds.WriteXml，但这需要您有一个Stream来输入输出。如果您希望以字符串形式输出，请尝试以下扩展方法:

public static class Extensions
{
    public static string ToXml(this DataSet ds)
    {
        using (var memoryStream = new MemoryStream())
        {
            using (TextWriter streamWriter = new StreamWriter(memoryStream))
            {
                var xmlSerializer = new XmlSerializer(typeof(DataSet));
                xmlSerializer.Serialize(streamWriter, ds);
                return Encoding.UTF8.GetString(memoryStream.ToArray());
            }
        }
    }
}

用法:

var xmlString = ds.ToXml();
// OR
Response.Write(ds.ToXml());

直接使用Dataset.getXml():

doc.LoadXml(ds.GetXml());

像下面这样写代码部分

DataTable dt = new DataTable("MyData");
dt.WriteXml(@Application.StartupPath + "''DataBaseValues.xml");

或者，您也可以像Oded所说的那样直接转换dataSet，

private void WriteXmlToFile(DataSet thisDataSet)
{
   if (thisDataSet == null) 
   {
      return;
   }
   // Create a file name to write to.
   string filename = "myXmlDoc.xml";
   // Create the FileStream to write with.
   System.IO.FileStream myFileStream = new System.IO.FileStream(filename, System.IO.FileMode.Create);
   // Create an XmlTextWriter with the fileStream.
   System.Xml.XmlTextWriter myXmlWriter = 
   new System.Xml.XmlTextWriter(myFileStream, System.Text.Encoding.Unicode);
   // Write to the file with the WriteXml method.
   thisDataSet.WriteXml(myXmlWriter);   
   myXmlWriter.Close();
}

使用DataSet.WriteXml -它将以XML形式输出数据集

如果ds是你的数据集..

可以使用:

ds.getXml();

这有助于获取XML

我们也可以使用

<>之前私有函数DsToXML(DataSet ds)作为system . xml . xmldatadodocument将xmlDoc设置为system . xml . xmldatadodocumentDim xmlDec As System.Xml.XmlDeclaration将xmlWriter设置为System.Xml.XmlWriterxmlWriter = New xmltextwwriter (context.Response.OutputStream,System.Text.Encoding.UTF8)xmlDoc = New system . xml . xmldatadodocument (ds)xmldoc . dataset . enforcecconstraints = FalsexmlDec = xmlDoc.CreateXmlDeclaration("1.0"， "UTF-8"，无)xmlDoc.PrependChild (xmlDec)xmlWriter xmlDoc.WriteTo ()xmlDoc Retuen结束Eunction

试试这个。

static XmlDocument xdoc = new XmlDocument(); //static; since i had to access this file someother place too
protected void CreateXmlFile(DataSet ds) 
    {
      //ds contains sales details in this code; i.e list of products along with quantity and unit
      //You may change attribute acc to your needs ; i.e employee details in the below code
        string salemastid = lbl_salemastid.Text;
        int i = 0, j=0;
        String str = "salemastid:" + salemastid;
        DataTable dt = ds.Tables[0];
        string xml = "<Orders>" ;
         while (j < dt.Rows.Count)
         {
             int slno = j + 1;
             string sl = slno.ToString();
             xml += "<SlNo>" + sl +"</SlNo>" +
                       "<PdtName>" + dt.Rows[j][0].ToString() + "</PdtName>" +
                       "<Unit>" + dt.Rows[j][1].ToString() + "</Unit>" +
                       "<Qty>" + dt.Rows[j][2].ToString() + "</Qty>";
             j++;
         }
         xml += "</Orders>";
         xdoc.LoadXml(xml);
         //Here the xml is prepared and loaded in xml DOM.
         xdoc.Save(Server.MapPath("Newsales.xml"));
         //You may also use some other names instead of 'Newsales.xml'
         //to get a downloadable file use the below code
         System.IO.MemoryStream stream = new System.IO.MemoryStream();
                XmlTextWriter xwriter = new XmlTextWriter(stream, System.Text.Encoding.UTF8);
                xdoc.WriteTo(xwriter);
                xwriter.Flush();
                Response.Clear();
                Encoding.UTF8.GetString(stream.ToArray());
                byte[] byteArray = stream.ToArray();
                Response.AppendHeader("Content-Disposition", "filename=OrderRequest.xml");
                Response.AppendHeader("Content-Length", byteArray.Length.ToString());
                Response.ContentType = "application/octet-stream";
                Response.BinaryWrite(byteArray);
                xwriter.Close();
                stream.Close();
        }
相关文章：