将datatable中的数据转换为xml（字符串）格式并存储在数据库中，并在需要时从数据库中重新获取数据。 [英] To convert datas in datatable to xml(string) format and store in database,and regain the datas back from database when needed.

问题描述

嗨..

我想将存储在数据表中的数据传输到xml格式..它不应该是文档。应该是字符串格式，并且从该字符串我必须重新获得数据表中的数据，其中存储的类型...我怎样才能使用textwriter。请帮助我...

提前谢谢..

swathi。

Hi..
I want to transfer datas stored in a datatable to xml format..which should not be a document.should be in a string format,and from that string i have to regain the datas in datatable in which type its stored there...How can i do this using textwriter.Help me please...
Thanks in advance..
swathi.

推荐答案

通常，您可以直接在数据库中存储数据，而无需在其间使用XML。但是，如果您出于某种原因希望拥有它，请尝试使用 SoapFormatter [ ^ ]类。

Normally, you would store your data from the datatable in the database directly, without using XML in between. But if you, for whatever reason, want to have that, try serialization with the SoapFormatter[^] class.

您好，



请参考以下链接，你可能会找到你的解决方案。



http://sandit27.wordpress.com/2009/01/18/how-to-convert-datatable-to-xml-in-c/ [ ^ ]

StringBuilder stringBuilder = new StringBuilder(string.Empty);
            StringWriter stringWriter = new StringWriter(stringBuilder);
            DataSet dsMemmoryList = new DataSet();
            dsMemmoryList.Tables.Clear();
            DataTable dtMemmoryList = new DataTable();
            dtMemmoryList.Columns.Add("RowNumber");
            dtMemmoryList.Columns.Add("AccessionNo");
            DataRow drLoan;
            int rowNumber = 1;
            foreach (string accession in accessionCollecion)
            {
                drLoan = dtMemmoryList.NewRow();
                drLoan[0] = rowNumber;
                drLoan[1] = accession;
                dtMemmoryList.Rows.Add(drLoan);
                rowNumber++;
            }
            dsMemmoryList.Tables.Add(dtMemmoryList);
            dsMemmoryList.WriteXml(stringWriter, XmlWriteMode.WriteSchema);
            string string1 = "\\\"";
            string string2 = "\"";
            string xml = Convert.ToString(stringBuilder);
            xml = xml.Replace(string1, string2);
            return xml;

这篇关于将datatable中的数据转换为xml（字符串）格式并存储在数据库中，并在需要时从数据库中重新获取数据。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！