using System; using System.Data; using System.Data.Sql; using System.Data.SqlClient; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class varunda : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { Response.ContentType = "text/xml"; Response.Write(""); SqlCommand cmd = new SqlCommand("SELECT * FROM inimesed FOR XML AUTO, ROOT('inimesed')", new SqlConnection(ConfigurationManager.ConnectionStrings["baas1ConnectionString2"].ConnectionString)); cmd.Connection.Open(); Response.Write(cmd.ExecuteScalar() as string) ; cmd.Connection.Close(); } }