dynamic generation of charts

[POP]

hi,
how do i generate multiple charts from code behind in c# without dragging them onto the designer at first ?
eg..
i want to generate 'n' number of charts depending on the value of 'n' i get from the database. since i dont know the value of 'n' before hand i cant drag and drop those number of objects in the designer.
my sample code is pasted below :

//generate 3 different charts
for (int k = 0; k < 3; k++)
{
Database db = DatabaseFactory.CreateDatabase();
DataSet ds = db.ExecuteDataSet(CommandType.Text, "select * from datavalues order by bench");

Steema.TeeChart.Web.WebChart webchart1 = new Steema.TeeChart.Web.WebChart();
Steema.TeeChart.Chart Chart1 = webchart1.Chart;

Steema.TeeChart.Axis bottomAxis = Chart1.Axes.Left;
bottomAxis.Automatic = false;
bottomAxis.Increment = 0.5;
bottomAxis.Maximum = 5;
bottomAxis.Minimum = 0;

//3 different bar graphs on each chart
for (int j = 0; j < 3; j++)
{
Steema.TeeChart.Styles.Bar bar1 = new Steema.TeeChart.Styles.Bar(Chart1);
bar1.YValues.DataMember = ds.Tables[0].Columns[2].ToString();
bar1.DataSource = ds.Tables[0];
bar1.Title = "crap" + j;
}
}


with this i get a blank screen.

what am i doing wrong?
could you please suggest a smple code for this?

thanks,
POP.

[Narcís]

Hi POP,

To dynamically generate WebCharts you need to use Response.Write to write HTML to the browser as done here:

Code: Select all

  protected Steema.TeeChart.Web.WebChart WebChart1;

    protected void Page_Load(object sender, EventArgs e)
    {

      WebChart1 = new Steema.TeeChart.Web.WebChart();
      WebChart1.ID = "WebChart1";

      WebChart1.GetChartFile = "GetChart.aspx";
      WebChart1.TempChart = Steema.TeeChart.Web.TempChartStyle.Session;

      Steema.TeeChart.Chart ch1 = WebChart1.Chart;

      ch1.Series.RemoveAllSeries();
      ch1.Series.Add(new Steema.TeeChart.Styles.Pie());
      (ch1.Series[0] as Steema.TeeChart.Styles.Pie).Circled = true;
      (ch1.Series[0] as Steema.TeeChart.Styles.Pie).Pen.Visible = true;

      ch1.Series[0].FillSampleValues();

      ch1.Legend.Shadow.Visible = false;
      ch1.Legend.Visible = false;

      // Apply palette                          
      Steema.TeeChart.Themes.ColorPalettes.ApplyPalette(ch1.Chart, 7);

      //Response.Write("<tchart:WebChart id=\"WebChart1\" style=\"Z-INDEX: 104; LEFT: 56px; POSITION: absolute; TOP: 56px\" runat=\"server\"Width=\"760px\" Height=\"448px\" TempChart=\"File\" ClickedY=\"0\" ClickedX=\"0\" GetChartFile=\"GetChart.aspx\" AutoPostback=\"False\" Config=\"AAEAAAD/////AQAAAAAAAAAMAgAAAAhUZWVDaGFydAwDAAAADlN5c3RlbS5EcmF3aW5nBQEAAAAVU3RlZW1hLlRlZUNoYXJ0LkNoYXJ0dgAAAAYuV2lkdGgVLlBhbmVsLlNoYWRvdy5WaXNpYmxlFS5XYWxscy5SaWdodC5BdXRvSGlkZRsuV2FsbHMuUmlnaHQuU2hhZG93LlZpc2libGUULldhbGxzLkJhY2suQXV0b0hpZGUaLldhbGxzLkJhY2suU2hhZG93LlZpc2libGUWLldhbGxzLkJvdHRvbS5BdXRvSGlkZRwuV2FsbHMuQm90dG9tLlNoYWRvdy5WaXNpYmxlFC5XYWxscy5MZWZ0LkF1dG9IaWRlGi5XYWxscy5MZWZ0LlNoYWRvdy5WaXNpYmxlFi5Gb290ZXIuU2hhZG93LlZpc2libGUbLkZvb3Rlci5Gb250LlNoYWRvdy5WaXNpYmxlFi5IZWFkZXIuU2hhZG93LlZpc2libGUbLkhlYWRlci5Gb250LlNoYWRvdy5WaXNpYmxlDS5IZWFkZXIuTGluZXMZLlN1YkhlYWRlci5TaGFkb3cuVmlzaWJsZR4uU3ViSGVhZGVyLkZvbnQuU2hhZG93LlZpc2libGUbLkxlZ2VuZC5Gb250LlNoYWRvdy5WaXNpYmxlHC5MZWdlbmQuVGl0bGUuU2hhZG93LlZpc2libGUhLkxlZ2VuZC5UaXRsZS5Gb250LlNoYWRvdy5WaXNpYmxlFy5MZWdlbmQuVGl0bGUuRm9udC5Cb2xkGS5MZWdlbmQuVGl0bGUuUGVuLlZpc2libGUIU2VyaWVzLjAXLlNlcmllcy4wLlhWYWx1ZXMuVmFsdWUXLlNlcmllcy4wLlhWYWx1ZXMuQ291bnQXLlNlcmllcy4wLlhWYWx1ZXMuT3JkZXIjLlNlcmllcy4wLk1hcmtzLkZvbnQuU2hhZG93LlZpc2libGUeLlNlcmllcy4wLk1hcmtzLkNhbGxvdXQuTGVuZ3RoHi5TZXJpZXMuMC5NYXJrcy5DYWxsb3V0LkRyYXczRB0uU2VyaWVzLjAuTWFya3MuQ2FsbG91dC5TdHlsZSAuU2VyaWVzLjAuTWFya3MuQ2FsbG91dC5EaXN0YW5jZSEuU2VyaWVzLjAuTWFya3MuQ2FsbG91dC5BcnJvd0hlYWQjLlNlcmllcy4wLk1hcmtzLkNhbGxvdXQuQnJ1c2guQ29sb3IlLlNlcmllcy4wLk1hcmtzLkNhbGxvdXQuQXJyb3dIZWFkU2l6ZRcuU2VyaWVzLjAuTGluZVBlbi5Db2xvcg8uU2VyaWVzLjAuVGl0bGUbLlNlcmllcy4wLlBvaW50ZXIuUGVuLkNvbG9yGS5TZXJpZXMuMC5Qb2ludGVyLlZpc2libGUdLlNlcmllcy4wLlBvaW50ZXIuQnJ1c2guQ29sb3IXLlNlcmllcy4wLlBvaW50ZXIuU3R5bGUXLlNlcmllcy4wLllWYWx1ZXMuVmFsdWUXLlNlcmllcy4wLllWYWx1ZXMuQ291bnQcLlNlcmllcy4wLllWYWx1ZXMuRGF0YU1lbWJlcghTZXJpZXMuMRcuU2VyaWVzLjEuWFZhbHVlcy5WYWx1ZRcuU2VyaWVzLjEuWFZhbHVlcy5Db3VudBcuU2VyaWVzLjEuWFZhbHVlcy5PcmRlciMuU2VyaWVzLjEuTWFya3MuRm9udC5TaGFkb3cuVmlzaWJsZR4uU2VyaWVzLjEuTWFya3MuQ2FsbG91dC5MZW5ndGgeLlNlcmllcy4xLk1hcmtzLkNhbGxvdXQuRHJhdzNEHS5TZXJpZXMuMS5NYXJrcy5DYWxsb3V0LlN0eWxlIC5TZXJpZXMuMS5NYXJrcy5DYWxsb3V0LkRpc3RhbmNlIS5TZXJpZXMuMS5NYXJrcy5DYWxsb3V0LkFycm93SGVhZCMuU2VyaWVzLjEuTWFya3MuQ2FsbG91dC5CcnVzaC5Db2xvciUuU2VyaWVzLjEuTWFya3MuQ2FsbG91dC5BcnJvd0hlYWRTaXplFy5TZXJpZXMuMS5MaW5lUGVuLkNvbG9yDy5TZXJpZXMuMS5UaXRsZRsuU2VyaWVzLjEuUG9pbnRlci5QZW4uQ29sb3IZLlNlcmllcy4xLlBvaW50ZXIuVmlzaWJsZR0uU2VyaWVzLjEuUG9pbnRlci5CcnVzaC5Db2xvchcuU2VyaWVzLjEuUG9pbnRlci5TdHlsZRcuU2VyaWVzLjEuWVZhbHVlcy5WYWx1ZRcuU2VyaWVzLjEuWVZhbHVlcy5Db3VudBwuU2VyaWVzLjEuWVZhbHVlcy5EYXRhTWVtYmVyBy5IZWlnaHQTLkdyYXBoaWNzM0QuWENlbnRlchUuR3JhcGhpY3MzRC5QZW4uQ29sb3ITLkdyYXBoaWNzM0QuWUNlbnRlch8uR3JhcGhpY3MzRC5Gb250LlNoYWRvdy5WaXNpYmxlGi5HcmFwaGljczNELlN1cHBvcnRzM0RUZXh0HC5HcmFwaGljczNELlJvdGF0aW9uQ2VudGVyLlkcLkdyYXBoaWNzM0QuUm90YXRpb25DZW50ZXIuWhwuR3JhcGhpY3MzRC5Sb3RhdGlvbkNlbnRlci5YHS5HcmFwaGljczNELlRleHRSZW5kZXJpbmdIaW50FS5HcmFwaGljczNELkJhY2tDb2xvchUuR3JhcGhpY3MzRC5Vc2VCdWZmZXIZLkdyYXBoaWNzM0QuQnJ1c2guVmlzaWJsZRkuR3JhcGhpY3MzRC5TbW9vdGhpbmdNb2RlB1Rvb2xzLjAVLlRvb2xzLjAuWm9vbVBlbkNvbG9yGC5Ub29scy4wLkN1c3RvbVZhcmlhYmxlcxguVG9vbHMuMC5ab29tQ2FudmFzSW5kZXgHVG9vbHMuMRUuVG9vbHMuMS5ab29tUGVuQ29sb3IYLlRvb2xzLjEuQ3VzdG9tVmFyaWFibGVzGC5Ub29scy4xLlpvb21DYW52YXNJbmRleBkuU3ViRm9vdGVyLlNoYWRvdy5WaXNpYmxlHi5TdWJGb290ZXIuRm9udC5TaGFkb3cuVmlzaWJsZRouQXhlcy5SaWdodC5HcmlkLlpQb3NpdGlvbiEuQXhlcy5SaWdodC5MYWJlbHMuU2hhZG93LlZpc2libGUmLkF4ZXMuUmlnaHQuTGFiZWxzLkZvbnQuU2hhZG93LlZpc2libGUgLkF4ZXMuUmlnaHQuVGl0bGUuU2hhZG93LlZpc2libGUlLkF4ZXMuUmlnaHQuVGl0bGUuRm9udC5TaGFkb3cuVmlzaWJsZRsuQXhlcy5Cb3R0b20uR3JpZC5aUG9zaXRpb24iLkF4ZXMuQm90dG9tLkxhYmVscy5TaGFkb3cuVmlzaWJsZScuQXhlcy5Cb3R0b20uTGFiZWxzLkZvbnQuU2hhZG93LlZpc2libGUhLkF4ZXMuQm90dG9tLlRpdGxlLlNoYWRvdy5WaXNpYmxlJi5BeGVzLkJvdHRvbS5UaXRsZS5Gb250LlNoYWRvdy5WaXNpYmxlGi5BeGVzLkRlcHRoLkdyaWQuWlBvc2l0aW9uIS5BeGVzLkRlcHRoLkxhYmVscy5TaGFkb3cuVmlzaWJsZSYuQXhlcy5EZXB0aC5MYWJlbHMuRm9udC5TaGFkb3cuVmlzaWJsZSAuQXhlcy5EZXB0aC5UaXRsZS5TaGFkb3cuVmlzaWJsZSUuQXhlcy5EZXB0aC5UaXRsZS5Gb250LlNoYWRvdy5WaXNpYmxlGS5BeGVzLkxlZnQuR3JpZC5aUG9zaXRpb24gLkF4ZXMuTGVmdC5MYWJlbHMuU2hhZG93LlZpc2libGUlLkF4ZXMuTGVmdC5MYWJlbHMuRm9udC5TaGFkb3cuVmlzaWJsZR8uQXhlcy5MZWZ0LlRpdGxlLlNoYWRvdy5WaXNpYmxlJC5BeGVzLkxlZnQuVGl0bGUuRm9udC5TaGFkb3cuVmlzaWJsZRguQXhlcy5Ub3AuR3JpZC5aUG9zaXRpb24fLkF4ZXMuVG9wLkxhYmVscy5TaGFkb3cuVmlzaWJsZSQuQXhlcy5Ub3AuTGFiZWxzLkZvbnQuU2hhZG93LlZpc2libGUeLkF4ZXMuVG9wLlRpdGxlLlNoYWRvdy5WaXNpYmxlIy5BeGVzLlRvcC5UaXRsZS5Gb250LlNoYWRvdy5WaXNpYmxlHS5BeGVzLkRlcHRoVG9wLkdyaWQuWlBvc2l0aW9uJC5BeGVzLkRlcHRoVG9wLkxhYmVscy5TaGFkb3cuVmlzaWJsZSkuQXhlcy5EZXB0aFRvcC5MYWJlbHMuRm9udC5TaGFkb3cuVmlzaWJsZSMuQXhlcy5EZXB0aFRvcC5UaXRsZS5TaGFkb3cuVmlzaWJsZSguQXhlcy5EZXB0aFRvcC5UaXRsZS5Gb250LlNoYWRvdy5WaXNpYmxlAAAAAAAAAAAAAAAAAAAGAAAAAAAAAAEHAAQAAAAEAAQEAAQBBAAEBAcAAQEHAAQAAAAEAAQEAAQBBAAEBAcAAQAABAAAAAAAAAQEAAAEAQQBAAEEAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgBAQEBAQEBAQEBAQEBAQEBAQEBAQYIJVN0ZWVtYS5UZWVDaGFydC5TdHlsZXMuVmFsdWVMaXN0T3JkZXICAAAAAQgBJFN0ZWVtYS5UZWVDaGFydC5TdHlsZXMuUG9pbnRlclN0eWxlcwIAAAAIJlN0ZWVtYS5UZWVDaGFydC5TdHlsZXMuQXJyb3dIZWFkU3R5bGVzAgAAABRTeXN0ZW0uRHJhd2luZy5Db2xvcgMAAAAIFFN5c3RlbS5EcmF3aW5nLkNvbG9yAwAAABRTeXN0ZW0uRHJhd2luZy5Db2xvcgMAAAABFFN5c3RlbS5EcmF3aW5nLkNvbG9yAwAAACRTdGVlbWEuVGVlQ2hhcnQuU3R5bGVzLlBvaW50ZXJTdHlsZXMCAAAABggGCCVTdGVlbWEuVGVlQ2hhcnQuU3R5bGVzLlZhbHVlTGlzdE9yZGVyAgAAAAEIASRTdGVlbWEuVGVlQ2hhcnQuU3R5bGVzLlBvaW50ZXJTdHlsZXMCAAAACCZTdGVlbWEuVGVlQ2hhcnQuU3R5bGVzLkFycm93SGVhZFN0eWxlcwIAAAAUU3lzdGVtLkRyYXdpbmcuQ29sb3IDAAAACBRTeXN0ZW0uRHJhd2luZy5Db2xvcgMAAAAUU3lzdGVtLkRyYXdpbmcuQ29sb3IDAAAAARRTeXN0ZW0uRHJhd2luZy5Db2xvcgMAAAAkU3RlZW1hLlRlZUNoYXJ0LlN0eWxlcy5Qb2ludGVyU3R5bGVzAgAAAAYICAgUU3lzdGVtLkRyYXdpbmcuQ29sb3IDAAAACAEBCAgIJVN5c3RlbS5EcmF3aW5nLlRleHQuVGV4dFJlbmRlcmluZ0hpbnQDAAAAFFN5c3RlbS5EcmF3aW5nLkNvbG9yAwAAAAEBJlN5c3RlbS5EcmF3aW5nLkRyYXdpbmcyRC5TbW9vdGhpbmdNb2RlAwAAABRTeXN0ZW0uRHJhd2luZy5Db2xvcgMAAAAIFFN5c3RlbS5EcmF3aW5nLkNvbG9yAwAAAAgBAQYBAQEBBgEBAQEGAQEBAQYBAQEBBgEBAQEGAQEBAQIAAAAQAQAAAAAAAAAAAAAAAAAAAAkEAAAAAAAAAAABAAYFAAAAHVN0ZWVtYS5UZWVDaGFydC5TdHlsZXMuUG9pbnRzCQYAAAAAAAAABfn///8lU3RlZW1hLlRlZUNoYXJ0LlN0eWxlcy5WYWx1ZUxpc3RPcmRlcgEAAAAHdmFsdWVfXwAIAgAAAAEAAAAAAAAAAAAF+P///yRTdGVlbWEuVGVlQ2hhcnQuU3R5bGVzLlBvaW50ZXJTdHlsZXMBAAAAB3ZhbHVlX18ACAIAAAAAAAAAAAAAAAX3////JlN0ZWVtYS5UZWVDaGFydC5TdHlsZXMuQXJyb3dIZWFkU3R5bGVzAQAAAAd2YWx1ZV9fAAgCAAAAAAAAAAX2////FFN5c3RlbS5EcmF3aW5nLkNvbG9yBAAAAAV2YWx1ZQprbm93bkNvbG9yBXN0YXRlBG5hbWUAAAABCQcHAwAAAAAAAAAAAAAAIwABAAoIAAAAAfX////2////AACZ/wAAAAAAAAIACgYMAAAABnBvaW50MQHz////9v///wAAmf8AAAAAAAACAAoBAfL////2////AAAAAAAAAACNAAEACgHx////+P///wAAAAAJEAAAAAAAAAAGEQAAAAFZBhIAAAAdU3RlZW1hLlRlZUNoYXJ0LlN0eWxlcy5Qb2ludHMJEwAAAAAAAAAB7P////n///8BAAAAAAAAAAAAAev////4////AAAAAAAAAAAB6v////f///8AAAAAAen////2////AAAAAAAAAAAjAAEACggAAAAB6P////b///8ATQD/AAAAAAAAAgAKBhkAAAAGcG9pbnQyAeb////2////AE0A/wAAAAAAAAIACgEB5f////b///8AAAAAAAAAAE8AAQAKAeT////4////AAAAAAkdAAAAAAAAAAkRAAAA6AAAAGkAAAAB4f////b///8AAAAAAAAAADQAAQAKdgAAAAAAAAAAAAAAAAAAAAAABeD///8lU3lzdGVtLkRyYXdpbmcuVGV4dC5UZXh0UmVuZGVyaW5nSGludAEAAAAHdmFsdWVfXwAIAwAAAAAAAAAB3/////b///8AAAAAAAAAAKQAAQAKAQAF3v///yZTeXN0ZW0uRHJhd2luZy5EcmF3aW5nMkQuU21vb3RoaW5nTW9kZQEAAAAHdmFsdWVfXwAIAwAAAAEAAAAGIwAAAB5TdGVlbWEuVGVlQ2hhcnQuVG9vbHMuWm9vbVRvb2wB3P////b///8AAAAAAAAAAI0AAQAKBiUAAAAA8wEAAAYmAAAAHlN0ZWVtYS5UZWVDaGFydC5Ub29scy5ab29tVG9vbAHZ////9v///wAAAAAAAAAAjQABAAoJJQAAAPMBAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABEEAAAAAQAAAAYpAAAACFRlZUNoYXJ0DwYAAAAAAAAABg8QAAAAAAAAAAYPEwAAAAAAAAAGDx0AAAAAAAAABgs=\"></tchart:WebChart>");

    }

For the GetChart file please read Tutorial9 - ASP.NET Applications. You'll find the tutorials at TeeChart's program group.

[POP]

Hi,
We do not want to use Session variables in our web application.
Is there any way to get the Tee-chart displayed without using Session? i.e. without using GetChart.aspx?

What about the TempChartStyle.File option? As of now i have managed to get the png files created on my custom directory by making appropriate registry changes. However these pictures do not appear on the web page. instead a red cross appears.

Please advice.

Thanks,
POP

[Narcís]

Hi POP,

Please see my reply at your other thread.