How to: Bind a Chart to an XPO Data Source

• Jan 15, 2024
• 2 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 Microsoft Visual Studio, and create a new Windows Forms Application, or open an existing one.
2. Add a chart to the form.

3. From the DX.24.2: Data toolbox tab, drop the XPCollection component onto the form.

   

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.

   C#

   using DevExpress.Xpo;
   // ...
   
   public class SeriesRecord : XPObject {
       public string Argument;
       public int Value;
   }
   

   VB.NET

   Imports DevExpress.Xpo
   ' ...
   
   Public Class SeriesRecord
       Inherits XPObject
       Public Argument As String
       Public Value As Integer
   End Class
   

5. To populate the data source, handle the Form1_Load event using the following code.

   C#

   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);
       }
   }
   

   VB.NET

   Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs) _ 
   Handles MyBase.Load
       For i As Integer = 1 To 10
           Dim record As New SeriesRecord()
           record.Argument = "Item " & i.ToString()
           record.Value = i
           xpCollection1.Add(record)
       Next i
   End Sub
   

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.

   

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

   

   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.

   

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