void pieChart1() { conn.Open(); SqlDataAdapter pBugStatus = new SqlDataAdapter("SELECT Status, count(ID) as BugNumber from BugData where ReporterID = '" + UserIDHP.ToString() + "' AND Status != 'Closed' group by Status", conn); DataTable dt = new DataTable(); pBugStatus.Fill(dt); pieBugStatus.DataSource = dt; pieBugStatus.ChartAreas["ChartArea1"].AxisX.Title = "Status"; pieBugStatus.ChartAreas["ChartArea1"].AxisX.Title = "BugNumber"; pieBugStatus.Series["Status"].XValueMember = "Status"; pieBugStatus.Series["Status"].YValueMembers = "BugNumber"; conn.Close(); }
void barChart1() { conn.Open(); SqlDataAdapter barBugStatus = new SqlDataAdapter("SELECT Status, count(ID) as BugNumber from BugData where ReporterID = '" + UserIDHP.ToString() + "' group by Status", conn); DataTable dt1 = new DataTable(); barBugStatus.Fill(dt1); chrDefectStatus.DataSource = dt1; chrDefectStatus.ChartAreas["ChartArea1"].AxisX.Title = "Status"; chrDefectStatus.ChartAreas["ChartArea1"].AxisX.Title = "Bug Number"; chrDefectStatus.Series["Status"].XValueMember = "Status"; chrDefectStatus.Series["Status"].YValueMembers = "BugNumber"; conn.Close(); }