根据数据库生成xml二法
类别: ASP.NET教程 
SqlConnection conn = new SqlConnection();
![\"\"](\"http://www.jiao-cheng.com/Files/BeyondPic/200601/2006-1/19/0611922213524558.gif\")
= \"Server=127.0.0.1;User ID=sa;Password=fdahgdrethj31313210212121;Database=northwind;Persist Security Info=True\";
= new SqlDataAdapter(\"select * from 表\", conn);
= new SqlCommandBuilder(da);
= new DataSet();
@\"C:/temp.xml\");
![\"\"](\"http://www.jiao-cheng.com/Files/BeyondPic/200601/2006-1/19/0611922213839192.gif\")
private void WriteXmlToFile(DataSet thisDataSet) ![\"\"](\"http://www.jiao-cheng.com/Files/BeyondPic/200601/2006-1/19/0611922213997002.gif\"</SPAN)
{
![\"\"](\"http://www.jiao-cheng.com/Files/BeyondPic/200601/2006-1/19/0611922213920798.gif\")
if (thisDataSet == null) { return; }
![\"\"](\"http://www.jiao-cheng.com/Files/BeyondPic/200601/2006-1/19/0611922214090106.gif\")
// 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
// 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);
![\"\"](\"http://www.jiao-cheng.com/Files/BeyondPic/200601/2006-1/19/0611922214315303.gif\")
= \"Server=127.0.0.1;User ID=sa;Password=fdahgdrethj31313210212121;Database=northwind;Persist Security Info=True\";= new SqlDataAdapter(\"select * from 表\", conn);= new SqlCommandBuilder(da);= new DataSet();@\"C:/temp.xml\"); 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// 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); - 上一篇: asp.net生成静态页
- 下一篇: Render方法生成静态页
