To filter the categories from the data, complete the following steps:

1. From the Toolbox, double-click the ListBox control to add it to the form. Dock it to the left of the C1Chart control so it appears like the following:

   

2. Select the ListBox control and click on its smart tag to open the menu. Select Use Data Bound items and then in the Data Source drop-down listbox, select Categories from Other Data Sources>Project Data Sources>categoriesDataSet.

   

3. Set the DisplayMember to CategoryName.
4. Double-click on the ListBox to create a listbox1_SelectedIndexChanged event.
5. Add the following code in the listbox1_SelectedIndexChanged event to filter the CategoryID to the listbox when the user selects a category item:

   To write code in Visual Basic

   Visual Basic	Copy Code
   Private Sub listBox1_SelectedIndexChanged(sender As Object, e As System.EventArgs) Handles listBox1.SelectedIndexChanged If listBox1.SelectedIndex >= 0 Then Dim categoryID As String = Me.categoriesDataSet1.Categories(listBox1.SelectedIndex).CategoryID.ToString() Me.dataView1.RowFilter = "CategoryID = " + categoryID Me.c1Chart1.Header.Text = listBox1.Text End If End Sub

   To write code in C#

   C#	Copy Code
   private void listBox1_SelectedIndexChanged(object sender, System.EventArgs e) { if (listBox1.SelectedIndex >= 0) { string categoryID = this.categoriesDataSet1.Categories[listBox1.SelectedIndex].CategoryID.ToString(); this.dataView1.RowFilter = "CategoryID = " + categoryID; this.c1Chart1.Header.Text = listBox1.Text; } }

6. In the Form1_Load event add the following code to force the new calculation after the refill so the first category of product items, Beverages, appears rather than all of the unfiltered categories:

   To write code in Visual Basic

   Visual Basic	Copy Code
   'force the new calculation after the refill listBox1_SelectedIndexChanged(Me.listBox1, New EventArgs())

   To write code in C#

   C#	Copy Code
   //force the new calcuation after the refill listBox1_SelectedIndexChanged(this.listBox1, new EventArgs());

7. Run the application and select a category from the listbox to observe the chart filter the data.

Congratulations! You successfully bound data to the chart. In the next step you will modify the appearance of the chart.