最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
asp.net 数据库数据转换成xml文件方法
时间:2022-06-25 06:04:14 编辑:袖梨 来源:一聚教程网
首先使用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");}
相关文章
- 根据XRP历史上的抛售阶段分析,分析师预测火箭式上涨至9.5美元或37.5美元 07-01
- 和平精英爆裂萌兔技能是什么 爆裂萌兔技能介绍 07-01
- 燕云十六声最新全门派 晋升地位攻略及门规 07-01
- 策略:如何买币:新手指南,轻松入门加密货币投资 07-01
- 软件工程师向XRP持有者发出关键安全警告 07-01
- 最终幻想14水晶世界配置要求 FF14手游设备推荐 07-01