Moram napomenuti da ne znam ništa o asp.net-u ali mi je igrom slučaja zatrebao radi xml-a.
Kreirao sam xml:
<html>
<body>
<%@ Import Namespace="System.Xml" %>
<%@ Import Namespace="System.Text" %>
<script language="C#" runat="server">
void Page_Load(object sender, EventArgs e)
{
// Create a new XmlTextWriter instance
XmlTextWriter writer = new
XmlTextWriter(Server.MapPath("baza.xml"), Encoding.UTF8);
// PROPERTIES
writer.WriteStartDocument();
writer.WriteStartElement("properties");
// PROPERTY
writer.WriteStartElement("property");
writer.WriteElementString("property-id", "id_nekretnine");
writer.WriteElementString("language", "jezik");
writer.WriteElementString("date-listed", "kreirano");
writer.WriteElementString("property-type", "tip nekretnine");
writer.WriteElementString("listing-type", "za prodaju, iznajmljivanje");
writer.WriteStartElement("price");
writer.WriteElementString("amount", "125000");
writer.WriteElementString("currency", "EURO");
writer.WriteEndElement();
//KRAJ - PRICE
writer.WriteStartElement("property-size");
writer.WriteElementString("number", "87");
writer.WriteElementString("unit", "square feet");
writer.WriteEndElement();
//KRAJ - property-size
writer.WriteStartElement("location");
writer.WriteElementString("postal-code", "poštanski broj");
writer.WriteElementString("city", "Neki_grad");
writer.WriteEndElement();
//KRAJ - location
writer.WriteElementString("title", "Novi kvalitetan apartman");
writer.WriteElementString("description", "Opis apartmana");
writer.WriteStartElement("features");
writer.WriteElementString("bathrooms", "1");
writer.WriteElementString("bedrooms", "2");
writer.WriteElementString("age", "2003");
writer.WriteElementString("floor", "1");
writer.WriteEndElement();
//KRAJ - features
writer.WriteElementString("link", "link na taj oglas");
writer.WriteStartElement("images");
writer.WriteElementString("image", "link na sliku oglasa");
writer.WriteEndElement();
//KRAJ - images
writer.WriteEndElement();
// KRAJ - PROPERTY
writer.WriteEndElement();
writer.WriteEndDocument();
writer.Close();
}// VOID
</script>
</body>
</html>
A sad bih trebao izvuči podatke iz baze i naravno koliko ima oglasa toliko puta će se to kreiranje poavljati.
Umjesto vrijednosti koje sam napisao gore ići će vrijednosti iz baze.
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
sub Page_Load
dim dbconn,sql,dbcomm,dbread
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Inetpub\asp\baza.mdb")
dbconn.Open()
sql="SELECT * FROM nekretnine"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
nekretnine.DataSource=dbread
nekretnine.DataBind()
dbread.Close()
dbconn.Close()
end sub
</script>
<html>
<body>
<form runat="server">
<asp:Repeater id="nekretnine" runat="server">
<HeaderTemplate>
<table border="1" width="100%">
<tr>
<th>Adresa</th>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td><%#Container.DataItem("adresa")%></td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</form>
</body>
</html>
Uspio sam ispisati jedan podatak iz baze ali ne znam spojti taj dio sa dijelom za kreiranje.