How to: Bind a Chart to an XPO Data Source

  • 3 minutes to read

This tutorial demonstrates how a chart can be bound to an eXpress Persistent Objects (XPO) data source. XPO is a DevExpress technology that gives you the freedom to build true business objects without having to deal with the tedious complexities of mapping them onto database tables. eXpress Persistent Objects for .NET completely abstracts the database layer from the developer, leaving him or her fully in the object-oriented realm. With XPO, you can build applications that are compatible with multiple database systems (currently supported are: MS Access, MS SQL Server, MySQL, Oracle, PostgreSql, Firebird, PervasiveSQL, VistaDB, SQL Anywhere, Advantage, DB2 and Sybase) without making ANY changes to your code. For more information, refer to eXpress Persistent Objects.

To bind a chart to an XPO data source, do the following.

  1. Start MS Visual Studio (2008 or 2010), and create a new Windows Forms Application, or open an existing one.
  2. Add a chart to the form.
  3. From the DX.20.1: Data toolbox tab, drop the XPCollection component onto the form.

    HowTo_BindChartToXPO_0

  4. Now, switch from the design view of the form to its code, and declare the XPObject class descendant. For example, use the following code.

    
    using DevExpress.Xpo;
    // ...
    
    public class SeriesRecord : XPObject {
        public string Argument;
        public int Value;
    }
    
  5. To populate the data source, handle the Form1_Load event using the following code.

    
    private void Form1_Load(object sender, EventArgs e) {
        for (int i = 1; i < 11; i++) {
            SeriesRecord record = new SeriesRecord();
            record.Argument = "Item " + i.ToString();
            record.Value = i;
            xpCollection1.Add(record);
        }
    }
    
  6. Rebuild the application so that this object can be used for the XPCollection.
  7. Set the ObjectClassInfo property of the XPCollection object to the SeriesRecord object.

    HowTo_BindChartToXPO_2

  8. Now, set the ChartControl.DataSource property to this XPCollection object.

    HowTo_BindChartToXPO_3

    And, define where the chart's series should obtain data for its points' arguments and their values, set the SeriesBase.ArgumentDataMember property to Argument, and the SeriesBase.ValueDataMembers property to Value.

    HowTo_BindChartToXPO_4b

The chart is now bound to the XPO data source, and the result is shown in the following image.

HowTo_BindChartToXPO_5

TIP

A complete sample project is available in the DevExpress Code Examples database at http://www.devexpress.com/example=E1576.