private void BindChartData() { DataSet ds = new DataSet(); //Getting the dataSet ds = rpt.GetComputersDetailsByDistrictRespdent(); //Get the no of series first.. this will be a distinct series list.. List<string> seriesList = new List<string>(); foreach (DataRow row in ds.Tables[0].Rows) { string seriesName = row["Computers Per Category"].ToString(); if (!seriesList.Contains(seriesName)) seriesList.Add(seriesName); } //Now bind the xValues and yVlaues for each series foreach (string seriesName in seriesList) { List<string> xValues = new List<string>(); List<int> yValues = new List<int>(); foreach (DataRow row in ds.Tables[0].Rows) { string xValue = row["District Names"].ToString(); int yValue = Convert.ToInt32(row["No of Computers"]); string sName = row["Respondent"].ToString(); if (sName == seriesName) { xValues.Add(xValue); yValues.Add(yValue); } } Chart1.Series.Add(seriesName); Chart1.Series[seriesName].ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Bar; Chart1.Series[seriesName].ChartArea = "ChartArea1"; Chart1.Series[seriesName].Legend = "Legend1"; Chart1.Series[seriesName].LegendText = seriesName; Chart1.Series[seriesName].Points.DataBindXY(xValues, yValues); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)