Microsoft® Chart Controls
Need to know the role and benefits of Microsoft® Chart Controls?
Microsoft Chart Controls is closely related to the well known Dundas Data Visualization controls. Microsoft Chart Controls is mainly based on Dundas Chart source code version 5.5. Dundas is one of the leaders in data visualization and provides Chart, Map, Gauge and other visual controls for different Microsoft development platforms like ASP.NET, Windows Forms, SQL Reporting Services, and so on. Microsoft attained Dundas Data Visualization Intellectual Property in April 2007 and is integrating this technology in various Microsoft products. Microsoft Chart Controls like ASP.NET and Windows Forms are based on the source code acquired from Dundas. Microsoft Chart Controls is obtainable as a separate installation for DOTNET Framework 3.5 SP1 and it will be part of DOTNET Framework 4.0.
Here are more details about Microsoft Chart Controls and its role:
- Data binding using Microsoft Chart Controls
- Retrieval of data from a database
- Role of Microsoft Chart Controls
Data binding using Microsoft Chart Controls
Microsoft Chart Controls allows many different ways of populating data in the chart and it is essential to know the differences between them. When you add a fresh visualization in your application, the very first thing you do, is bind it to the data. Before jumping into the binding methods, you should look at the list of all the supportable data sources that can be used in chart binding methods.
Retrieval of data from a database
Microsoft Chart Controls should be used with the data retrieved from a database. The retrieval of data is done by a suitable query run against a database on the local host, XPHTEK, a SQL 2000 Server. By using ADO objects and a proper connection string, the data would be retrieved from the database. It should be noted that the chart uses the data from the SQL 2000 Server. Therefore, the SQL Server must be enabled.
Microsoft Chart Controls 6.0 is the MSChart20.ocx ActiveX Control, which you can use in VB 6.0 for creating charts. It graphically displays data and formats the different regions of the chart. Since it is not a standard control, it should be added from the components collection. Microsoft Chart Controls are by no means an easy to use interface. It is advised that you should look at the tutorial before doing some of the basic manipulations with this control.