01.<%@ Page Language="C#" Debug="true" %>
02.<%@ Import Namespace="System.Data"%>
03.<%@ Import Namespace="System.Data.OleDb"%>
04.<script runat="server">
05. void Page_Load(object sender, EventArgs e)
06. {
07.
08. OleDbConnection objConn = new OleDbConnection();
09. OleDbCommand objCmd = new OleDbCommand();
10. OleDbDataAdapter dtAdapter = new OleDbDataAdapter();
11.
12. DataSet ds = new DataSet();
13. String strConnString,strSQL;
14.
15. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("database/mydatabase.mdb") + ";";
16. strSQL = "SELECT * FROM customer";
17.
18. objConn.ConnectionString = strConnString;
19.
20. objCmd.Connection = objConn;
21. objCmd.CommandText = strSQL;
22. objCmd.CommandType = CommandType.Text;
23.
24. dtAdapter.SelectCommand = objCmd;
25.
26. dtAdapter.Fill(ds);
27.
28. dtAdapter = null;
29. objConn.Close();
30. objConn = null;
31.
32.
33. ds.Tables[0].WriteXml(Server.MapPath("XML/myXml.xml"));
34.
35. ds = null;
36.
37. this.lblText.Text = "XML Created <a href=XML/myXml.xml>click here</a> to view";
38. }
39.</script>
40.<html>
41.<head>
42. <title>ThaiCreate.Com ASP.NET - XML</title>
43.</head>
44.<body>
45. <form id="form1" runat="server">
46. <asp:Label id="lblText" runat="server"></asp:Label>
47. </form>
48.</body>
49.</html>
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
