﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>FusionCharts Forum / FusionCharts v3 / Using FusionCharts / FusionCharts and ASP.NET  / Chart with strXML generated from GridView / Latest Posts</title><generator>InstantForum.NET v4.1.4</generator><description>FusionCharts Forum</description><link>http://www.fusioncharts.com/forum/</link><webMaster>support@fusioncharts.com</webMaster><lastBuildDate>Wed, 07 Jan 2009 17:41:49 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Chart with strXML generated from GridView</title><link>http://www.fusioncharts.com/forum/Topic7009-32-1.aspx</link><description>Hi Toshiyuki Saito,&lt;BR&gt;  Please build the XML again in the "sorted" event and re-render the chart. You can call createchart() [where this XML building and re-rendering of chart occurs] from GridView1_Sorted event. In createchart() please read data from grid view control object rather than the datasource. Please see the code below for createChart() which  you might use and modify in our application.&lt;/P&gt;&lt;P&gt;----------------------------------------------------------------------&lt;/P&gt;&lt;FONT color=#0000ff size=2&gt;&lt;P&gt;Protected&lt;/FONT&gt;&lt;FONT color=#000000 size=2&gt; &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;Sub&lt;/FONT&gt;&lt;FONT color=#000000 size=2&gt; GridView1_Sorted(&lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;ByVal&lt;/FONT&gt;&lt;FONT color=#000000 size=2&gt; sender &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;As&lt;/FONT&gt;&lt;FONT color=#000000 size=2&gt; &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;Object&lt;/FONT&gt;&lt;FONT color=#000000 size=2&gt;, &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;ByVal&lt;/FONT&gt;&lt;FONT color=#000000 size=2&gt; e &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;As&lt;/FONT&gt;&lt;FONT color=#000000 size=2&gt; System.EventArgs) &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;Handles&lt;/FONT&gt;&lt;FONT size=2&gt;&lt;FONT color=#000000&gt; GridView1.Sorted&lt;/FONT&gt;&lt;/P&gt;&lt;BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"&gt;&lt;P&gt;CreateChart()&lt;/P&gt;&lt;/BLOCKQUOTE&gt;&lt;P&gt;&lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;End&lt;/FONT&gt;&lt;FONT size=2&gt; &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;Sub&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT color=#0000ff size=2&gt;-------------------------------------------------------------------------&lt;/FONT&gt;&lt;/P&gt;&lt;FONT color=#0000ff size=2&gt;&lt;FONT color=#0000ff size=2&gt;&lt;P&gt;Public&lt;/FONT&gt;&lt;FONT color=#000000 size=2&gt; &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;Sub&lt;/FONT&gt;&lt;FONT size=2&gt;&lt;FONT color=#000000&gt; CreateChart()&lt;/FONT&gt;&lt;/P&gt;&lt;BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"&gt;&lt;P&gt;&lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;Dim&lt;/FONT&gt;&lt;FONT size=2&gt; strXML &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;As&lt;/FONT&gt;&lt;FONT size=2&gt; &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;New&lt;/FONT&gt;&lt;FONT size=2&gt; StringBuilder()&lt;/P&gt;&lt;P&gt;strXML.Append(&lt;/FONT&gt;&lt;FONT color=#a31515 size=2&gt;"&amp;lt;chart&amp;gt;"&lt;/FONT&gt;&lt;FONT size=2&gt;)&lt;/P&gt;&lt;P&gt;&lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;Dim&lt;/FONT&gt;&lt;FONT size=2&gt; i &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;As&lt;/FONT&gt;&lt;FONT size=2&gt; &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;Integer&lt;/P&gt;&lt;/FONT&gt;&lt;FONT size=2&gt;&lt;P&gt;&lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;For&lt;/FONT&gt;&lt;FONT size=2&gt; i = 0 &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;To&lt;/FONT&gt;&lt;FONT size=2&gt; GridView1.Rows.Count - 1&lt;/P&gt;&lt;BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"&gt;&lt;P&gt;strXML.Append(&lt;/FONT&gt;&lt;FONT color=#a31515 size=2&gt;"&amp;lt;set value='"&lt;/FONT&gt;&lt;FONT size=2&gt; &amp;amp; GridView1.Rows(i).Cells(1).Text &amp;amp; &lt;/FONT&gt;&lt;FONT color=#a31515 size=2&gt;"' label='"&lt;/FONT&gt;&lt;FONT size=2&gt; &amp;amp; GridView1.Rows(i).Cells(0).Text &amp;amp; &lt;/FONT&gt;&lt;FONT color=#a31515 size=2&gt;"' /&amp;gt;"&lt;/FONT&gt;&lt;FONT size=2&gt;)&lt;/P&gt;&lt;/BLOCKQUOTE&gt;&lt;P&gt;&lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;Next&lt;/P&gt;&lt;/FONT&gt;&lt;FONT size=2&gt;&lt;P&gt;strXML.Append(&lt;/FONT&gt;&lt;FONT color=#a31515 size=2&gt;"&amp;lt;/chart&amp;gt;"&lt;/FONT&gt;&lt;FONT size=2&gt;)&lt;/P&gt;&lt;P&gt;Literal1.Text = FusionCharts.RenderChart(&lt;/FONT&gt;&lt;FONT color=#a31515 size=2&gt;"FusionCharts/Column2D.swf"&lt;/FONT&gt;&lt;FONT size=2&gt;, &lt;/FONT&gt;&lt;FONT color=#a31515 size=2&gt;""&lt;/FONT&gt;&lt;FONT size=2&gt;, strXML.ToString(), &lt;/FONT&gt;&lt;FONT color=#a31515 size=2&gt;"ChartID"&lt;/FONT&gt;&lt;FONT size=2&gt;, &lt;/FONT&gt;&lt;FONT color=#a31515 size=2&gt;"350"&lt;/FONT&gt;&lt;FONT size=2&gt;, &lt;/FONT&gt;&lt;FONT color=#a31515 size=2&gt;"300"&lt;/FONT&gt;&lt;FONT size=2&gt;, &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;False&lt;/FONT&gt;&lt;FONT size=2&gt;, &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;False&lt;/FONT&gt;&lt;FONT size=2&gt;)&lt;/P&gt;&lt;/BLOCKQUOTE&gt;&lt;P&gt;&lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;End&lt;/FONT&gt;&lt;FONT size=2&gt; &lt;/FONT&gt;&lt;FONT color=#0000ff size=2&gt;Sub&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT color=#0000ff size=2&gt; &lt;/P&gt;&lt;/FONT&gt;&lt;/FONT&gt;</description><pubDate>Thu, 26 Jun 2008 05:41:24 GMT</pubDate><dc:creator>Arindam</dc:creator></item><item><title>Chart with strXML generated from GridView</title><link>http://www.fusioncharts.com/forum/Topic7009-32-1.aspx</link><description>Hi. I created a MSLine chart with strXML generated from the data displayed on GridView and it works fine.&lt;/P&gt;&lt;P&gt;I want to update the chart when GridView is sorted but it didn't work at all.&lt;/P&gt;&lt;P&gt;Can anybody tell me how to run createchart() whenerver I want to pull the triger like sorted or cliked?&lt;/P&gt;&lt;P&gt;I tried this but this didn't work. &lt;/P&gt;&lt;P&gt;[code]    Protected Sub GridView1_Sorted(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.Sorted&lt;/P&gt;&lt;P&gt;createchart()&lt;/P&gt;&lt;P&gt;    End Sub[/code]</description><pubDate>Tue, 24 Jun 2008 06:54:01 GMT</pubDate><dc:creator>tosaito</dc:creator></item></channel></rss>