<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
vb.net如何读取数据库生成指定格式的xml文件
vb.net如何读取数据库生成指定格式的xml文件
__________________________________________________________________________
1. 数据库中将XML存储,然后返回路径。
2. 将XML作为字符串返回。
__________________________________________________________________________
可能问题描述的不够清除
我是想 根据数据库的建表文件
自动生成一些简单的功能语句
比如 按主键查询 删除 修改等超卓 的sql语句
__________________________________________________________________________
Dim conn As New SqlConnection( "Data Source=.;Initial Catalog=FeichuangMedia;User ID=sa;Password=123 ")
Dim ds As DataSet = New DataSet
conn.Open()
Dim myda As SqlDataAdapter = New SqlDataAdapter(sql, conn)
myda.Fill(ds)
ds.DataSetName = "m_infor_update "
Dim writer As New Xml.XmlTextWriter( "DownXML/m_infor_update.XML ", System.Text.Encoding.Default)
writer.Formatting = System.Xml.Formatting.Indented
writer.Indentation = 4
writer.WriteStartDocument()
ds.WriteXml(writer)
writer.Close()
__________________________________________________________________________
多谢各位了
__________________________________________________________________________
http://www.54it.com.cn
__________________________________________________________________________
直接使用DataSet.WriteXml方法生成xml文档
__________________________________________________________________________
vb.net如何读取数据库生成指定格式的xml文件
vb.net如何读取数据库生成指定格式的xml文件
__________________________________________________________________________
1. 数据库中将XML存储,然后返回路径。
2. 将XML作为字符串返回。
__________________________________________________________________________
可能问题描述的不够清除
我是想 根据数据库的建表文件
自动生成一些简单的功能语句
比如 按主键查询 删除 修改等超卓 的sql语句
__________________________________________________________________________
Dim conn As New SqlConnection( "Data Source=.;Initial Catalog=FeichuangMedia;User ID=sa;Password=123 ")
Dim ds As DataSet = New DataSet
conn.Open()
Dim myda As SqlDataAdapter = New SqlDataAdapter(sql, conn)
myda.Fill(ds)
ds.DataSetName = "m_infor_update "
Dim writer As New Xml.XmlTextWriter( "DownXML/m_infor_update.XML ", System.Text.Encoding.Default)
writer.Formatting = System.Xml.Formatting.Indented
writer.Indentation = 4
writer.WriteStartDocument()
ds.WriteXml(writer)
writer.Close()
__________________________________________________________________________
多谢各位了
__________________________________________________________________________
http://www.54it.com.cn
__________________________________________________________________________
直接使用DataSet.WriteXml方法生成xml文档
__________________________________________________________________________