protected void RadChartLoad()
{
SqlCommand cmd = new SqlCommand("SP_GetChartData_MaleFemale", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@IMODE", SqlDbType.Int).Value = 1;
DataSet dsChart = new DataSet();
GenderChart.DataBind();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dsChart);
if (dsChart != null && dsChart.Tables.Count > 0 && dsChart.Tables[0].Rows.Count > 0)
{
GenderChart.DataSource = dsChart.Tables[0];
GenderChart.DataBind();
GenderChart.BackColor = Color.FloralWhite;
}
else
{
GenderChart.DataSource = new String[] { };
GenderChart.DataBind();
}
}
private void LoadAcademicYear()
{
GenderChart.DataSource = Statistic_Manager.Instance.getData("chart_AcademicYear");
GenderChart.Series["Series1"].XValueMember = "Academic_Year";
GenderChart.Series["Series1"].YValueMembers = "Total";
GenderChart.Titles[0].Visible = false;
GenderChart.Titles[1].Visible = false;
GenderChart.Titles[2].Visible = true;
GenderChart.DataBind();
}
private void LoadDataBuidling()
{
GenderChart.DataSource = Statistic_Manager.Instance.getData("chart_building");
GenderChart.Series["Series1"].XValueMember = "Building";
GenderChart.Series["Series1"].YValueMembers = "Total";
GenderChart.Titles[0].Visible = false;
GenderChart.Titles[1].Visible = true;
GenderChart.Titles[2].Visible = false;
GenderChart.DataBind();
}