asp.net 数据库数据转换成xml文件方法

首先使用sqlconnection打开数据库教程链接，使用sqlcommand打开Employees数据表，并将数据保存到DataSet对象中。然后以DataSet对象为数据源，建立一个XmlDocument对象，并使用XmlDocuemnt对象的Save方法，将数据保存到指定的XML文件中

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script language="c#" runat="server">

  void Page_Load(Object sender, EventArgs e)
  {
    String strConnection, strSQL;
    DataSet objDataSet = new DataSet();
    OleDbConnection objConnection = null;
    OleDbDataAdapter objAdapter = null;

    strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; ";
    strConnection += "Data Source=" + Server.MapPath("Northwind.mdb");
    strSQL = "SELECT FirstName, LastName FROM Employees;";

    objConnection = new OleDbConnection(strConnection);
    objAdapter = new OleDbDataAdapter(strSQL, objConnection);

    objAdapter.Fill(objDataSet, "Employees");

    objDataSet.WriteXml(Server.MapPath("Employees2.xml"));
   
    Response.Write("<a href='Employees2.xml'>View XML file</a>");

  }

</script>

从数据库的查询结果的数据保存到XML文件

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script language="VB" runat="server">

  Sub Page_Load(Sender As Object, E As EventArgs)

    Dim strConnection As String
    Dim strSQL        As String
    Dim objDataSet    As New DataSet()
    Dim objConnection As OleDbConnection
    Dim objAdapter    As OleDbDataAdapter

    strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
                    "Data Source="+MapPath("EmployeeDatabase.mdb")
    strSQL = "SELECT FirstName, LastName FROM Employee;"

    objConnection = New OledbConnection(strConnection)
    objAdapter = New OledbDataAdapter(strSQL, objConnection)

    objAdapter.Fill(objDataSet, "Employees")

    objDataSet.WriteXml(Server.MapPath("Employee2.xml"))
   
    Response.Write("XML File Generated")

  End Sub

</script>

C#的做法

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script language="c#" runat="server">

  void Page_Load(Object sender, EventArgs e)
  {
    String strConnection, strSQL;
    DataSet objDataSet = new DataSet();
    OleDbConnection objConnection = null;
    OleDbDataAdapter objAdapter = null;

    strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; ";
    strConnection += "Data Source=" + Server.MapPath("Northwind.mdb");
    strSQL = "SELECT FirstName, LastName FROM Employees;";

    objConnection = new OleDbConnection(strConnection);
    objAdapter = new OleDbDataAdapter(strSQL, objConnection);

    objAdapter.Fill(objDataSet, "Employees");

    objDataSet.WriteXml(Server.MapPath("Employees2.xml"));
   
    Response.Write("<a href='Employees2.xml'>View XML file</a>");

  }

</script>