根据数据库生成xml二法
收藏
SqlConnection conn = new SqlConnection(); conn.ConnectionString = "Server=127.0.0.1;User ID=sa;Password=fdahgdrethj31313210212121;Database=northwind;Persist Security Info=True"; conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from 表", conn); SqlCommandBuilder thisBulder = new SqlCommandBuilder(da); DataSet ds = new DataSet(); da.Fill(ds); ds.WriteXml(@"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 (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();
}发表于 @ 2005年08月22日 17:16:00 | 评论( loading... ) | 举报| 收藏
旧一篇:生成xml | 新一篇:Render方法生成静态页
- 查看最新精华文章 请访问博客首页相关文章
-
- 发表评论
-
- 表 情：
-
- 评论内容：
- 用 户 名：