using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

namespace SkiveTest.Ajax
{
    public partial class FeedWriter : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            Response.Write("here we go");
            
            
            string connStr = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["skiveConnectionString1"].ToString();

            try
            {
                using (SqlConnection connection = new SqlConnection(connStr))
                {

                    string commandText = "getAllURIs";

                    SqlCommand command = new SqlCommand(commandText, connection);

                    command.CommandType = CommandType.StoredProcedure;

                    connection.Open();

                    using (SqlDataReader dataReader = command.ExecuteReader())
                    {

                        while (dataReader.Read())
                        {

                            Response.Write("<b>" + dataReader["feed_uri"] + "</b>" + ", " +
                            dataReader["title"] + ", " + dataReader["updated"] +
                            "<br />");
                        }
                    }
                    connection.Close();
                }
            }

            catch (Exception ex)
            {
                Response.Write(ex.Message);
            }
        }
    }
}