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