首先使用sqlconnection打开数据库教程链接,使用sqlcommand打开Employees数据表,并将数据保存到DataSet对象中。然后以DataSet对象为数据源,建立一个XmlDocument对象,并使用XmlDocuemnt对象的Save方法,将数据保存到指定的XML文件中
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>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("View XML file");}
从数据库的查询结果的数据保存到XML文件
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>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 OleDbDataAdapterstrConnection = "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
C#的做法
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>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("View XML file");}
敢达决战官方正版 安卓版v6.7.9
下载敢达决战 安卓版v6.7.9
下载像素火影骨架佐助 (Perseverance Fire Shadow)手机版v1.16
下载要塞英雄 安卓版v33.20.0-39082670-Android
下载梦想城镇vivo最新版本 安卓版v12.0.1
梦想城镇vivo版是这款卡通风模拟经营类手游的渠道服版本,玩
怦然心动的瞬间 安卓版v1.0
怦然心动的瞬间是一款真人向的恋爱互动游戏,在游戏中玩家将扮演
曼尼汉堡店游戏 安卓版v1.0.3
曼尼汉堡店是一款非常好玩的精品恐怖类型冒险游戏,在这款游戏中
现代总统模拟器去广告版 安卓版v1.0.46
现代总统模拟器是一款休闲养成类游戏,可能对于不少的玩家来说都
现代总统模拟器付费完整版 安卓版v1.0.46
现代总统模拟器高级版在商店是需要付费的,相对于普通版本,高级