 |
|
|
 |
 |
|
Code (VB.NET)
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb"%>
<script runat="server">
Sub Page_Load(sender As Object, e As EventArgs)
Dim objConn As New OleDbConnection
Dim objCmd As New OleDbCommand
Dim dtAdapter As New OleDbDataAdapter
Dim ds As New DataSet
Dim strConnString,strSQL As String
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("database/mydatabase.mdb")&";"
strSQL = "SELECT * FROM customer"
objConn.ConnectionString = strConnString
With objCmd
.Connection = objConn
.CommandText = strSQL
.CommandType = CommandType.Text
End With
dtAdapter.SelectCommand = objCmd
dtAdapter.Fill(ds)
dtAdapter = Nothing
objConn.Close()
objConn = Nothing
'*** Export XML ***'
ds.Tables(0).WriteXML(Server.MapPath("XML/myXml.xml"))
'ds.Tables(0).WriteXmlSchema(Server.MapPath("XML/myXml.xml"))
ds = Nothing
Me.lblText.Text = "XML Created <a href=XML/myXml.xml>click here</a> to view"
End Sub
</script>
<html>
<head>
<title>ThaiCreate.Com ASP.NET - XML</title>
</head>
<body>
<form id="form1" runat="server">
<asp:Label id="lblText" runat="server"></asp:Label>
</form>
</body>
</html>
Ref : ASP.NET Generating XML From DataSet
|
 |
 |
 |
 |
| Date :
2009-04-22 16:48:29 |
By :
webmaster |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
คือไม่ต้องการให้มัน save เป็น xml ครับ แต่ให้แสดง xml บน Browser ครับ ตัวอย่างโค๊ดเขียนด้วย asp
Code (VB.NET)
<%
response.ContentType = "text/xml"
set conn=Server.CreateObject("ADODB.Connection")
conn.provider="Microsoft.Jet.OLEDB.4.0;"
conn.open server.mappath("/db/database.mdb")
sql="select fname,lname from tblGuestBook"
set rs=Conn.Execute(sql)
response.write("<?xml version='1.0' encoding='ISO-8859-1'?>")
response.write("<guestbook>")
while (not rs.EOF)
response.write("<guest>")
response.write("<fname>" & rs("fname") & "</fname>")
response.write("<lname>" & rs("lname") & "</lname>")
response.write("</guest>")
rs.MoveNext()
wend
rs.close()
conn.close()
response.write("</guestbook>")
%>
ผลลัพธ์จะได้แบบนี้
http://www.w3schools.com/xml/guestbook.asp
ซึ่งเขาเขียนด้วย asp ถ้าเราจะเขียนเป็นแบบ asp.net ต้องเปลี่ยนอะไรบ้างครับ
|
| |
|
|
| |
| Date :
2009-04-22 16:57:53 |
By :
different |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
หลักการเหมือนกันน่ะครับ ลองดูตัวอย่างนี้น่ะครับ
Code (VB.NET)
<%@ Page Language="VB" %>
<script runat="server">
Sub Page_Load(sender As Object, e As EventArgs)
Response.Clear()
Response.AddHeader("Content-Disposition", "Attachment;Filename=Word.doc")
Response.Buffer = True
Response.Charset = "UTF-8"
Response.ContentType = "application/vnd.word"
Response.write("<table width=500 border=1>")
Response.write(" <tr>")
Response.write(" <td>Column1</td>")
Response.write(" <td>Column2</td>")
Response.write(" <td>Column3</td>")
Response.write(" </tr>")
Response.write(" <tr>")
Response.write(" <td>1</td>")
Response.write(" <td>2</td>")
Response.write(" <td>3</td>")
Response.write(" </tr>")
Response.write(" <tr>")
Response.write(" <td>4</td>")
Response.write(" <td>5</td>")
Response.write(" <td>6</td>")
Response.write(" </tr>")
Response.write("</table>")
End Sub
</script>
|
| |
|
|
| |
| Date :
2009-04-23 18:16:44 |
By :
webmaster |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
จะลองดูครับ ขอบคุณมากครับ
|
| |
|
|
| |
| Date :
2009-04-24 17:46:48 |
By :
different |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Code (C#)
using System;
using System.Xml;
using System.Text;
public partial class create_xml_writer : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
XmlWriterSettings settings = new XmlWriterSettings();
settings.Indent = true;
settings.Encoding = Encoding.UTF8;
string xmlDoc = Server.MapPath("products-xmlwriter.xml");
using (XmlWriter writer = XmlWriter.Create(xmlDoc, settings))
{
writer.WriteStartDocument();
writer.WriteStartElement("products");
writer.WriteStartElement("product");
writer.WriteAttributeString("id", "p3");
writer.WriteElementString("name", "Alpha");
writer.WriteElementString("price", "1200");
writer.WriteElementString("stock", "19");
writer.WriteElementString("country", "Germany");
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteEndDocument();
}
Response.Redirect("products-xmlwriter.xml");
}
|
| |
|
|
| |
| Date :
2012-10-03 15:50:32 |
By :
ผ่านไป |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
