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; }