sql数据库备份文件应另存为XML. [英] sql Database backup file should save as XML.

问题描述

我已经完成了Sql数据库备份和还原项目，因为BackupFile(Data's)应该另存为Xml(File)可以尽快指导我............

解决方案

如果您使用的是ADO，则可以将每个表放入一个DataSet中，并对数据集使用WriteXml()函数. br/>

私有子Button1_Click(ByVal发送者为System.Object，ByVal e为System.EventArgs)处理Button1.Click
昏暗的connetionString作为字符串
昏暗的连接为SqlConnection
昏暗的适配器作为SqlDataAdapter
将Dim ds用作新数据集
昏暗的SQL作为字符串

connetionString =数据源="&Trim(txtServerName.Text)&;初始目录="&Trim(txtDatabaseName.Text)&;用户ID ="&Trim(txtUsername.Text)&; Password ="&Trim (txtPassword.Text)
连接=新的SqlConnection(connetionString)

sql =从银行选择*"

试试
sql =从银行选择*"
connection.Open()
adapter =新的SqlDataAdapter(sql，连接)
adapter.Fill(ds)
connection.Close()
ds.WriteXml("Bank" .xml)
异常捕获
MsgBox(ex.ToString)
结束尝试
''这是我们将数据保存在XML文件NewXMLName.xml中的地方
结束Sub

hi ,

I Have done the Sql DataBase BackUP & Restore Project, in that BackupFile(Data''s) Should Save as an Xml(File) can any Guide me soon ......


Thanks!!

解决方案

If you are using ADO you can just put each table into a DataSet and use the WriteXml() function for the DataSet.

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connetionString As String
Dim connection As SqlConnection
Dim adapter As SqlDataAdapter
Dim ds As New DataSet
Dim sql As String

connetionString = "Data Source=" & Trim(txtServerName.Text) & ";Initial Catalog=" & Trim(txtDatabaseName.Text) & ";User ID=" & Trim(txtUsername.Text) & ";Password=" & Trim(txtPassword.Text)
connection = New SqlConnection(connetionString)

sql = " select * from Bank"

Try
sql = " select * from Bank"
connection.Open()
adapter = New SqlDataAdapter(sql, connection)
adapter.Fill(ds)
connection.Close()
ds.WriteXml("Bank".xml")
Catch ex As Exception
MsgBox(ex.ToString)
End Try
''This is where we are saving the data in an XML file NewXMLName.xml
End Sub

这篇关于sql数据库备份文件应另存为XML.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！