How to generate xml in Database
This article mainly introduces "how to generate xml in the database". In the daily operation, I believe that many people have doubts about how to generate xml in the database. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about how to generate xml in the database. Next, please follow the editor to study!
The first example method:
1 SqlConnection conn = new SqlConnection ()
2 conn.ConnectionString = "Server=127.0.0.1;User
ID=sa;Password=fdahgdrethj31313210212121
Database=northwind;Persist Security Info=True "
3 conn.Open ()
4 SqlDataAdapter da = new SqlDataAdapter ("select * from Table", conn)
5 SqlCommandBuilder thisBulder = new SqlCommandBuilder (da)
6 DataSet ds = new DataSet ()
7 da.Fill (ds)
8 ds.WriteXml (@ "C:/temp.xml")
The second example method:
1 private void WriteXmlToFile (DataSet thisDataSet)
2 {
3 if (thisDataSet = = null) {return;}
4 / / Create a file name to write to.
5 string filename = "myXmlDoc.xml"
6 / / Create the FileStream to write with.
7 System.IO.FileStream myFileStream = new System.IO.FileStream
8 (filename, System.IO.FileMode.Create)
9 / / Create an XmlTextWriter with the fileStream.
10 System.Xml.XmlTextWriter myXmlWriter =
11 new System.Xml.XmlTextWriter
(myFileStream, System.Text.Encoding.Unicode)
12 / / Write to the file with the WriteXml method.
13 thisDataSet.WriteXml (myXmlWriter)
14 myXmlWriter.Close ()
15}
At this point, the study on "how to generate xml in the database" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!
