Hi, all:

I need to do some statistics with data in SQL SERVER DB. Basically, we need to generate some graphs, eg. bar, pie and line, etc. How can I create these graphs and display them in my WebForm? Please help. Thanks in advance.

__________________
Jie

Dear friend:
make ur reports & graphs in Crystal Report & then add them in ur WebForm. ASPX file works fine with Crystal Report.

Always:),
Hovik Melkomian.

Thanks for help.
Always :)

You could also try using tables in html. I have found it very useful for simple bar charts.

Response.Write("<table>")
Do While DataReader.Read() ...
If DataReader("Percentage") < 10 Then
  strColor = "Red"
Else
  strColor = "Green"
End If
Response.Write("<tr><td>" & DataReader("Profit") & "</td><td width='100px'><img style='background-color:" & strColor & ";' src='pixel.gif' height='20px' width='" & DataReader("Percentage") & "px'></td>")
Loop
Response.Write("</table>")

The pixel.gif is a single pixel transparent gif. That way you can choose the colour for the bar. The above should give you the concept.

Regards

Skin

Using HTML tables to simulate a graph would probably be the easiest solution, however if you nee more flexibility you can always create an Image object, use draw your graph on it, and use it's Save method specifiy an ImageFormat that is renderable by the browser (png probably would be good). You could actually have the <img src='graphname?args=arg'> in you webpage and then a seperate IHttpServer object that generates the graph and returns a stream..

Regards,
Meredith Shaebanyan