using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.Sql;
using System.Data.SqlClient;

public partial class varundusxml : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //Response.Write("tere");
      SqlConnection cn = new SqlConnection(
        @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\kursusebaas.mdf;" +
        "Integrated Security=True;User Instance=True");
      SqlCommand cm = new SqlCommand(
            "SELECT aeg, pealkiri, jutt FROM teated "+
            "FOR XML RAW('teade'), ROOT('teateloetelu'), ELEMENTS", cn);
      cn.Open();
      string vastus = cm.ExecuteScalar().ToString();
      Response.ContentType = "text/xml";
      Response.Write("<?xml version='1.0'?>");
      Response.Write(vastus);
      Response.End();
    }
}