Hello,

I need to include a chart that reads data from a table from sql database and display the chart in my webpage. how do I do that?

You may check this link which provide you chart solution for ASP.NET

http://www.codeproject.com/KB/custom-controls/webchart.aspx

Or you can look in to Reporting tools like Cyrstal Reports for .NET and Active Reports for .NET provide charting capabilities along with their reporting tools. There are also products designed specifically for generating charts, such as Dundas Charts for .NET and .net Charting.

hi i still dont understand how to do. i followed the instruction i received so many errors. any other ways to do it?

Hi shan1430,

According to the information in the article, this should be a control for ASP.NET 1.1. Are you using Visual Studio.NET 2003?

Hi shan,

According to the article, here are the steps to add the control to the ToolBox:

Select Customize Toolbox and go to the .NET Tab and browse for the .dll you compiled or either the pre-compiled dll setup by the installer. After selecting the .dll you will see an icon in the Toolbox.

Besides to use assembly in the GAC for the Http Module used by this control, you can follow this KB article:

How to install an assembly in the Global Assembly Cache in Visual Basic .NET or in Visual Basic 2005

It requires modifying the source project and rebuild the assembly.

Hope it helps.

i suggest you type "excel.application" in search engine. You can find some ways using Microsoft Excel creating your chart.

Good LuckY

Hi shan1430,

you can try Nevron Chart for .NET

Has examples for what you need here.

Here are three articles I wrote recently on MS Chart Control that is relevant to ASP.NET 3.5. BTW this is the latest Chart version from Microsoft. These articles shows you step by step how to go about displaying the data stored on your SQL Server 2008 in the chart. The emphasis is on learning the basic skills. You have both VB as well as C# codes to help you along. You also have example of design time configuration which does not need any code.

http://dotnetslackers.com/articles/sql/Importing-MS-Excel-data-to-SQL-Server-2008.aspx

http://dotnetslackers.com/articles/aspnet/Microsoft-Chart-with-ASP-NET-35-Part1.aspx

http://dotnetslackers.com/articles/aspnet/Microsoft-Chart-with-ASP-NET-35-Part2.aspx

If you are using Charts in Sql Server Reporting Services than I recommend my book, "Learn SQL Server Reporting Services 2008", a book which considerably lowers your learning curve.

You will find about the books and other articles on my site at:

http://hodentek.blogspot.com

Here is one I did that uses WMI to pull the data for the graph. It should be easy to substitute your database code for it.

http://forums.asp.net/p/1216939/2160451.aspx#2160451

 Steve