Hi,
I'm trying to create a XML document looking like this:
<?xml version="1.0" encoding="UTF-8"?>
<rss>
<Header>
<FromDate>2006-10-01</FromDate>
<ToDate>2007-06-01</ToDate>
<EmployeeID>1</EmployeeID>
</Header>
<Schedule>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>00:00</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>00:15</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>00:30</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>00:45</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>01:00</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>01:15</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>01:30</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>01:45</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>02:00</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>02:15</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>02:30</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>02:45</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
....... Alot of <Quarterremoved to make this easier to read.
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>22:00</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>22:15</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>22:30</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>22:45</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>23:00</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>23:15</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>23:30</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
<Quarter>
<CollectionID>0</CollectionID>
<Day>1</Day>
<Time>23:45</Time>
<TreatmentID>0</TreatmentID>
<CustomerID>0</CustomerID>
</Quarter>
</Schedule>
</rss>
My first main problem is to get </Quartertags inside the <Scheduletag.
My Code so far look like this:
using System;
using System.IO;
using System.Xml;
// Webb Service
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
// Database
using System.Data;
using System.Data.SqlClient;
// Web.Config Configuration
using System.Configuration;
[WebService(Namespace = "BBN2.WebServices")]
public class Service : WebService
{
[WebMethod]
public XmlDocument GetTemplate()
{
SqlConnection myConnection = new
SqlConnection(ConfigurationManager.AppSettings["ConnectionInfo"]);
SqlDataAdapter myCommand = new SqlDataAdapter("SELECT id,
CollectionID, Day, Time, TreatmentID, CustomerID from Templates",
myConnection);
DataSet ds = new DataSet();
ds.DataSetName = "rss";
myCommand.Fill(ds, "Quarter");
XmlDataDocument doc = null;
doc = new XmlDataDocument(ds);
// ds.EnforceConstraints = false;
// XmlElement elm2 = doc.CreateElement("Header");
// elm2.InnerText = "test";
// doc.DocumentElement.AppendChild(elm2);
return doc;
}
}
Does anyone have any ide how I can solve this problem?
Reagrds,
Magnus