namespace PlanningCalendar
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private String connectionString = "Data Source=.\\DATABAS;Initial Catalog=TestDB1;Integrated Security=SSPI;";
        private SqlConnection connection;

        public void dateTimePicker1_ValueChanged(object sender, EventArgs e)
        {
            string test = dateTimePicker1.Value.Date.ToShortDateString();
            textBox1.Text = test;

            LoadActivity();
        }

        public void InsertActivity(object sender, EventArgs e)
        {
            string activityString = textBox1.Text;
            using (connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand("INSERT INTO Activity VALUES('" + activityString + "')", connection);
                command.Connection.Open();
                command.ExecuteNonQuery();
            }
        }

        public void LoadActivity()
        {
            using (connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand("SELECT Activity FROM Planner", connection);
                command.Connection.Open();
                //SqlDataReader reader = command.ExecuteReader();
                //textBox1.Text = reader.GetString(0);
            }
        }
    }
}