更新时间:2023-02-03 15:14:26
从此处开始: http ://msdn.microsoft.com/en-us/library/ms178107.aspx [ ^ ]
您可以使用XQuery进行xml操作,
检查网址,
http://www.simple-talk.com /sql/learn-sql-server/the-xml-methods-in-sql-server/ [ StringWriter strWriter = new StringWriter(); XmlTextWriter xmlWriter =新的XmlTextWriter(strWriter); xmlWriter.WriteStartElement("RootNode"); //您可以在其中具有所需的表名,而不是RootNode. SqlConnection mySqlConnection; mySqlConnection =新的SqlConnection(sConnection); mySqlConnection.Open(); XmlReader xmlReader = new SqlCommand("Select * From Table1 FOR XML AUTO,Elements",mySqlConnection).ExecuteXmlReader(); xmlWriter.WriteNode(xmlReader,true); xmlReader.Close(); xmlWriter.WriteEndElement(); mySqlConnection.Close();
您将在strWriter中拥有xml字符串.您可以使用XmlSerializer
class.
或,
您可以从以下链接获得帮助
http://blogs. msdn.com/b/saurabh_singh/archive/2010/05/11/export-sql-table-records-to-xml-form.aspx [解决方案