private void btnSelect_Click(object sender, EventArgs e)
        {
            if (cboReport.SelectedItem == "Report 1")
            {
                ReportDataSet.Clear();
                string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=courses&quarter=1";

                ReportDataSet.ReadXml(filePath);
            }
            else if (cboReport.SelectedItem == "Report 2")
            {
                ReportDataSet.Clear();
                string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=courses&quarter=2";

                ReportDataSet.ReadXml(filePath);
            }
            else if (cboReport.SelectedItem == "Report 3")
            {
                ReportDataSet.Clear();
                string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=courses&quarter=3";

                ReportDataSet.ReadXml(filePath);
            }
            else if (cboReport.SelectedItem == "Report 4")
            {
                ReportDataSet.Clear();
                string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=courses&quarter=4";

                ReportDataSet.ReadXml(filePath);
            }
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            btnSelect.TabStop   = false;
            btnSelect.FlatStyle = FlatStyle.Flat;
            btnSelect.FlatAppearance.BorderSize = 0;

            btnViewComment.TabStop   = false;
            btnViewComment.FlatStyle = FlatStyle.Flat;
            btnViewComment.FlatAppearance.BorderSize = 0;

            btnAddComment.TabStop   = false;
            btnAddComment.FlatStyle = FlatStyle.Flat;
            btnAddComment.FlatAppearance.BorderSize = 0;

            btnCancel.TabStop   = false;
            btnCancel.FlatStyle = FlatStyle.Flat;
            btnCancel.FlatAppearance.BorderSize = 0;

            btnSearch.TabStop   = false;
            btnSearch.FlatStyle = FlatStyle.Flat;
            btnSearch.FlatAppearance.BorderSize = 0;


            //using (StreamReader sr = new StreamReader("Settings.txt"))
            //{
            //    while (sr.Peek() != -1)
            //    {
            //        this.BackColor = (sr.Read);
            //    }
            //}


            // combo box
            cboReport.Items.Add("Report 1");
            cboReport.Items.Add("Report 2");
            cboReport.Items.Add("Report 3");
            cboReport.Items.Add("Report 4");

            //fill datagrid
            string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=courses&quarter=1";

            ReportDataSet.ReadXml(filePath);

            dgvAll.DataSource = ReportDataSet;
            ReportDataSet.Clear();
            dgvAll.DataMember = "course";

            dgvAll.Columns[0].HeaderText = "Course";
            dgvAll.Columns[1].HeaderText = "Quater";
            dgvAll.Columns[2].HeaderText = "Course Cost";
            dgvAll.Columns[3].HeaderText = "Hours";
            dgvAll.Columns[4].HeaderText = "Cost With Travel";
            dgvAll.Columns[5].HeaderText = "Location";
            dgvAll.Columns[6].HeaderText = "Number of Enrolements";
            dgvAll.Columns[7].HeaderText = "Raw Total Cost";
            dgvAll.Columns[8].HeaderText = "Total Cost With Travel";
            dgvAll.Columns[9].HeaderText = "Total Hours";
        }
        private void btnSearch_Click(object sender, EventArgs e)
        {
            ReportDataSet.Clear();
            string filePath = "http://nestor.sunderland.ac.uk/~bg69qw/accenture-courses/api.php?key=213958403&type=search&query=" + txtSearch.Text;

            ReportDataSet.ReadXml(filePath);

            dgvAll.DataSource = ReportDataSet;
        }