public void SetColumnChartInfo(object dataSource, string nameColumn, string valueColumn, string dateTimeColumn,
string lineName,
string title, string yTitle, string valueFormatString)
{
this.ColumnChart1.Series.Clear();
this.ColumnChart1.Graphs.Clear();
this.ColumnChart1.Labels.Clear();
this.ColumnChart1.LegendEnabled = false;
ChartLabel titleLabel = new ChartLabel(title, 60, 20, false, 600, LabelAlignments.Center,
System.Drawing.Color.Black, 18);
this.ColumnChart1.Labels.Add(titleLabel);
ChartLabel yLabel = new ChartLabel(yTitle, 5, 150, true, 20, LabelAlignments.Center,
System.Drawing.Color.Black, 12);
this.ColumnChart1.Labels.Add(yLabel);
DataTable tbl = dataSource as DataTable;
ColumnChartGraph ccg = new ColumnChartGraph();
ccg.EnableViewState = false;
ccg.GraphType = ColumnChartGraphTypes.Column;
ccg.Title = lineName;
foreach (DataRow row in tbl.Rows)
{
string id = row[nameColumn].ToString();
string value = string.IsNullOrEmpty(valueFormatString) ? row[valueColumn].ToString() :
string.Format("{0:" + valueFormatString + "}", row[valueColumn]);
//row[valueColumn].ToString(valueFormatString);
ColumnChartValuesDataItem item = new ColumnChartValuesDataItem(id, value);
ccg.Items.Add(item);
}
this.ColumnChart1.ValuesMin = 0;
this.ColumnChart1.Graphs.Add(ccg);
this.ColumnChart1.DataSource = dataSource;
this.ColumnChart1.DataSeriesIDField = nameColumn;
this.ColumnChart1.DataBind();
// set column label
//
this.ColumnChart1.ColumnDataLabelFormatString = "{value}";
this.ColumnChart1.Visible = true;
this.LineChart1.Visible = false;
}
private void CreateSlice(IList lstGenres)
{
int i = 1;
ColumnChartGraph graph = new ColumnChartGraph();
foreach (string item in lstGenres)
{
ColumnDataPoint objSlice = new ColumnDataPoint();
objSlice.SeriesID = i;
objSlice.Title = item;
objSlice.LabelText = item;
objSlice.Value = Util.GetService(_entityType).GetCountByType(item);
i++;
if (objSlice.Value > 0)
{
graph.DataItems.Add(objSlice);
}
}
columnChart.Graphs.Add(graph);
}
public void SetColumnChartInfo(object dataSource, string nameColumn, string valueColumn, string dateTimeColumn,
string lineName,
string title, string yTitle, string valueFormatString)
{
this.ColumnChart1.Series.Clear();
this.ColumnChart1.Graphs.Clear();
this.ColumnChart1.Labels.Clear();
this.ColumnChart1.LegendEnabled = false;
ChartLabel titleLabel = new ChartLabel(title, 60, 20,false, 600, LabelAlignments.Center ,
System.Drawing.Color.Black , 18);
this.ColumnChart1.Labels.Add(titleLabel);
ChartLabel yLabel = new ChartLabel(yTitle, 5, 150, true, 20, LabelAlignments.Center,
System.Drawing.Color.Black, 12);
this.ColumnChart1.Labels.Add(yLabel);
DataTable tbl = dataSource as DataTable ;
ColumnChartGraph ccg = new ColumnChartGraph();
ccg.EnableViewState = false;
ccg.GraphType = ColumnChartGraphTypes.Column;
ccg.Title = lineName;
foreach (DataRow row in tbl.Rows)
{
string id = row[nameColumn].ToString();
string value = string.IsNullOrEmpty(valueFormatString) ? row[valueColumn].ToString() :
string.Format("{0:" + valueFormatString + "}", row[valueColumn]);
//row[valueColumn].ToString(valueFormatString);
ColumnChartValuesDataItem item = new ColumnChartValuesDataItem(id, value);
ccg.Items.Add(item);
}
this.ColumnChart1.ValuesMin = 0;
this.ColumnChart1.Graphs.Add(ccg);
this.ColumnChart1.DataSource = dataSource;
this.ColumnChart1.DataSeriesIDField = nameColumn;
this.ColumnChart1.DataBind();
// set column label
//
this.ColumnChart1.ColumnDataLabelFormatString = "{value}";
this.ColumnChart1.Visible = true;
this.LineChart1.Visible = false;
}
